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

SAP Knowledge Base Article - Preview

2288751 - SQL error 21 and Fatal error 824

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 ...
...


Read more...

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 ONE Support launchpad (Login required).

Search for additional results

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