Symptom
You get the below error when you try to Export to Excel or Run Offline, with excel format, an Ad Hoc report.
- + org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
- AxisFault
- faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
- faultSubcode:
- faultString: org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
- faultActor:
- faultNode:
- faultDetail:
- {http://xml.apache.org/axis/}stackTrace:org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
Environment
- SuccessFactors HCM Core
- Ad Hoc report
Reproducing the Issue
- Login to the instance
- Select Reporting > Analytics > Ad Hoc Reports
- Select any Ad Hoc report
- Choose Export to excel or Run Offline with excel format
- Although the job is scheduled and the export to excel is successful (completed) the file contains the below error (attached full details)
- + org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
- AxisFault
- faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
- faultSubcode:
- faultString: org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
- faultActor:
- faultNode:
- faultDetail:
- {http://xml.apache.org/axis/}stackTrace:org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
- The report works fine as csv format, preview or when run online
Cause
Such behaviour may be caused by the Excel version used and the Excel Output configuration for Ad Hoc Reports.
Resolution
In this case, the issue was solved by ticking the below instance option via provisioning.
Generate Excel 2010 Output for Ad Hoc Reports from the Analytics and Dashboard Tabs & Misc...... Reporting section.
Keywords
Ad Hoc Report Error, Export to Excel error, Run Offline error , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem
Product
SAP SuccessFactors HCM Core all versions