3018117 - Caught exception : exception 70000004: cannot allocate enough memory: search table error appears in story based on HANA live connection in SAP Analytics Cloud

The following error occurs in story in SAP Analytics Cloud (SAC) when opening HANA based story or in HAR file:

• Caught exception: exception 70000004: cannot allocate enough memory: search table error
• No matching data is available to display

• SAP Analytics Cloud (Enterprise) 2020.21
• SAP HANA Live Data Connection

1. Log in to SAP Analytics Cloud.
2. Open a story based on HANA live data connection.
3. Observe an error in the widget.
4. Remove one of the widgets, observe data loading.

HANA memory error.

Change the HANA DB statement_memory_limit and define the maximum permitted memory allocation as per below:

• 2222250 - FAQ: SAP HANA Workload Management
• 1999997 - FAQ: SAP HANA Memory

• 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.

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, , Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data,, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model,, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped,
HANA live, HANA memory, Caught exception,exception 70000004,cannot allocate enough memory,search table error, Memory allocation failed, Caught exception : exception 70000004: cannot allocate enough memory: search table error:  [9] Memory allocation failed , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem