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

You may encounter table inconsistency errors when you check table.

    => CALL CHECK_TABLE_CONSISTENCY ('CHECK', '<SCHEMA_NAME>', '<TABLE_NAME>');

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.cc(02178) : 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

ColumnStoreConsistencyChecker, duplicate, udiv , KBA , HAN-DB , SAP HANA Database , Problem