SAP Knowledge Base Article - Public

3535194 - Error in Report "Unexpected Error Occurred. Overflow In The Operation COLLECT"

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

  1. Login to the system.
  2. Navigate to Business Analytics and choose Design Reports.
  3. Open the affected report.
  4. Execute the report.
  5. 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

Product

SAP Cloud for Customer core applications 2408