SAP Knowledge Base Article - Preview

2410979 - SAP Adaptive Server Entreprise (ASE): Msg 2510 and 7928 - key mismatch / Index is not consistent error on saptools table


  DBACockpit transaction generates the following error :


  • Msg 2510, Level 16, State 2:
Key mismatch between index page %d, partition ID %d; at offset %d; and data page %d (row ID %d), partition ID %d. Drop and re-create index ID %d of table '%.*s' in database '%.*s'.

  • Msg 7928, Level 18, State 1:
Index %.*s is not consistent; found %ld leaf rows but %ld data rows.  Drop and recreate the index.



SAP ASE for Business Suite - v15.7 and later


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0


KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.