SAP Knowledge Base Article - Preview

2631131 - Employee Central: Ad Hoc Reports take a long time to execute or are timing out

Symptom

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)


Read more...

Environment

  • Employee Central
  • Ad Hoc Reports

Keywords

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 , KBA , LOD-SF-EC-REP , Reporting Data , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.