SAP Knowledge Base Article - Public

2219570 - Ad Hoc Reports Error when Running the report Online or Exporting to Excel - Adhoc Reporting

Symptom

You try to Run any report Online or Export to Excel and get an error like the one below:

org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report

Note:

  • In this case you are sure the report was working before.
  • You face the same issue with any report with different domains

There are two possible workaround which you might test, please see the Resolution section for details.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Login to the instance
  2. Analytics - Reporting - Ad Hoc Reports
  3. Run any report (online or export to Excel) with any users and the error below occurs:

org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
Hide Exception Stack Trace

Stack Trace:
org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1096)
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1316)
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)

more.........

Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report
   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:261)
   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85)
   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1307)
... 68 more
Caused by: org.eclipse.birt.report.engine.api.EngineException: Failed to save design!
   at org.eclipse.birt.report.engine.api.impl.ReportDocumentWriter.saveDesign(ReportDocumentWriter.java:195)
   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:214)
... 70 more
Caused by: java.lang.NullPointerException: while trying to invoke the method org.eclipse.birt.core.archive.cache.Cacheable.getPrev() of a null object loaded from local variable 'entry'
   at org.eclipse.birt.core.archive.cache.CacheList.remove(CacheList.java:58)
   at org.eclipse.birt.core.archive.cache.CacheList.remove(CacheList.java:86)

Cause

Such errors may be caused by a temporary inconsistency with the Report Server communication.

For example, the report may fail with the mentioned exception if the servers are overloaded, face some permissions issues or the BIRT app servers is down with heap issues.

If the behavior is happening to single reports and not all the reports and domains, the behavior is probably a timeout explained on the KBA 2349962.

Resolution

Some measures are in place and more planned to identify and avoid such issues.

If you face similar error with multiple Ad Hoc report which were working before you may report an incident with the error and timestamp details. Please keep in mind that the operations team is restarting the BIRT servers every evening to correct the behavior.

There are two possible workarounds you might test during the day to be able to run the necessary report:

Workaround 1

As a temporary workaround you can run the Ad Hoc report as csv download or Run Offline as below:

csv.jpg

2016-02-16_11-54-39.jpg

Workaround 2

Sometimes the issue is limited to specific servers in the backend.

What you can try then is:

  1. Open a private browsing window (E.g. Chrome CRTL+Shift+N)
  2. Reconnect in the new window to the instance.
    In most cases the load balancing system will move this new connection onto a new application server.
    (You can verify the server ID by clicking on "Show version information" at the bottom of the screen).
  3. Once you are connected to the new server retry to run the Ad Hoc reports.
  4. Should it work please include the new server details in your ticket with customer support as well as it will help to narrow down the issue for the involved teams.

See Also

2349962 - Running Ad Hoc reports online results in a blank screen or Org exception - Adhoc Reporting

Keywords

BIRT, Ad,Hoc report, Eclipse, Online, export to excel,Report, Bad Gateway, error, not working, org.eclipse.birt.report.service.api.ReportServiceException , KBA , error 404 , error message , birt_errorpage , http status 400 , error encountered , ad hoc report error , birt error , ad hoc error , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Suite all versions