Symptom
When any user tries to preview or generate an ad hoc/ table report in any format or offline, receive an application error:
An application error occurred. Please try again later or notify support (with the error information of errorId=XX, timestamp=XX, and the version information from the current screen) if the issue keeps occurring. Click cancel to continue.
Environment
- SAP SuccessFactors Analytics
- SAP SuccessFactors 360 Multi-Rater
- SAP SuccessFactors Calibration
- SAP SuccessFactors Career Development Planning
- SAP SuccessFactors Compensation
- SAP SuccessFactors Continuous Performance Management
- SAP SuccessFactors Employee Central
- SAP SuccessFactors Goal Management
- SAP SuccessFactors Performance Management
- SAP SuccessFactors Reward and Recognition
- SAP SuccessFactors Succession Management
- SAP SuccessFactors Variable Pay
Reproducing the Issue
- Login into instance
- Home dropdown > Reporting
- Select New
- Select Table > Next
- Select any domain
- Populate report details
- Click on Preview button
- Receive error
OR
- Login into instance
- Home dropdown > Reporting
- Locate report and select actions icon all the way to the right > Run
- Select any format > Generate
- Receive error
Cause
- The report has columns which were removed and no longer exist in data model
- The report has reached the maximum memory allocation and timed out
Resolution
Whenever a report runs on any domain, the query related to the module will be executed, then the filters applied by the reporting framework will be executed. If the module has a huge amount of data, the query takes more time and a timeout exception will occur. More information is in 2418819 - Reports Best Practices & Restrictions for Table and Canvas reports.
Workarounds:
- Create a new report
- Remove some columns from the report
- Add filters to pull in a smaller data set
- Schedule the ad hoc report to run on a schedule
- Utilize an API to pull the data
- Utilize Integration Center to pull the data
If you need any assistance with configuring your report, you can reach out to your certified partner if you have one, or look for one using 2149831 - SAP Professional Services / SAP Certified Partner / SAP Account Management Team [SuccessFactors Cloud].
See Also
Keywords
Time, Out, Huge, Amount, Data, Performance, management, report, module, Filters, query, joins, Table, Adhoc, success factors, CPM, GM, PMGM, CMP, RNR, VRP, SCM, EC, CDP, CAL, SF , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-PM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-CPM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-SCM-REP , Reporting and Data Imports Exports , LOD-SF-GM-REP , Reporting and Data Imports Exports , LOD-SF-CMP-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-VRP-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-RNR-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-CDP-REP , Analytics & Reporting , Problem