Database error text SQL0911N

[Former Member]

Hi,

How will you resolve this error.

Database error text SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001 row=1 RSRL/UPDT//BIC

Runtime Errors DBIF_RSQL_SQL_ERROR
Except.        CX_SY_OPEN_SQL_DB
SQL0911N deadlock

[Former Member]

Hi,

The dead lock problem is like 2 process both require table A and B.

Process 1 locked table A and waiting for table B, while process 2 locked table B and waiting for table A.

As both process waiting for the other process to release, so it will wait forever and the system solve this problem by killing one of them, and the process being killed got the error you mentioned.

So... back to your question, to solve your problem there are 2 parts

1) For the data loading or process failed

You may just retry it now, as the other process most likely ended

2) To prevent it from happen again

You may need to check the process/loading occur at the time period and re-schedule them to prevent the process to lock each other again, for how to locate the process, it is all about your knowledge to the system, so help we can offer are limited

Regards

Bill