SAP Knowledge Base Article - Preview

3450142 - SAP HANA database inconsistency error: $trexexternalkey$,5130,Inconsistency found:

Symptom

Upon running a SAP HANA consistency check like "CALL CHECK_TABLE_CONSISTENCY ('CHECK', 'SAPHANADB', 'CDPOS');" an inconsistency similar to this is detected:

e table_consistenc Result.cc(00038) : ColumnStoreConsistencyChecker found errors for table XXX::SAPHANADB:CDPOS (t 429): SAPHANADB,CDPOS,$trexexternalkey$,5130,Inconsistency found: Found 4864 concats which differ from value computed from key columns,CHECK_PRIMARY_KEY,4864,{"table_part_info":{"creation_time":"2018-01-12 17:17:24.1810000","cs_table_version":429,"field":{"column flags":"COLUMN_FLAG_SINGLE_VALUED | COLUMN_FLAG_INDEX | COLUMN_FLAG_PAGED | COLUMN_FLAG_CONCAT","column id":217,"columnLoadable":"true","delta


Read more...

Environment

SAP HANA 2.0

Product

SAP HANA, platform edition 2.0

Keywords

$trexexternalkey$, 5130, Inconsistency found, consistency, check, ERROR_PRIMARY_KEY_CONCAT_DIFF, externalkey, index, error, drop, alter, table, primary, key, CHECK_TABLE_CONSISTENCY , KBA , HAN-DB , SAP HANA Database , HAN-DB-ENG , SAP HANA DB Engines , 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.