Symptom
You are previewing a data source but it runs into the following error:
Result set too large; amount of data limited by configuration
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to the work center Business Analytics.
- Choose the view Design Data Sources.
- Select your data source and click Preview.
- Run the data source.
- Go to the view and add the required fields.
You will see the mentioned error.
Cause
By default, the data in standard data sources is limited to reduce potential issues due to data volume.
It is not recommended to run a data source without any selections, or to add fields to the view which would expand the data to a highly detailed level when large data volumes are involved.
Resolution
To run the data source successfully, please apply selections in the data source preview. The same is valid in a report that is based on this data source.
Keywords
data source, analytics, data limit, volume, too much data, Result set too large, reporting, business analytics , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To