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]...
server_error is the error number. You can specify error numbers for Replication Server.
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.