SAP Knowledge Base Article - Preview

3756941 - Plan_ID Entry Missing in SQL Statement Cache on Other SAP HANA Worker Nodes

Symptom

In a SAP HANA 2.0 Scale-Out setup a SQL statement is executed and after the execution you observe that a Plan_ID in the M_SQL_PLAN_CACHE view does only exist on Scale-out node host A, but not on host node B.

In the work process trace files of the involved ABAP servers you find this SQLCODE : -11001 "Routing to node with Site Type 'PRIMARY', Volume ID '2'.... failed message:

WP Trace Error Message


Read more...

Environment

  • SAP HANA 2.0
  • SAP HANA Scale-Out

Product

SAP HANA, enterprise edition all versions ; SAP HANA, platform edition 2.0

Keywords

scale, out, plan, id, worker, node, plan, cache, entry, error, fails, not, existing, sql plan cache, , KBA , HAN-DB-ENG , SAP HANA DB Engines , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , 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.