Replication Server 15.5 changes the default error actions for the 5185 and 5187 error numbers from “warn” to “stop replication” and adds 5203 for Replication Server error classes.
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. |
stop_replication |
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. |
stop_replication |
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. |
5203 |
Row count mismatch on ‘dataserver.database’. The delete command generated by dsi_command_convert deleted x rows, whereas it should delete y rows. |
stop_replication |
This message appears if the number of rows deleted is different from the expected number of rows to be deleted. |
Use the assign action command at the primary site for the Replication Server error class to override the default error action.
With Replication Server 15.5, you can alter a Replication Server error class using alter error class.
See “Row count validation for non-SQL statement replication,” in Chapter 2 “New Features in Replication Server Version 15.2” in this book and Chapter 6, “Handling Errors and Exceptions” in the Replication Server Administration Guide Volume 2.
For details about commands, parameters, stored procedures, and system tables, see the Replication Server Reference Manual.
