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

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

Symptom

  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.

Read more...

Environment

SAP ASE for Business Suite - v15.7 and later

Product

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

Keywords

KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.