DBIF_RSQL_SQL_ERROR (CX_SY_OPEN_SQL_DB)

[Former Member]

Hi Friends,

I am getting an error in ECC system.

Runtime Errors         DBIF_RSQL_SQL_ERROR

Exception              CX_SY_OPEN_SQL_DB

Date and Time          2013.02.11 15:00:37

Short text

     SQL error in the database when accessing a table.

What can you do?

     Note which actions and input led to the error.

      For further help in handling the problem, contact your SAP administrator

     You can use the ABAP dump analysis transaction ST22 to view and manage

     termination messages, in particular for long term reference.

How to correct the error

     Database error text........: "SQL0952N Processing was cancelled due to an

      interrupt. SQLSTATE=57014 row=1"

     Internal call code.........: "[RSQL/FTCH/SWW_WI2OBJ ]"

     Please check the entries in the system log (Transaction SM21).

     If the error occures in a non-modified SAP program, you may be able to

     find an interim solution in an SAP Note.

     If you have access to SAP Notes, carry out a search with the following

    keywords:

     "DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

    "CL_SWF_REP_OBJECTS2ITEMS======CP" or "CL_SWF_REP_OBJECTS2ITEMS======CCIMP"

    "READ"

    If you cannot solve the problem yourself and want to send an error

   The exception must either be prevented, caught within proedure

   "READ" "(METHOD)", or its possible occurrence must be declared in the

   RAISING clause of the procedure.

   To prevent the exception, note the following:

[Former Member · Accepted solution]

Hi,

Please check whether the below note will be helpful.

Note 1300463 - Prevent the CX_SY_OPEN_SQL_DB exception

Please let us know under which sequence you are facing this dump.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi Vimal,

During Daily Monitoring of the system I have found these dumps (I am a Basis Consultant).

I have gone through the note, but corrections said are for 7.10 but my current system release is 7.0.

Thanks and Regards,

Vijay

[Former Member · Accepted solution]

Hi,

Please specify the Tcode you are facing the issue.

As well as what is your DB?

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

If possible please download the entire ABAP Dump and attach it.

[Former Member · Accepted solution]

Hi Vimal,

Thanks For Quick Response.

We are Using DB2 database ( Database version. "DB6_81 "; Patch level. 300)

User and Transaction

    Client.............. 700

    User................ "A675CN"

    Language key........ "V"

    Transaction......... "SO01 "

    Transactions ID..... "511A355638F617E0E10080000A281E0C"

    Program............. "CL_SWF_REP_OBJECTS2ITEMS======CP"

    Screen.............. "SAPLSINWP 1000"

    Screen line......... 2

Information on where terminated

    Termination occurred in the ABAP program "CL_SWF_REP_OBJECTS2ITEMS======CP" -

     in "READ".

    The main program was "SAPMSSO0 ".

    In the source code you have the termination point in line 72

    of the (Include) program "CL_SWF_REP_OBJECTS2ITEMS======CCIMP".

    The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

    procedure "READ" "(METHOD)", but it was neither handled locally nor declared

    in the RAISING clause of its signature.

   The procedure is in program "CL_SWF_REP_OBJECTS2ITEMS======CP "; its source

     code begins in line

Thanks and Regards,

Vijay

[Former Member · Accepted solution]

Hi Vijay,

Please check the below note and see whether it helps or not.

Note 1387865 - DB6: Timeout for CREATE/DROP TRIGGER

Please check and provide your feedback.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Hi,

Please check the following

1) You have free space in archive log directory

2) you have free space in the tablespace of your database.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

Please check the below link too... Might be helpful to you.

http://www-01.ibm.com/support/docview.wss?uid=swg21424265

Thanks and Regards,

Vimal