[REP 12.6] Function 'rs_get_textptr' for 'LINE' returned no rows.
Bonjour,
J'ai toujours ce message d'erreur dans ma replication bien que j'essaie de faire un resume connection to skip tran.
Citation:
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.
Au niveau du rssd, voici le message exact dans la log des exceptions:
Citation:
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
voici ci-dessous une des colonnes qui contient le champ texte dans la repdef de la table LINE:
Citation:
ColumName Datatype Length Nullable
Options
------------------------------ ------------------------------ ------ --------
--------------------
note text 0 not null
always_replicate
locked smallint 2
-------------------
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.
Merci.
