21
Attempt made to end a transaction that is idle or in the middle of an update.
This error occurs when a termination request event occurs during the processing of a transaction. Error 611 can be caused by:
Massive processing using group by or order by
A stored procedure that references other stored procedures (and is in the midst of calling those procedures) being dropped
An Adaptive Server problem
To determine what caused the error, check for:
dbcancel calls from within DB-Library exit processing routines that fail to test all error conditions
Users typing Ctrl-C during heavy use of temporary tables
Error 611 can produce a stack trace that shows some of the SQL that caused the error. Obtain the entire stack trace and any errors that occurred prior to or after the 611 error, to determine the internal process state at the time of the failure.
All versions
