06-01-2011 6:21 AM
Hi Experts,
We are getting the below runtime error while a background job is run.
SQL error "-911" when accessing table "DD02L".
Error Text of the Database: "SQL0911N The current transaction has been rolled
back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001 row=1"
The error is happening at a delete statement.
Please let me know what might be the reason of this error and how this can be resolved.
Thanks,
Jissa.
06-01-2011 6:28 AM
Hi,
The system is taking very long for processing delete statement.
can u send me ur code, so based on that i will give u some idea.
Ram.
06-01-2011 8:45 AM
it may be due to syntax error or else the given table may be locked
thanking you