Use the assign action command at the primary site for the Replication Server error class to specify an error action. See “assign action” and Table 3-17 , in Chapter 3, “Replication Server Commands” in the Replication Server Reference Manual.
assign action {ignore | warn | retry_log | log | retry_stop | stop_replication} for error_class to server_error1 [, server_error2]...
error_class is the error class name for which the action is being assigned, such as a Replication Server error class.
server_error is the error number. You can specify these error numbers for Replication Server for error actions not related to SQL statement replication:
server_error |
Error message |
Default error action |
Description |
---|---|---|---|
5185 |
Row count mismatch for the command executed on ‘dataserver.database’. The command impacted x rows but it should impact y rows.
|
warn |
This message appears if the affected number of rows is different from the expected number of rows, after a command that is not part of SQL Statement Replication, or a stored procedure, or a row change with autocorrection enabled is sent to the data server. |
5187 |
Row count mismatch for the autocorrection delete command executed on ‘dataserver.database'. The command deleted x rows but it should delete y rows. |
warn |
This message appears if the affected number of rows is different from the expected number of rows, after a delete command is sent to the data server, and if autocorrection is enabled. |
To assign the ignore error action if Replication Server encounters error number 5185, enter:
assign action ignore for rs_repserver_error_class to 5185