SAP Knowledge Base Article - Public

2748608 - Unable to retrieve data from the datasource error appears in SAP Analytics Cloud

Symptom

  • When using Exception Aggregations created in the modeler, the chart in the Story shows the following error message in SAP Analytics Cloud (SAC):
    Unable to retrieve data from the datasource Caught exception : exception 70002048: cannot add a language to the physical part of a logical index; \\$message\\$=column store error: search table error:  [9] Memory allocation failed

  • The error appears when a filter is applied, otherwise the Story retrieves data correctly.

Environment

  • SAP Analytics Cloud
  • Live Data Connection to SAP HANA SCP

Reproducing the Issue

  1. Create Exception Aggregations in a model which is based on HANA Live Connection.
  2. Create a Story based on the model.
  3. Notice that the data is being displayed.
  4. Apply filter on the Story. 
  5. Notice that the error message appears. 

Cause

High memory in the HANA calculation engine.

Resolution

Simplify the HANA query to avoid high memory usage.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , HAN-AS-INA-SVC , deprecated - please use HAN-DB-ENG-MDS instead , Problem

Product

SAP Analytics Cloud 1.0