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

[abdullahqureshi]

I think data volume is huge so try with applying filter selection by some restrictions with reduced volume. Also increase the no. of parallel processing from setting of Batch manager in DTP and change the job class to 'A'.