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.
SAP Knowledge Base Article - Preview