SAP Knowledge Base Article - Public

2637873 - Unable to retrieve data from datasource. Error: [Error [Server]: (#42014) Caught exception: exception 1000002: Allocation failed in SAP Analytics Cloud (SAC)

Symptom

The following error occurs when adding a variance to a chart in SAP Analytics Cloud (SAC):

  • Chart with Variance fails with "Unable to retrieve data from datasource. Error: [Error [Server]: (#42014) Caught exception: exception 1000002: Allocation failed ; \$size\$=71052634265088;\$name\$=CubeInserts; \$type\$=TempAllocator]

Environment

  • SAP Analytics Cloud 2018.6.2

Reproducing the Issue

  1. Create a Connection, Model and Story with SAP Analytics Cloud.
  2. Add a variance to one of the Charts in the Story.
  3. Notice the error.

Cause

This code issue has been identified by SAP HANA Development.

Resolution

  • This issue has been addressed in SAP HANA 2.0 SPS 03 per SAP Note 2578795 - SAP HANA 2.0 SPS 03 Database Revision 030.
  • This issue has been addressed in SAP HANA 1.00.122.18 per SAP Note 2648119 - SAP HANA 1.0 SPS 12 Database Maintenance Revision 122.18

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

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, 42014, 1000002, TempAllocator , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0