Transaction error - a possible conflict forced a rollback
This message appears when a user attempts to commit database changes that conflict with changes committed by one or more other concurrent user connections to the same database. There will be an implicit ROLLBACK of any transactional changes made by the user receiving this error.
For example, say that
User 1
and
User 2
connect to a database at the same time. If
User 1
inserts data into
Table A
, and then
User 2
drops
Table A
and commits the change,
User 1
will receive this transaction error when committing the data insert because