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:
| No Format | ||
|---|---|---|
| ||
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:
| No Format | ||
|---|---|---|
| ||
dbvrep> apply rollback transaction xxx |
| Note |
|---|
If uncommitted transactions happen on a frequent basis, please Contact Support |
| Note |
|---|
Ensure the implications of committing or rolling back the transactions are understood before issuing these commands. |
Please also see http://support.dbvisit.com/hc/en-us/articles/215909798