view, you can optionally specify a list of target database and Applier error codes for the Data Replication Applier to ignore during apply processing of DML operations in SQL Apply mode.
Use this feature to force Data Replication to continue apply processing when specific database or Applier errors occur.
When the Applier encounters an error with an error code that is in the
Ignore Error Code
list, the Applier rolls back the current transaction. During the subsequent Applier cycle, the Applier applies each DML operation in the internal buffer individually and skips the DML operations that caused the error. After processing all of the DML operations in the internal buffer, the Applier switches back to the normal mode and applies subsequent DML operations that accumulate in the internal buffer all at one time.
Click the
Runtime Settings
tab >
Error Handling
view.
The following image shows this view:
Click
New
to create a rule.
Data Replication adds a row to the
Ignore Error Code
list box.
Enter the database-specific or Applier numeric error code.
For example, if you enter -204 for a DB2 for Linux, UNIX, and Windows target, the Applier ignores the DB2 -204 return code and continues processing.
For Oracle error messages with the prefix ORA, enter only the number that follows the prefix.