Ignoring replication errors

 Ignore replication errors (SQL)
  • Create a BEFORE trigger on the action that causes the known error. This trigger should signal an error.

    For example, if you want to ignore INSERT statement errors that occur when a table is missing a referenced column, create a BEFORE INSERT trigger that signals the SQLE_REMOTE_STATEMENT_FAILED SQLSTATE when the referenced column does not exist. The INSERT statement fails, but this failure is not reported in the SQL Remote Message Agent (dbremote) output log.

 See also