SAP Knowledge Base Article - Public

2671463 - [Error [Server]: (#42014) Caught exception : exception 71000002 in SAP Analytics Cloud (SAC)

Symptom

Below error is displayed when trying to connect to HCP and retrieve data

[Error [Server]: (#42014) Caught exception : exception 71000002: message not found \$message\$=exception 1000002:ltt/impl/memory.cpp:86 Allocation failed ; \$size\$=42625964960; \$name\$=libhdbcs.so; \$type\$=pool; \$inuse_count\$=17851; \$allocated_size\$=24996300

49Allocation.jpg

Environment

  • SAP Analytics Cloud 2018.11.3

Reproducing the Issue

  1. Login to SAC
  2. Create a Model connecting to HCP with lot of data (hundreds of thousands or millions of rows)
  3. Create a story off that Model
  4. Insert Table or chart to display data
  5. Error is dispalyed

Cause

This error can occur if the amount of data being retrieved from HANA Cloud Platform is exceptionally large.

There are limitations to the amount of data that can be retrieved in a single query

Resolution

Reduce your query to a smaller dataset (for instance aggregate the data in your HANA view if you do not need details below the aggregation)

Or split your query into multiple smaller queries

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

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 , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0