SAP Knowledge Base Article - Preview

2949021 - dbcc checkstorage reports error 100029 (page header error) on system tables - SAP ASE


  • After upgrading to ASE 16.0 release, dbcc checkstorage is reporting fault error 100029 against the first OAM page of tables.
    SAMPLE message from dbcc faultreport:
    Table Name Index PartitionId  Fault            Type          Page Number
    sysindexes     0         2       100029 (page header error)   17
  • dbcc checktable and dbcc tablealloc on the tables come out clean.
  • Tried reorg reclaim_space and dbcc tablealloc with full/fix option on the tables, dbcc checkstorage still reports error 100029 while dbcc checktable/tablealloc is clean.



SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition


dbcc checkstorage, 100029, page header error, dbcc page, CR 822157, CR#822157, CR822157, sp_dbcc_faultreport, dbcc faultreport , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed

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.