Solution : https://service.sap.com/sap/support/notes/1977584 (SAP Service marketplace login required)
Summary :
This SAP Note details proactive methods to check for SAP HANNA inconsistencies, identifying options to perform technical consistency checks specifically on meta data and data structures within the database. For meta data, the CHECK_CATALOG procedure is recommended, encompassing various checks such as object referential integrity and value domain consistency. For structural and data aspects, CHECK_TABLE_CONSISTENCY provides a broader inspection, capable of executing and repairing data anomalies across row and column stores. Key SAP HANA tables and admin tools provide further insights into these checks, ensuring comprehensive data integrity and system consistency.
Key words :
customer component han-db sap hana database priority recommendations / additional info category consulting validity, memory 10 row invalid lob owner id lob owner id, folder /usr/sap/<sid>/hdb<inst>/exe/python_support, terms corruption wrong result set duplicate keys reason, busy table lock acquisition failed 8 row cid mismatch, py --sqluser=system --sqlpassword=<password> --execrepair starting, partitioning related meta data column check_partitioning_data check assignment, impact row store reorganization row check_not_null_constraint check, py --sqluser=system --sqlpassword=<password> --testrepair, memory 8 row page consistency check failed mismatched data
Related Notes :
| 2116157 | |
| 2125399 | SAP HANA: table consistency check returns error "Maximum rowid in table is larger than max rowid in runtime data" |
| 2052419 | SAP HANA: CHECK_TABLE_CONSISTENCY on Extended Storage tables may lead to crash |
| 1666976 | uniqueChecker usage description |
| 1963791 | Avoid rowstore data loss or recover to consistent state |
| 2127458 | |
| 1869119 | |
| 1873247 | |
| 1977242 | |
| 1813245 | SAP HANA DB: Row store reorganization |
| 2105767 |