2631131 - Employee Central: Ad Hoc Reports Take a Long Time to Execute or are Timing out

When trying to run any of the following Employee Central Ad Hoc reports, where there are many JOINS and a lot of data, the reports take a very long time to run or the report will time out and fail.

• Person and Employment (As of Date)
• Job Information (Date Range)
• Recurring Compensation Information (Date Range)
• Non-Recurring Compensation (Date Range)

In some cases, a BIRT Error similar to this may appear when running the report Online:

org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report
Caused by: com.successfactors.analytics.queryengine.exceptions.QueryEngineException: Error encountered in executing the query. SAP DBTech JDBC: [260]: invalid column name: GO_JOB_CODE.$rowid$: line 8 col 7724 (at pos 8249)

Running the report Offline may also encounter unexpected results such as blank output files and error messages such as "Excel can't open the file. Report name or extension is invalid."
If you edit the report and click Preview, you will may also get an Application Error with fingerprint=7af84dfabaddd815f78b53e7e708718f2c5d845a:

Error encountered in getting the data.com.successfactors.analytics.queryengine.exceptions.QueryEngineException: Error encountered in executing the query. SAP DBTech JDBC: [260]: invalid column name: GO_JOB_CODE.$rowid$: line 8 col 7724 (at pos 8288)

SAP SuccessFactors Employee Central - Ad Hoc Reports

ad hoc, ec, employee central, person and employment, Person and Employment (As of Date), Job Information (Date Range), Recurring Compensation Information (Date Range), Non-Recurring Compensation (Date Range), Person and Employment Audit, Person and Employment Export, performance issue, slow, long running, BIRT error, org.eclipse.birt.report.service.api.ReportServiceException, Error happened while running the report, Enable adhoc Query Trimming, performance, Adhoc report, Disable EC Ad Hoc Query Trimming, Adhoc Report , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , How To