Bonjour,
J'ai toujours ce message d'erreur dans ma replication bien que j'essaie de faire un resume connection to skip tran.
Au niveau du rssd, voici le message exact dans la log des exceptions:E. 2010/01/21 14:29:14. ERROR #5149 DSI EXEC(113(1) TST_SQL.IRP) - /dsiexec.c(3673)
Function 'rs_get_textptr' for 'LINE' returned no rows.
I. 2010/01/21 14:29:14. The DSI thread for database 'TST_SQL.IRP' is shutdown.
I. 2010/01/21 14:29:36. The DSI thread for database 'TST_SQL.IRP' is started.
I. 2010/01/21 14:29:37. DSI: detecting loss for database 'TST_SQL.IRP' from origin '104 ' date = 'Dec 7 2009 1:51:59:700AM', qid=0001001d84c433660073a67e00130073a67e000f00009cd8001ec2a60000000000000001.
I. 2010/01/21 14:29:37. DSI: detecting loss for database 'TST_SQL.IRP' from origin '111 ' date = 'Jun 12 2009 11:11:28:400AM', qid=000200011ed228c8000e4937000b000e4937000500009c2600b86cf80000000000000001.
I. 2010/01/21 14:29:37. DSI: detecting loss for database 'TST_SQL.IRP' from origin '109 ' date = 'Nov 24 2009 3:31:58:983PM', qid=00010011e0189fd8004d95e70008004d95e0000e00009ccb00fffa0f0000000000000001.
I. 2010/01/21 14:29:37. DSI: detecting loss for database 'TST_SQL.IRP' from origin '108 ' date = 'Nov 24 2009 4:05:25:676PM', qid=0001001d22b9417f007ba346000f007ba346000c00009ccb010929a700000000ffff0000.
I. 2010/01/21 14:29:37. The first transaction for database 'TST_SQL.IRP' has been logged into the exceptions log and skipped.
E. 2010/01/21 14:30:12. ERROR #5149 DSI EXEC(113(1) TST_SQL.IRP) - /dsiexec.c(3673)
Function 'rs_get_textptr' for 'LINE' returned no rows.
I. 2010/01/21 14:30:12. The DSI thread for database 'TST_SQL.IRP' is shutdown.
voici ci-dessous une des colonnes qui contient le champ texte dans la repdef de la table LINE:A0126 04utf8distribute 1 ~";Jan 21 2010 9:46:25:690AM,2 ~"!,3 1 begin transact
ion ~"%_upd npw ~"(TSO osid 423
begin transaction
A0126 04utf8distribute 2 ~"!,3 1 applied ~!.LINE.~!*rs_update yieldin
g min_before ~$(line_id=145443195, ~$%note=hastext rep_if_changed nulla
ble , ~$.cal_timestamp=~"120100112T150722Z after ~$.cal_timestamp=~"120
100121T094626Z
update LINE set cal_timestamp='20100121T094626Z' where line_id=1454431
95
A0126 04utf8distribute 2 ~"!,3 1 applied ~!.LINE.~!-rs_writetext appe
nd first last changed with log textlen =1hastext ~$%note=~.!!"
select note from LINE where line_id=145443195
A0126 04utf8distribute 1 ~";Jan 21 2010 9:46:25:690AM,2 ~"!,3 1 commit transac
tion
execute rs_update_lastcommit @origin = 114, @origin_qid = 0x000100012802e2c2000
de86b000e000de86b000000009d0500a1113b0000000000000001, @secondary_qid =
0x00000000000000000000000000000000000000000000000000000000000000000000
0000, @origin_time = '20100121 09:
46:25:690'
commit transaction
Je voudrais savoir ce qui explique ce message d'erreur Function 'rs_get_textptr' for 'LINE' returned no rows. suivi quelque secondes plutart des messages sur les detection loss et comment faire pour y remedier.
ColumName Datatype Length Nullable
Options
------------------------------ ------------------------------ ------ --------
--------------------
note text 0 not null
always_replicate
locked smallint 2
-------------------
Merci.
Partager