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