Error Actions for SQL Statement Replication

Replication Server supports several error actions for SQL statement replication errors.

Error Actions for SQL Statement Replication

server_error

Error Message

Default Error Action

Description

5186

 
Row count mismatch for
the command executed on
‘dataserver.database’.
The command impacted x
rows but it should
impact y rows.

stop_replication

Row count verification error for SQL statement replication if the affected number of rows is different from what is expected.

5193

 
You cannot enable
autocorrection if SQL
Statement Replication
is enabled.  Either
enable SQL Statement
Replication only or
disable SQL
StatementReplication
before you enable
autocorrection.

stop_replication

Cannot enable autocorrection if SQL statement replication is enabled. Either enable SQL statement replication only or disable SQL statement replication before you enable autocorrection
Parent topic: Row Count Validation for SQL Statement Replication