Background documentation600: Work rolled back Locate this document in the navigation structure

 

Explanation

Your transaction was implicitly canceled and rolled back by an implicit ROLLBACK statement because

  1. you failed to carry out any operations within a certain period of time, but held locks which other users were waiting for, or because

  2. the database instance was in a deadlock situation. A deadlock situation is a situation in which two or more users hold locks and request further locks that are held by the respective other users. In the simplest case of two users, one user holds one lock at least and requests another lock. But this lock is held by another user who, on the other hand, waits for the lock held by the first user. This situation can only be resolved if one of the users releases the lock already obtained.

User Response

In some cases, the error message contains a more detailed description of the error.In both cases, the lock requests must be checked and modified, if necessary. The last transaction must be repeated.