"DBIF_RSQL_SQL_ERROR" with exception "CX_SY_OPEN_SQL_DB

[former_member949224]

Hi Experts,

When i execute program in server i am getting "DBIF_RSQL_SQL_ERROR" with exception "CX_SY_OPEN_SQL_DB".

I have pasted the error log from st22

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 25.08.2011 10:26:26

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........: "ORA-01115: IO error reading block from file 33

(block # 344496)#ORA-01110: data file 33:

'D:\ORACLE\I01\SAPDATA1\SR3_30\SR3.DATA30'#ORA-27091: unable to queue

I/O#ORA-27070: async read/write failed#OSD-04006: ReadFile() failure, unable

to read from file#O"

Internal call code.........: "[RSQL/INSR/TBTCP ]"

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"

"SAPLBTCH" or "LBTCHFXX"

"STORE_NEW_STEPLIST_IN_DB"

I have pasted error log from sm21

10:00:03 DIA 001 000 SAPSYS BY 4 Database error 1115 at INS access to table TBTCP

10:00:03 DIA 001 000 SAPSYS BY 0 > ORA-01115: IO error reading block from file 33 (block #

10:00:03 DIA 001 000 SAPSYS BY 0 > 344496)#ORA-01110: data file 33:

10:00:03 DIA 001 000 SAPSYS BY 0 > 'D:\ORACLE\I01\SAPDATA1\SR3_30\SR3.DATA30'#ORA-27091: unable

10:00:03 DIA 001 000 SAPSYS BY 0 > to queue I/O#ORA-27070: async read/write failed#OSD-04006:

10:00:03 DIA 001 000 SAPSYS BY 0 > ReadFile() failure, unable to read from file#O/S-Error: (OS

10:00:03 DIA 001 000 SAPSYS BY 0 > 23) Data error (cyclic redundancy check).

10:00:03 DIA 001 000 SAPSYS AB 0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred

10:00:03 DIA 001 000 SAPSYS AB 1 > Short dump "110825 100003 ecc6_I01_01 SAPSYS " created

10:00:03 DIA 001 000 SAPSYS D0 1 Transaction Canceled 00 671 ( DBIF_RSQL_SQL_ERROR

20110825100003ecc6_I01_01 SAPSYS 000 )

I am Basis Administrator,so please do the needful.

Regards

Asshok R

[vincentlim826]

Hi,

In almost all cases, this error is caused by hardware or operating system problems. Check the system, together with your

hardware partner and operating system partner, to correct the cause of the problem. Then carry out a consistency check on the entire database, as described in SAP Note 23345, try remove any inconsistencies using Note 365481 and restore the affected files from a backup.

Br, Vincent