Versions Compared

Key

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

The conflict "Command affected 0 row(s)" is the most common type of conflict that can occur with replication. This conflict can be on a delete or update statement.

...

  1. The data not being in sync before the replication started?
  2. Someone else changed the data on the target?
  3. Open transactions on the target database. Please see Uncommitted transactions
  4. Check the page on NLS Considerations to see if the conflicts have occurred due to character set differences between source and target.

Going back in time

It also helps to understand when the column was changed on the source system. This can be done with the AS OF SCN statement. This has the affect of going back in time to see the history of changes for the particular value. 

...