Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SQL error "-911" while running background job

Former Member

‎2011 Jun 01 6:21 AM

0 Likes
1,133

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.

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.

Reply
2 REPLIES 2
Read only

Former Member

‎2011 Jun 01 6:28 AM

0 Likes
688

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.

Read only

Former Member

‎2011 Jun 01 8:45 AM

0 Likes
688

it may be due to syntax error or else the given table may be locked

thanking you