Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

3 dumps corresponding to dbif_rsql_sql_error

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

Former Member
Not what you were looking for? View more on this topic or Ask a question