SAP Knowledge Base Article - Preview

3607891 - How to Analyze Alert 146 with Error 5114 When Table Consistency Checks Are Clean

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 KBA 2116157 - FAQ: SAP HANA Consistency Checks and Corruptions and KBA 2881922 - How to Handle HANA Alert 83 : 'Alert Table consistency'

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.