2219570 - Table Reports Error when Running the report Online or Exporting to Excel - Table Reporting

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.

SAP SuccessFactors HXM Suite

1. Login to the instance
2. Go to report center
3. Run any table 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)

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.

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

If you face similar error with multiple Table report which were working before you may report an case 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 Table report as csv download or Run Offline as below:

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 Table 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.

2349962 - Online Table Reports Result in Blank Screen/Org Exception BIRT Error - Table Reports

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