Row count validation error messages display table names.
id | name | age |
---|---|---|
1 | John | 40 |
2 | Paul | 38 |
3 | George | 37 |
update ThisTableHasANameLongerThan30Characters set age = 20
Continuous mode log-order row-by-row replication:
I. 2010/06/07 01:30:21. DSI received Replication Server error #5185 which is mapped to WARN by error action mapping.
W. 2010/06/07 01:30:21. WARNING #5185 DSI EXEC(103(1) ost_replnx6_61.rdb1) - /dsiexec.c(11941)
Row count mismatch for the command executed on 'ost_replnx6_61.rdb1'. The command impacted 0 rows but it should impact 1 rows.
If you turn on the DSI_CHECK_ROW_COUNT_FULL_NAME trace to enable the maximum table name length of 255 bytes that the error message can display, the last line of the error message displays the full table name:
I. 2010/06/07 02:22:55. The error was caused by output command #3 of the failed transaction on table 'dbo.ThisTableHasANameLongerThan30Characters'.
HVAR or RTL replication:
W. 2010/06/07 02:06:56. WARNING #5185 DSI EXEC(103(1) ost_replnx6_61.rdb1) - i/hqexec.c(4047)
Row count mismatch for the command executed on 'ost_replnx6_61.rdb1'. The command impacted 1 rows but it should impact 2 rows.
I. 2010/06/07 02:06:56. (HQ Error): update ThisTableHasANameLongerThan30Characters set age = w.age from ThisTableHasANameLongerThan30Characters t,#rs_uThisTab...
I. 2010/06/07 02:06:57. The DSI thread for database 'ost_replnx6_61.rdb1' is shutdown.