Skip to Content

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

DBIF_RSQL_SQL_ERROR dump triggering in BI system

Hi Friends,

We are facing a database error issue in our  BI production system. can you please find the below ST22 - ABAP dump error details.

Runtime Errors        DBIF_RSQL_SQL_ERROR

Exception              CX_SY_OPEN_SQL_DB

User and Transaction

    Client.............. 100

    User................ "BWREMOTE"

    Language Key........ "O"

    Transaction......... " "

    Transactions ID..... "505BD76BC3A2010EE10080000AFC4286"

Information on where terminated
    Termination occurred in the ABAP program "SAPLRRHI" - in "HIEDIR_SVER_DELETE".
    The main program was "SAPMSSY1 ".

    In the source code you have the termination point in line 101
    of the (Include) program "LRRHIF00".
    The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
    procedure "HIEDIR_SVER_DELETE" "(FORM)", but it was neither handled locally nor
    declared
    in the RAISING clause of its signature.

    The procedure is in program "SAPLRRHI "; its source code begins in line
    97 of the (Include program "LRRHIF00 ".

SM21 logs.

Time    Type Nr  Clt User      TCode Priority Grp N Text

20:36:43 DIA  001 100 BWREMOTE                BY  O Deadlock occurred
20:36:44 DIA  001 100 BWREMOTE                BY  4 Database error -911 at DEL access to table RSRHIEDIR_
20:36:44 DIA  001 100 BWREMOTE                BY  0 > SQL0911N The current transaction has been rolled back
20:36:44 DIA  001 100 BWREMOTE                BY  0 > because of a deadlock or timeout. Reason code "2".
20:36:44 DIA  001 100 BWREMOTE                BY  0 > SQLSTATE=40001 row=1
20:36:45 DIA  001 100 BWREMOTE                AB  0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred
20:36:45 DIA  001 100 BWREMOTE                AB  1 > Short dump "120923 203645 dap-dof-bw01_BP1_10 BWREMOTE " created

Can you please help me, what are the necessary actions , we need to perform to solve this issue.

regards,

balaram

error dump.txt.zip (14449 B)
Former Member

Helpful Answer

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