2635413 - Upload Failure when importing from an On-Premise BW Datasource in SAP Analytics Cloud (SAC)

Upload Failure in SAP Analytics Cloud (SAC)

Importing data from SAP Business Warehouse fails with the following error messages;

• "(!) Failed Upload - An internal server error occurred in the SAP Analytics Cloud agent: Result set is too large; data retrieval restricted by configuration"
• “Preparing model creation...”

Tomcat logs for Tomcat host SAP Analytics Cloud Agent may show:

• "BW ResultSet: SIZE_LIMIT_EXCEEDED - Result set is too large; data retrieval restricted by configuration"
• BICS_DA_RESULT_SET_LIMIT_DEF and BICS_DA_RESULT_SET_LIMIT_MAX are not set
• # Unexpected problem during tunnel processing in channel ... connectivitytunnel.hana.ondemand.com ... Reason: An existing connection was forcibly closed by the remote host...
• # Unregistered tunnel channel

• SAP Analytics Cloud 2018.7.1

1. Connect to SAP Analytics Cloud 
2. Create an Import Data Connection to SAP Business Warehouse
3. Initiate the Create > Model workflow
4. Attempt to Create Query from a BW Query
5. Notice the failure during upload
6. Verify that the BW Safety Belt is not configured

When BICS_DA_RESULT_SET_LIMIT_DEF and BICS_DA_RESULT_SET_LIMIT_MAX are not set the system uses the default of 500,000 data cells where the number of data cells is calculated by multiplying the number of rows (distinct combinations of the characteristics members) with the number of key figures/measures.

Recommended Solutions:

• Modify the existing BW query to decrease the returned data cells
• Split the import into multiple queries and use the 'Append' functionality to add it to the same model in SAP Analytics Cloud per https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/6aa6a99d4eb5467896c4fd47bc9c7642.html

Alternative Solution:

• Increasing the BW Safety Belt (Not Recommended)
  Set BICS_DA_RESULT_SET_LIMIT_DEF and BICS_DA_RESULT_SET_LIMIT_MAX to a large enough value to accomodate the data cells returned by your query per SAP Note 1127156 - Safety belt: Result set is too large
• Negative Implications of increasing the BW Safety Belt

• Increasing the BW Safety Belt may result in a negative impact on the BW system performance and, if too high, cause out-of-memory dumps. It will also affect all other front-end applications, like Analysis for Office, SAP BI WebI, etc.
• You may receive errors such as "An internal server error occurred in the Data Acquisition Service" requiring the increase of JVM memory settings for the Tomcat server where SAP Analytics Cloud Agent is deployed.

Increasing Tomcat JVM Memory (Manual Tomcat Installation)

1. Navgiate to your Tomcat directory's "Bin" folder and Run "Tomcat8w.exe" as an Administrator
2. Navigate to the "Java" tab
3. At the bottom increase the values of "Initial Memory Pool" and "Maximum Memory Pool" such as 1024 and 2048 respectively.
   
   Please make sure that the Maximum Memory Pool allocation does not exceed the amount of Physical memory on the machine which hosts your Tomcat and SAP Cloud Agent, as this may result in decreased performance, or crashing.

Increasing Tomcat JVM Memory (Simple Deployment Kit / SACAgentKit Installation)

1. Navgiate to your SACAgentKit directory's "tools" folder and Run "editTomcatServiceConfig" as an Administrator
2. Navigate to the "Java" tab
3. At the bottom increase the values of "Initial Memory Pool" and "Maximum Memory Pool" such as 1024 and 2048 respectively.
   
   Please make sure that the Maximum Memory Pool allocation does not exceed the amount of Physical memory on the machine which hosts your Tomcat and SAP Cloud Agent, as this may result in decreased performance, or crashing.

• 2459623 - "An error occurred in the BW service: Result set is too large; data retrieval restricted by configuration" error in SAP Analytics Cloud
• 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, SIZE_LIMIT_EXCEEDED, BW, Business Warehouse, ResultSet, Upload, Failed, Safety, Belt , KBA , refresh failed , "data import" , import/export job failure , 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