SAP Knowledge Base Article - Preview

2919102 - Unexpected distributed executions due to client-server connectivity problems

Symptom

  • You observe unexpected statement distributions in SAP HANA;
  • SAP HANA is configured as multi-host system (distributed environment);
  • Client distribution mode is set to default (statement);
  • Execution plans exists on different hosts' SQL Plan Cache where tables are not located;
  • SAP HANA Mini Check result shows a potential critical check for checkID M1164 - Unexpected distributed executions.


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition all versions

Keywords

plan cache, m_sql_plan_cache, execution plan, host, wrong host, incorrect host, memory, distribution, statement, M1164, minichecks, SAP HANA, sap_hana, database, db, platform edition, hana1, hana2, 1.0, 2.0, M1164 , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , 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.