Symptom
- In a SAP Analytics Cloud (SAC) a story with live data connection to Datasphere, a widget takes a long time to load and eventually does not display anything.
- The following error should appear in the HAR file:
- Caught exception : exception 1000002: Allocation failed ; \\$failure_type\\$=STATEMENT_MEMORY_LIMIT_FROM_GLOBAL_CONFIG; \\$failure_flag\\$=; \\$size\\$=128; \\$name\\$=CubeAxis_Temp; \\$type\\$=TempAllocator\n
Environment
SAP Analytics Cloud 2025.14.17
Reproducing the Issue
- Open a SAC story that uses a live data connection to Datasphere.
- Wait until the story finishes loading.
- Observe that the specific widget does not load successfully.
Cause
- A single statement in the query is consuming more than 25% of the allocated memory.
Resolution
- There are two options to resolve this issue:
- Increase Datasphere Resources:
- The 25% memory limit per statement is fixed.
- Consider upgrading to a larger Datasphere tenant. Contact your account manager to explore available options.
- Optimize the SAC Story:
- Reduce the data load requested by the widget.
- Adjust filtering, aggregation, or logging in SAC to limit the amount of data retrieved per query.
- Increase Datasphere Resources:
Keywords
KBA , LOD-ANA-DES-SMQ , SAP Analytics Cloud Story Metadata and Queries , Problem
Product
SAP Analytics Cloud 1.0
SAP Knowledge Base Article - Public