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 Sanjeev,

I suppose this is master data load for you.

Sometimes there might be a fight between the resources and hence running a load might dump out due to timeout error and may throw a deadlock error.

I would suggest you to check for this dump in ST22 and then decide further actions according to the log mentioned there.

Best Regards,

Arpit

[Former Member]

is there a solution of steps to resolve the issue?

[Former Member]

Hi Sanjeev,

There might be various solutions.

If this is a master data load, try to repeat the failed step.

If this is a transaction data, take the required steps to delete old data and then try to repeat again.

If this is still failing, you need to check the log in ST22 as already adviced.

Also you might try to split the data load on basis of selections and then try as well.

Best Regards,

Arpit