SAP Knowledge Base Article - Preview

3394300 - HANA Consistency check CHECK_TABLE_CONSISTENCY runs for so long and does not finish.

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

SAP HANA, platform edition 2.0

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.