Row Count Validation Changes

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.

New and Changed Errors

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 dataserver, 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.

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

Related concepts
Row Count Validation for Non-SQL Statement Replication