DBIF_RSQL_SQL_ERROR

[Former Member]

Hi All SAP experts,

My company has implemented 2 Systems SAP Landscape with one development and one production server which are running on R/3 Enterprise 4.7 (Kernel Release 6.20) with Microsoft SQL 2000 as database server.

Started last week, the Production system have generated many system logs as shown below:

Database error 0 at FET

Run-time error "DBIF_RSQL_SQL_ERROR" occurr

Database error 3624 at SEL access to table

Also, the production server has recorded the following runtime errors:

Runtime Errors : DBIF_RSQL_SQL_ERROR

Exception : CX_SY_OPEN_SQL_DB

Database error text........: "[601] Could not continue scan with NOLOCK due to data movement."

This only happened to some tables. Users transactions are affected.

Kindly advise what has went wrong with my system.

Thanks.

regards,

Leon

[Former Member]

Hi Leon,

Have you checked the below note ?

Note 965530 - 601 Errors in SQL Server

Seems there is some inconsistency at physical level. Try the resolutions given in the note and if you unable to resolve, then raise a message according to the note.

Cheers...,

Raghu