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.
SAP Knowledge Base Article - Preview