Symptom
You Run an Ad Hoc report offline with Excel, PDF or PPT format.
The job is scheduled and completes successfully however when you open the excel file following error is thrown instead of the expected data:
Environment
- SAP SuccessFactors HCM Core
- Ad Hoc Reports
- Job Schedule
Reproducing the Issue
-
Select any Ad Hoc Report then Run Offline
-
Chose any Format, from the list, but CSV
-
The report schedule completes successfully
-
When you open the file the below error are thrown:
-
Status report
-
Error encountered in writing the birt report definition.
-
The request sent by the client was syntactically incorrect (Error encountered in writing the birt report definition.)
- If you chose the CSV format the file output shows the correct data
Cause
In this case the issue was caused by a permission denied issue on the server directory.
Resolution
If you face similar error with multiple Ad Hoc reports while running them offline with specific output you may report an incident with the error and timestamp details.
As a workaround, you should be able to run the Ad Hoc report offline with the csv format type and get the expected result with the file output.
Keywords
birt report definition, scheduled report, file output , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem