Skip to Content
0
Former Member
Nov 07, 2012 at 01:54 PM

3 dumps corresponding to dbif_rsql_sql_error

591 Views

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