Symptom
Reports with aggregated calculated columns are getting aborted (offline) or not running online.
The same report is working for the same user in another instance.
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Execute the affected advanced report with aggregated calculated columns offline
- The job gets Aborted
OR
- Execute the affected advanced report with aggregated calculated columns online
- The reports takes a long time to be executed and then shows an error: Error rendering List Report component
Cause
System limitation.
Timeouts can happen when the report has aggregated calculated columns since every aggregated column causes a separate database query to be executed.
The execution of the report will depend on the RBP configuration, the data available in the company, company's configuration and the environment (Preview/Production). Because of it, sometimes the same report can work for the same user in one instance and doesn't work in another instance with the similar configuration.
Resolution
Use Pivot queries instead of aggregated calculated columns. As it only requires a single database query to run .
OR
Break the report in multiple parts and apply filter and reduce the volume of data.
Please note that creating reports, pivot queries and breaking the report in multiple parts is out of the support team scope, our work is focused on bugs and malfunctions, so the best option would be contacting your partner or the professional services if you need help to create the report:
Please also note that the issue can persists even after reducing the volume of data. The best option is always using pivot queries instead of aggregated calculated columns.
Keywords
high memory consumption, aggregated calculated column, advanced reporting, report, Error rendering List Report component, , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem