Symptom
Consistency check CHECK_TABLE_CONSISTENCY runs for so long and does not finish.
With the debug enabled trace logs by Setting the following parameter value to 'debug' :
indexserver.ini -> [trace] -> table_consistency_check = debug
The below messages appear in the trace logs :
[76277]\{321582\}[135/-1] 2023-10-23 16:16:43.288345 d table_consistenc ForeignKeyChecker.cc(00177) : query with chunks: SELECT xxxxxx FROM "yyyyy"."zzzzz" ....
Read more...
Environment
- SAP Hana 2.0
Product
Keywords
Hana , Consistency , CHECK_TABLE_CONSISTENCY, chunksize_in_foreignkeycheck , table_consistency_check , KBA , HAN-DB , SAP HANA Database , 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.