SAP Knowledge Base Article - Public

2263687 - Ad Hoc Report Error with Export to Excel or Run Offline option

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

  1. Login to the instance
  2. Select Reporting > Analytics > Ad Hoc Reports
  3. Select any Ad Hoc report
  4. Choose Export to excel or Run Offline with excel format
  5. 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
  1. 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