SAP Knowledge Base Article - Public

3545396 - Data Preview takes too long or returns the error: cannot allocate enough memory Reason: configured statement memory limit from workload class

Symptom

  • Data Preview in SAC Story, Data Analyzer or SAC Excel Add-on execution takes too long and it effects to overall system performance or return the below error message
  • Data Preview on Datasphere Analytic Model returns the following message The query executed with errors. Caught exception : exception 70000004: cannot allocate enough memory: Allocation failed; Reason: booked memory limit reached. Reason: configured statement memory limit from workload class
  • SAC Story execution finishes with the following error message:
    Destination host is unreachable

Environment

  • SAP Datasphere
  • SAP Analytics Cloud

Cause

Based on the current model, the available booked capacity of the database is overloaded, especially regarding the number of occupied CPU threads. This leads to slowdowns for all other related activities on the tenant. 

Resolution

In order to analyze and find the root cause of this issue, the following needs to be checked:

  • The overall utilization of the system. See Help Portal documentation for system monitoring. 
  • SAP KBA 3384164 - OOM occurrences in SAP Datasphere
  • Enable on the Expensive Statement Tracing to analyze individual SQL queries whose execution exceeds one or more thresholdsand. Query the model/view by writing such a SQL Statement to find out memory and CPU per seconds used: SELECT COUNT(*) from "Schema"."ModelName or ViewName";
    • Before using the Expensive Statement Tracing it is highly recommended to read the Help Portal. This will give you the understanding how the parameters need to be configured.
  • The CPU utilization of the database goes up significantly, accompanied by an increase in consumed memory; the model needs to be optimized.

 

See Also

See the blog Performance analysis in the SAP Datasphere

Support Content - Analytic Model Performance Analysis

Keywords

story performance, tenant slow, analytic model slow, booked memory limit reached, statement memory limit, memory, cpu, slowness, timeout , KBA , DS-MD-AM , Analytic Model , LOD-ANA-DES , Story Design & Visualizations , DS-MD , Modeling (Data Builder) , DS-MD-VIW , Views , Problem

Product

SAP Analytics Cloud all versions ; SAP Datasphere all versions