2288751 - SQL error 21 and Fatal error 824 | SAP Knowledge Base Article

Symptom

The ST22 transaction shows the following error in the dump:

...
SQL error 21 when accessing table "[TABLE_NAME]".
What happened?
Error Text of the Database: "Warning: Fatal error 824 occurred at Mar 1 2015"
...

Workprocess trace shows the following or similar error:

...
C (21) [HY000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Warning: Fatal error 824 occurred at Mar 1 2015 12:16AM. Note
...

Additionally the SQL Error Log shows the following or similar consistency issue:

...
Error: 824, Severity: 24, State: 2.
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:147232; actual 339:525). It occurred
during a read of page (1:145546) in database ID 5 at offset 0x00000048334000 in file ...
...

Environment

SAP NetWeaver 7.0 Application Server for ABAP or Higher
SQL Server 2000 or Higher

Product

SAP Solution Manager 7.1

Keywords

KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.