Symptom
- Get alert ID: 146 'alert consistency status'
- The alert reported XX inconsistencies in SAPSCHEMA.TABLE with error code 5114, indicating a mismatch in generated column values.
- Inconsistencies were found in the HANA DB, despite going through SAP notes 2116157 - FAQ: SAP HANA Consistency Checks and Corruptions - SAP for Me and 2881922 - How to Handle HANA Alert 83 : 'Alert Table consistency' - SAP for Me
However, when executing the table consistency check for the involved tables, it does not show any inconsistencies:
CALL CHECK_TABLE_CONSISTENCY ('CHECK', 'SCHEMA', 'TABLE')
Read more...
Environment
SAP HANA DB Engines
Product
SAP HANA, platform edition 2.0
Keywords
Alert 146, SAP HANA DB, Inconsistencies, Error 5114, ALTER SYSTEM CLEAR CONSISTENCY CHECK HISTORY , KBA , 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.