2459623 - "An error occurred in the BW service: Result set is too large; data retrieval restricted by configuration" error in SAP Analytics Cloud

SAP Knowledge Base Article - Public

2459623 - "An error occurred in the BW service: Result set is too large; data retrieval restricted by configuration" error in SAP Analytics Cloud

Symptom

  • When trying to create a model from BW Import Data connection in SAP Analytics Cloud, the following error is shown: "An error occurred in the BW service: Result set is too large; data retrieval restricted by configuration".
  • Model on same query can be created successfully by using the live connection
  • Tomcat Catalina.log contains the following error:
    - SEVERE [pool-144-thread-1] com.sap.fpa.cloud.rest.bw.BWTaskRunner.readQueryData Error in BW ResultSet: SIZE_LIMIT_EXCEEDED - Result set is too large; data retrieval restricted by configuration
    - SEVERE [189] com.sap.fpa.cloud.internal.DAException.logException Result set is too large; data retrieval restricted by configuration

Environment

  • SAP Analytics Cloud (SAC) 2017.23.1
  • SAP BW

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a model using BW Import Data Connection.
  3. Select one BEx query having data more than 100,000 rows to build query.
  4. Click Create button in Build SAP BW Query dialog.
    => Note the error: "An error occurred in the BW service: Result set is too large; data retrieval restricted by configuration"

Cause

Resolution

  • Increase BW safety belt on your BW system by modifying BICS_DA_RESULT_SET_LIMIT_MAX.
    => Note: Safety belt value Increasing might have negative impact on the BW system performance and, if too high, cause out-of-memory dumps.
  • After that, if getting another error "An internal server error occurred in the Data Acquisition Service", it may also requires to increase the JVM memory of your Tomcat server where SAP Analytics Cloud Agent is deployed.

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

      EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, BW, size, rows, large, result set, limitation, limit, safety belt, bics, BICS_DA_RESULT_SET_LIMIT_MAX, refresh failed   , KBA , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Problem

      Product

      SAP Analytics Cloud 1.0