SAP Knowledge Base Article - Public

3038138 - Error "Memory allocation failed" when doing a live connection to a Hana view in SAP Analytics Cloud (SAC)

Symptom

When trying to run a Hana view through SAC, you get the error:

"[Error] Server: (#42014) Caught exception : exception 70000009: Memory allocation failed;exception 1000002: Allocation failed ; \$size\$=123456789; \$name\$=Results; \$type\$=pool; \$inuse_count\$=17; \$allocated_size\$=9876543210; \$alignment\$=8; \$failure_type\$=PROCESS_ALLOCATION_LIMIT; \$failure_flag\$=
,Exception in executor plan123456@<server name>:<port number> while executing pop 9
app.chunk.7.slice_of_main-chunk.4d81567865f1e765cd80.js:20 2021-01-01 12:01:23.456789 Code: 42014 Text: The query was stopped before it finished because the server was unable to complete the request. Please try filtering your data, or contacting your administrator."

If you extract the MDS query from the HAR file (kbase 2691501 and kbase 2550833 ) and run the MDS query directly on the Hana server you will get the same error.

Environment

  • SAP Analytics Cloud (Enterprise) 2021.2.8

Reproducing the Issue

  1. Create Hana calculation view
  2. Create live model based on the view in SAC
  3. Create a story based on the model and attempt to get data. 

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , LOD-ANA-MDS , Message Delivery Service , Problem

Product

SAP Analytics Cloud 1.0