When a conflict arises, especially the "0 rows affected" conflict, it may be useful to view the opened uncommitted transactions on APPLY.

This can be done with the List transactions command.

When the Transaction ID of the INSERT statement is found, then the record can be committed with:

dbvrep> apply commit transaction xxx

This will then cause the update statement to proceed as the insert statement is now committed on the target database.

The transaction can also be rolled back with command:

dbvrep> apply rollback transaction xxx

If uncommitted transactions happen on a frequent basis, please Contact Support

Ensure the implications of committing or rolling back the transactions are understood before issuing these commands.

Browser not supported