SAP Knowledge Base Article - Public

2635413 - Upload Failure in SAP Analytics Cloud (SAC)

Symptom

Upload Failure in SAP Analytics Cloud (SAC)

Importing data from SAP Business Warehouse fails with "(!) Failed Upload - An internal server error occurred in the SAP Analytics Cloud agent: Result set is too large; data retrieval restricted by configuration"

Tomcat logs for Tomcat host SAP Analytics Cloud Agent 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

Environment

  • SAP Analytics Cloud 2018.7.1

Reproducing the Issue

  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

Cause

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.

Resolution

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

Increasing the Safety belt value may:

  • Have a negative impact on the BW system performance and, if too high, cause out-of-memory dumps.
  • Result in another error "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.

Alternative Solutions:

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, SIZE_LIMIT_EXCEEDED, BW, Business Warehouse, ResultSet, Upload, Failed, Safety, Belt , KBA , refresh failed , 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