Symptom
- Data Preview of an Analytic Model which is based on a shared SQL View, which resides in a different Space from that of the Analytic Model fails with error:
The query executed with errors. Caught exception : exception 70000004: cannot allocate enough memory: search table error: "QM"."<SQV>\$TF": [4] (range 3): cannot allocate enough memory: "QM"."<SQV>\$TF": line 322 col 1 (at pos 15010): Allocation failed \$REASON\$ Caught exception : exception 70000004: cannot allocate enough memory: search table error: "QM"."<SQV>\$TF": [4] (range 3): cannot allocate enough memory: "QM"."<SQV>\$TF": line 322 col 1 (at pos 15010): Allocation failed \$REASON\$ - Data Preview on the view, using the same Input parameter values as those used for the variables in the AM preview, works fine.
- A FACT view created in the same Space as that as the Analytic Model, with similar definition as that of the Analytical Model, works fine.
-
Corresponding error on the HANA Indexserver is:
Memory allocation failed exception 1000002: Allocation failed $failure_type$=TOTAL_STATEMENT_MEMORY_LIMIT_FROM_WORKLOAD_CLASS $failure_flag$= $size$=2105195200 $name$=TranslationTable $type$=pool $inuse_count$=562 $allocated_size$=13726608024 $alignment$=8 ,Exception in executor plan170805@c5b88430-8f36-471c-a153-dcc09a16805c-70673:30040 while executing pop 17
Read more...
Environment
SAP Datasphere
Product
Keywords
"cannot allocate enough memory", "Data Preview", "Analytic Model", TOTAL_STATEMENT_MEMORY_LIMIT_FROM_WORKLOAD_CLASS , KBA , DS-MD-AM , Analytic Model , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.