Reg DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

[Former Member]

We are getting lot of below run time error while querying on TVARVC table in production system.

Runtime Errors         DBIF_RSQL_SQL_ERROR

Exception              CX_SY_OPEN_SQL_DB

Database error text........: "SQL0911N The current transaction has been rolled

  back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001"

code where the error is generating

Select Query:

SELECT SINGLE low FROM  tvarvc

              INTO  variable

              WHERE name = xx AND

                    type = yy           AND

                    numb = zz

or

SELECT SINGLE low FROM  tvarvc

              CLIEN SPECIFIED

              INTO  variable

              WHERE

                    mandt = sy-mandt

                    name = xx AND

                    type = yy           AND

                    numb = zz

I have looked into SCN but couldnt find any info specific to my scenario.

Kindly provide your inputs.

[Former Member]

We are getting lot of below run time error while querying on TVARVC table in production system.

Runtime Errors         DBIF_RSQL_SQL_ERROR

Exception              CX_SY_OPEN_SQL_DB

Database error text........: "SQL0911N The current transaction has been rolled

  back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001"

code where the error is generating

Select Query:

SELECT SINGLE low FROM  tvarvc

              INTO  variable

              WHERE name = xx AND

                    type = yy           AND

                    numb = zz

or

SELECT SINGLE low FROM  tvarvc

              CLIEN SPECIFIED

              INTO  variable

              WHERE

                    mandt = sy-mandt

                    name = xx AND

                    type = yy           AND

                    numb = zz

I have looked into SCN but couldnt find any info specific to my scenario.

Kindly provide your inputs.

[Former Member]

If it is a deadlock, contact your basis. In our environment, deadlock often came when large trnasports were importoed to the system - you can check the stms too.

[Former Member]

This message was moderated.

[Private_Member_7726]

IBM help says Reason code 68 is for lock timeout - was the program "hanging" for some time, could it be someone (or something) is locking the Variant?

If you have authorization, you can see deadlocks and lock waits in ST04