HI Experts,
I have 3 runtime errors in production for the same user that has occurred over the course of last 2 weeks.
Dump details:
Category: Installations Errors
Runtime Error: dbif_rsql_sql_error
Except.: cx_sy_open_sql_db
Short Text:
SQL error "-911" when accessing table /USE/PATI_TRMSTN ( DD02Land DD03L in other two cases)
What happened?
Error Text of the Database: "SQL0911N The current transaction has been rolled
back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 row=1"
What happened?
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"
What happened?
Error Text of the Database: "SQL0911N The current transaction has been rolled
back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 row=1"
Source Code points to DELETE operation on the above mentioned tables.
Error analysis
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught
in
procedure "TABL_SOURCE_DEL" "(FORM)", nor was it propagated by a RAISING
clause.
Since the caller of the procedure could not have anticipated that the
exception would occur, the current program is terminated.
The reason for the exception is:
Error Text of the Database: "SQL0911N The current transaction has been rolled
back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 row=1"
Error analysis
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught
in
procedure "DELETE_DATA" "(METHOD)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated that the
exception would occur, the current program is terminated.
The reason for the exception is:
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"
Error analysis
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught
in
procedure "TABL_SOURCE_DEL" "(FORM)", nor was it propagated by a RAISING
clause.
Since the caller of the procedure could not have anticipated that the
exception would occur, the current program is terminated.
The reason for the exception is:
Error Text of the Database: "SQL0911N The current transaction has been rolled
back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 row=1"
The dump mentions deadlock and timeout.
Please let me know how I can rectify this, OSS notes if any would be of great help.
Thanks in advace,
Peter