topic Re: Reg DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB in Application Development and Automation Discussions

Reg DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

Former Member — Thu, 27 Feb 2014 12:49:31 GMT

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

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.

Re: Reg DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

Former Member — Thu, 27 Feb 2014 13:11:38 GMT

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.

Re: Reg DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

Former Member — Thu, 27 Feb 2014 20:16:05 GMT

This message was moderated.

Re: Reg DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

Private_Member_7726 — Thu, 27 Feb 2014 21:57:45 GMT

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