SQL error "SQL code: 601" occurred while accessing table "TST03M"

[Former Member]

Hello guys.

I have one system production SAP EHP7 for SAP ERP 6.0 on SQL MSSQL 11.00.3393.00. When i execute the transaction SP12 - TemSe Data Storage - Consistency Check show me the dump:

SQL error "SQL code: 601" occurred while accessing table "TST03M".

Database error text: "SQL message: Could not continue scan with NOLOCK due to data movement."

This my first system on SQL i´m checking the OSS note 965530 - 601 Errors in SQL Server but i´m not clear. In DEV and QAS systems no presents the dump.

Appreciated the help for this case.

Regards.

Desirée

[cherry_tian]

Hi, Disiree

The 601 error usually indicates physical corruptions or data movement.

You firstly need to take a DBCC CHECKDB to rule out the possiblity of physical corruption (detailed steps are described in note 142731)

If the results of DBCC CHECKDB shows there is inconsistency, the database should be restored by the latest valid backup (valid backup means a backup is verified by DBCC CHECKDB without corruption).

If the results shows there are no any data inconsistencies, the601 indicates a data movement. Then please update the SQL Server service pack to the newest one and see if this change could eliminate 601 errors.  If 601 error still persists after that, please create an incident to BC-DB-MSS component with DBCC CHECKDB results, short dump files, and SQl Server ERRORLOG.

Best regards.

Cherry.