Row Count Validation for SQL Statement Replication

You can specify how Replication Server responds to SQLDML row count errors that may occur during SQL statement replication.

SQLDML row count errors occur when the number of rows changed in the primary and replicate databases do not match after SQL statement replication. The default error action is to stop replication.

Use the assign action command at the primary site for the Replication Server error class to specify other error actions for SQLDML row count errors:

assign action 
   {ignore | warn | retry_log | log | retry_stop | stop_replication}
   for error_class
   to server_error1 [, server_error2]...

where:

error_class is the error class name for which the action is being assigned. You can specify Replication Server error classes such as the default rs_repserver_error_class error class.
server_error is the error number. You can specify error numbers for Replication Server.

For example, to assign the warn error action if Replication Server encounters error number 5186, enter:

assign action warn for rs_repserver_error_class to 5186

If there is a row count error, this is an example of the error message generated:

DSI_SQLDML_ROW_COUNT_INVALID 5186
Row count mismatch for SQLDML command executed on 'mydataserver.mydatabase'.
The command impacted 1000 rows but it should impact 1500 rows.