Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The conflict id is the number shown in the status bar, the resolution can be one of the following:

IGNORE

...

skip the transaction
RETRY

...

try again
ABORT

...

abort the apply whole process
RESTART

...

rollback and restart the transaction
ROLLBACK

...

rollbacks the transaction
IGNOREALL

...

The current and future conflicts in the same transaction will be resolved as ignore


To see the SQL that is causing the conflict, logon to the apply (target database) as the Dbvisit Replicate schema owner (dbvrep) and query table:

DBRSAPPLY_CONFLICT_LOG

This lists all the conflicts encountered, including failing SQL.