Symptom
When a report is executed you get the error message, "Unexpected error occurred. Overflow in the operation COLLECT".
Environment
SAP Cloud for Customer
Reproducing the Issue
- Login to the system.
- Navigate to Business Analytics and choose Design Reports.
- Open the affected report.
- Execute the report.
- You will get the error message.
Cause
Aggregation type is chosen as Summation for a key figure that is added to the report view.
When the data volume is more, the summation total also is more. When this total exceeds the allowed limit, the report hits a dump.
Resolution
Check if the aggregation type is Summation for any key figure that is added to the report view.
If it is a custom key figure, under Business Analytics work center and Design Key figure, edit the key figure and change the aggregation type to maximum or first etc. as per your requirement.
If it is a standard key figure, you cannot edit or change the key figure design. You can check the documentation of the key figure to know the details.
The alternate solution would be to narrow down the data volume by passing appropriate filters in the selection before executing the report.
Keywords
Summation, Aggregation, Key Figure, Report, OVERFLOW, Error, COLLECT, Limit, Unexpected Error. , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem