SAP Knowledge Base Article - Preview

2192624 - DBCC CHECKSTORAGE reports Error 100023 or 100024 - SAP ASE

Symptom

DBCC CHECKSTORAGE reports the following error:

<database>.<table>:
===============
 Type Code: 100023; Soft fault that has been upgraded to a hard fault
 OAM used pages count discrepancy exceeds threshold.
 page id: 43774464
 page id actual: 35848432
 object id: 0x2DC6D687

Or similarly:

Table Name                  Index      PartitionId          Fault Type                           Page Number      
------------------------    -------    -----------------    ---------------------------------    -----------------
<table name>                 255           1684198029    100023 (used count error)          36745738
<table name>                 255           1684198029    100024 (unused count error)      36745738


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

tablealloc, full, optimized, allocation   , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.