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
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.