SAP Knowledge Base Article - Public

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

Symptom

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

Environment

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

Reproducing the Issue

  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.

Cause

HANA memory error.

Resolution

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

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, , 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 , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0