DBIF_RSQL_SQL_ERROR(SQL Error occured 11,WP in Reconnect status)

[Former Member]

Hi Experts,

I am working on SAP/R3 on Windows platform.

I am getting dumps "DBIF_RSQL_SQL_ERROR" .

While investigated in dumps its showing as
Short Text
    "SQL error in the database when accessing a table ".
                    (and)
How to correct the error
    Database error text........: "[0] Connection failure"
    Internal call code.........: "[RSQL/FTCH/KNA1 ]"
    Please check the entries in the system log (Transaction SM21).

while i have checked the SQL ERROR LOG at the partuclar time when the
dumps occured its showing Error 50000,Severity 1.

It is Production system but we are getting this dumps more in ECC R/3
system and mean while ome job got failed due to this error .

Operating system is : windows 32bit
Database : MSSQL

Please advice how to solve this dumps and avoid this .

I have attached dumps,relevant system log, SQL error log all
information in the excel sheet .

Thanks

DUMPS.txt.zip

[Brindavan_M]

Hi Leelaprasad,

Even we have faced this problem many times frequently the dumps will occur. In such case sometime the filssytem mighbe full like " /oracle/SID/orrach" or it might be /usr/sap/SID". Some time overload of accessing the sam table with z* program. Better restart the sap system and clean the shared memory.

Thanks,

Brindavan

[Former Member]

Thanks Brindavan,

But i have noticed that usr/sap/sid*** is enough space available .\

Thanks

Leela

[Brindavan_M]

Hi Leela,

Could you please check the dumps are geeting frequently in T-code ST22 and check in DB02 database check which query having error. Check the BG job and which users geting this issue. if you the dumps occuring frequently better restart the system and clean the shared memory.

if possible attache the full log(ABAP dump) log.

Thanks,

Brindavan

[Former Member]

Hi Brindavan

Please find the dump log .

Runtime Errors         DBIF_RSQL_SQL_ERROR
Exception              CX_SY_OPEN_SQL_DB
Date and Time          03.11.2014 03:00:49

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........: "[0] Connection failure"
     Internal call code.........: "[RSQL/FTCH/KNA1 ]"
     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:

Please advice how to check the SQL query n DB02 T.code.

Thanks

Leela

[Brindavan_M]

Hi Leela,

Based of this log I found that "SQL error in the database when accessing a table" . could you please check tablesapce as well having enough space.

Please refre the below link give more details.

How to run SAP transaction ST04 – database performance monitor | SAP application performance

Thanks,

Brindavan

[Sriram2009]

Hi

During off peak time run the MS SQL DBCC Check command at DB level , Before starting the process take the full backup of you database.

Refer the SAP Note

142731 - DBCC checks of SQL server

BR

SS

[Former Member]

Hi Sriram,

It is windows system .

Thanks

leela

[Sriram2009]

Hi

Yes

BR

SS

[Former Member]

Hi Sriram,

Please advice me ,

Can you please explain what exactly this DBCC Check command will work ?

And tell the steps how i need to run this in windows system ?

Thanks

Leela

[Sriram2009]

Hi

You have to open the MS Sql management console, Select the database - open the query console - type the command "DBCC CHECKDB" before starting this take full backup of DB

BR

SS

[Former Member]

Sriram,

I am unable to see the query console .....

Thanks

leela

[Former Member]

Hi Leelaprasad,

Can you provide complete dump log and failure job log to know more.

Thanks,

Venkat

[Former Member]

Hi Venkat,

Job Log :

Job log overview for job:    Z_FI_Y_RD2_01000176 / 03001200

Date       Time     Message text                                                                                   Message class Message no. Message type

03.11.2014 03:00:07 Job started                                                                                         00           516          S
03.11.2014 03:00:12 Step 001 started (program AQICCST_GLTEAM==CUST_OPEN_BAL=, variant PRE-MACRO, user ID HCLADMIN)      00           550          S
03.11.2014 03:00:49 Internal session terminated with runtime error DBIF_RSQL_SQL_ERROR (see ST22)                       00           671          A
03.11.2014 03:00:49 Job cancelled                                                                                       00           518          A

Thanks

Leela