3038138 - Error "Memory allocation failed" when viewing a Story based on a Live Connection to HANA View in SAP Analytics Cloud (SAC)

• When viewing a Story based on a HANA View in SAP Analytics Cloud, it fails with 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 (KBA 2691501 and KBA 2550833 ) and run the MDS query directly on the HANA server, it generates the same error.

SAP Analytics Cloud 2021.2.8

1. Create HANA Calculation View.
2. Create a Live Model based on the HANA View in SAP Analytics Cloud.
3. Create a Story based on the Model.
4. When viewing the Story, it fails with the error: "Memory allocation failed..."

This issue occurs if the statement_memory_limit property on the Hana Server is set too low for the query to successfully execute.

Increase the "statement_memory_limit" property on the Hana server to a larger value so the query can successfully execute.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud > Learning > Data Connections
• SAP Analytics Cloud > Learning > Guided Playlists
• SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
• Need More Help? Contact Support or visit the solution finder today!

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

SAC, hanaview, memory error , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-MDS , Message Delivery Service , Problem