SAP Knowledge Base Article - Preview

2906305 - HANA Query fails in Join engine results (JERequestedAttributes) with Memory allocation failed;exception 1000002

Symptom

  • Query fails in Join engine results (JERequestedAttributes) with Memory allocation failed;exception 1000002. You can confirm this from the PlanViz trace

memory.PNG

  • There is no filter/WHERE Clause in the SQL statement to reduce the data volume but the memory consumption for query seems high based on data volume from source tables + Memory required for dynamic query processing


Read more...

Environment

SAP HANA Database

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

no_cs_join , KBA , 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.