SAP Knowledge Base Article - Public

3478227 - Message 'Result set too large. Data procurement restricted by configuration.' in SAC add-in for Microsoft Excel

Symptom

In SAC add-in for Microsoft Excel, table datasource is live BW or S/4HANA or S/4HANA query. Following error message is displayed when refreshing the table:
---
Result set too large. Data procurement restricted by configuration.
---

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental". 

Environment

SAP Analytics Cloud, add-in for Microsoft Excel

Cause

In SAC add-in for Microsoft Excel, for live BW or S/4HANA or S/4HANA cloud datasources, BW INA service is used for data getresponse request, and the value of RSADMIN parameter BICS_ABAP_RESULT_SET_LIMIT_MAX controls the maximum number of data cells that can be loaded, this parameter helps to avoid returning result sets that are too large which can have a negative impact on the performance and quality of frontend tools.

If the parameter is set to a value that is less than number of cells that requested result set consists, the 'Result set too large. Data procurement restricted by configuration.' message is displayed.

Resolution

  • Please first reduce the amount of requested data cells by adding filters, adding mandatory variables, reducing rows and columns etc. until the requested data amount is smaller than the parameter value.
  • If it is necessary to display big data report, in BW or S/4HANA system, please use the program "SAP_RSADMIN_MAINTAIN" (transaction SE38) to change RSADMIN parameter BICS_ABAP_RESULT_SET_LIMIT_MAX to a higher value. 
    With BW/4HANA system, the safety belt parameters are part of the SPRO customizing (-> SPRO -> SAP BW/4HANA -> Analysis -> Settings for BICS interface and clients) and should be maintained using the customizing. If case of RSADMIN set in parallel the RSADMIN parameter value has higher priority.

See Also

SAP Note 2948174 - BICS : Safety belt for large resultsets for BICS InA and oData based clients

Keywords

SAC addin for Excel, SAC addin for Microsoft Office, result set limit, maximum size, limitation, resultset, safetybelt, safety belt, warning, performance , KBA , LOD-ANA-OF , SAP Analytics Cloud, add-in for Microsoft Office , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud, add-in for Microsoft Office all versions