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

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]

• SAP Analytics Cloud 2018.6.2

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.

This code issue has been identified by SAP HANA Development.

• 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

• How to find User Assistance for SAP Analytics Cloud?
• Ask a question on the SAP Community!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)

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.

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