Command to Assign Error Actions

Use the assign action command at the primary site for the Replication Server error class to specify an error action.

Syntax

assign action 
   {ignore | warn | retry_log | log | retry_stop | stop_replication}
   for error_class
   to server_error1 [, server_error2]...

Parameters

error_class – the error class name for which the action is being assigned. With Replication Server 15.2, you can specify Replication Server error classes such as the default rs_repserver_error_class error class.
server_error – the error number.
You can specify these error numbers for Replication Server for error actions not related to SQL statement replication:

Examples

Example 1 – assigns the ignore error action if Replication Server encounters error number 5185:
```
assign action ignore for rs_repserver_error_class to 5185
```

Example 2 – assigns the warn error action if Replication Server encounters error number 5186:

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 that displays:

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.

Usage

See “assign action” and Table 3-17 , in Chapter 3, “Replication Server Commands” in the Replication Server Reference Manual.