Transaction rollbacks

Transaction rollbacks occur when the transaction isolation level is set to 3, but Adaptive Server cannot guarantee that concurrent transactions can be serialized. This type of exception generally results from system problems such as disk crashes and offline disks.

Table 6-7: Transaction rollbacks

Message

Value

Description

Your server command (process id #process_id ) was deadlocked with another process and has been chosen as deadlock victim. Re-run your command.

40001

Occurs when Adaptive Server detects that it cannot guarantee that two or more concurrent transactions can be serialized.