SAP Knowledge Base Article - Preview

3467379 - Data Preview on an Analytic Model fails: "cannot allocate enough memory"

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

SAP Datasphere all versions

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.