SAP Knowledge Base Article - Preview

3215255 - Error 5101 “Found duplicate primary key <key>” in Table Consistency Check


You may encounter table inconsistency errors when you check table.



5101,Inconsistency found: Found duplicate primary key XX,Column_value;1,A at udiv XXX with rowid XXXX for SCHEMA_NAME:TABLE_NAME which is a duplicate of key at udiv XXX, value ids X, X for SID::TABLE_NAME(t XXXXXX)


In the indexserver trace, you can see error:


table_consistenc : ColumnStoreConsistencyChecker found errors for table SCHEMA_NAME:TABLE_NAME  (t XXXX):

SCHEMA_NAME:<schema_name>|TABLE_NAME:<table_name>|COLUMN_NAME:<column_name>|ERROR_CODE:5101|ERROR_MESSAGE:Found duplicate primary key XXX at udiv X with rowid XXXX for SCHEMA_NAME:TABLE_NAME which is a duplicate of key at udiv X, value ids 0, 0 for SCHEMA_NAME:TABLE_NAME  (t XXXX)



  • SAP HANA, platform edition 1.0
  • SAP HANA, platform edition 2.0


SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0


ColumnStoreConsistencyChecker, duplicate, udiv , KBA , HAN-DB , SAP HANA Database , 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.