Symptom
A specific user gets the following errors when running a Story report:
- "We found an error while blending the data source"
- "Internal error occurred while processing"
- Chart widgets fails with error "Failed to fetch data" - "Internal error occurred while processing"
Environment
SAP SuccessFactors HCM Suite
Reproducing the Issue
- Login to SuccessFactors system with specific user.
- Go to Report Center.
- Open a Story and run it.
- The following error appears.
"We found an error while blending the data source"
"Internal error occurred while processing"
"Failed to fetch data" - Some other users are able to run this report without any issues.
Cause
This failure occurs with the database error on network logs: “column store error: search table error: [2724] Olap temporary data size exceeded 31/32 bit limit.” This indicates that the number of records returned for the user query is excessively high, causing the system to exceed the temporary data size limit.
Resolution
Please reduce the amount of data processed. Applying more specific filters ensures that only the required data is retrieved and processed.
This will improve the report performance and prevents unnecessary system load.
If you report has a lot of input filters, try to reduce them also. Input filters will increase the system memory usage potentially leading to this issue.
Keywords
OEM, embedded, SF, reporting, story, report, user, access, blending, internal, error, cannot, read, application properties, Olap temporary data, 31/32 limit, exceed,Caught exception : exception 70002048: column store error: search table error: [2724] Olap temporary data size exceeded 31/32 bit limit;7742795115 refs in 29 columns\n , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , Problem
SAP Knowledge Base Article - Public