SAP Knowledge Base Article - Preview

2593675 - Persistent index corruption errors 2510 / 7928 even after recreate - SAP ASE

Symptom

  • dbcc checktable (or dbcc checkindex) reports error 9996 / 7928 that the index is corrupted.  Suggest dropping/recreating the index.
        
    Msg 9996, Level 16, State 1:
    Server 'XXXX', Line 1:
    Keys of index id 9 for table 'abc_YYYY' in leaf page not in proper order.
    Drop and recreate the index. (index page 265850)
    Msg 7928, Level 18, State 1:
    Server 'XXXX', Line 1:
    Index abc_YYYY_cola_idx is not consistent; found 11253 leaf rows but 82577 data rows. Drop and recreate the index.
                
  • Tried dropping/recreating the index and running "reorg rebuild" on the whole table, dbcc checktable (or dbcc checkindex) still reports error 2510 / 7928 on the same index.
            
    Msg 2510, Level 16, State 2:
    Server 'XXXX', Line 1:
    Key mismatch between index page 16707, partition ID 560054050; at offset 44; and data page 223600 (row ID 0), partition ID 560054050. Drop and re-create index ID 9 of table 'abc_YYYY' in database 'DB1'.
    Msg 7928, Level 18, State 1:
    Server 'XXXX', Line 1:
    Index abc_YYYY_cola_idx is not consistent; found 11334 leaf rows but 82577 data rows. Drop and recreate the index.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Msg 9996, Msg 2510, Msg 7928, dbcc, dbcc checktable, dbcc checkindex, index corruption, Key mismatch between index page, in leaf page not in proper order, Drop and recreate the index, reorg rebuild. , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.