Ignoring database errors when applying data changes to the target for all subscriptions

Procedure

  1. Ensure that you your target database is not using a CDC Replication Engine for Db2® for z/OS®.
  2. Ensure you know the database error code which is returned by the SQLException class in JDBC. This error code is database vendor-specific and always an integer, such as ORA-00001.
  3. Start Management Console and log into Access Server.
  4. Click Configuration > Datastores.
  5. Right-click on the datastore for your target database and select Properties.
  6. Select mirror_expected_errors_list from the System Parameters tab.
  7. Click Modify.
  8. Type the integer error code returned by the SQLException class in JDBC that you want to ignore, in the Value box. Specify multiple error codes with a comma separated list.
    Notes:
    • Ensure that you only configure the parameter to ignore errors that you are certain are safe to ignore (such as unique constraint ORA-00001).
    • Latency may increase when using this system parameter since CDC Replication will not use JDBC array apply in order to track the errors specified.