Display Table Names in Row Count Validation Error Message

If you are using:

• Continuous mode log-order row-by-row replication – Replication Server logs and displays the table name, table owner name, and the number that identifies the output command that caused the transaction to fail. Replication Server logs only the first 30 bytes of the table name. You can enable the DSI_CHECK_ROW_COUNT_FULL_NAME trace to expand the maximum length of the table name that displays to 255 bytes.
• High volume adaptive replication (HVAR) or real-time loading (RTL) – Replication Server logs and displays the internal join-update and join-delete statements that result from HVAR and RTL compilation. You cannot obtain the specific command that caused the failed transaction since HVAR or RTL have already compiled the command as part of HVAR and RTL processing. The maximum length of the join-update and join-delete statements that can display is 128 bytes including the "...\0" tail string.

This example consists of:

• Primary site – pdb1 primary database with a table named ThisTableHasANameLongerThan30Characters that has three columns and three rows.

  id	name	age
  1	John	40
  2	Paul	38
  3	George	37

• Replicate site – rdb1 primary database with a table with the same name ThisTableHasANameLongerThan30Characters that has two rows with values of 1 and 3 for the id column.

If you execute this command against pdb1:

update ThisTableHasANameLongerThan30Characters set age = 20

the error messages appear differently for each type of replication mode. In:

• 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.

  I. 2010/06/07 01:30:21. The error was caused by output command #3 of the failed transaction on table 'dbo.ThisTableHasANameLongerThan30C'.

  Note: The table name is truncated to the default of 30 bytes.

  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.