Symptom
When exporting a Report Custom (with BIRT template), the resulting Excel file cannot be opened and shows the message "Excel cannot open the file because the file format or file extension is not valid".
Environment
- SAP SuccessFactors HXM Suite
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
- Table Reporting
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Reproducing the Issue
1. Login and go to Reporting
2. Run Custom BIRT report
3. You will get the guardrails message so export it Offline
- Run Offline, choose Excel and download from Scheduled Reports
4. Download the file
5. Open the Excel
Result: Error (Excel cannot open the file because the file format or file extension is not valid)
6. Try exporting it again but this time choose .CSV format
Result: CSV format is OK.
Cause
BIRT 2.6 is not compatible with JDK11 which is a universal upgrade across all of Bizx server types.
Resolution
Customers would need to upgrade to 4.3 if not yet upgraded.
Keywords
AdHoc, Table report, download, export, XLS, XLSX, Microsoft Excel 2007 format, MS Excel, Excel, Error, Custom, BIRT, file extension, not valid, Format , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-BIR , BIRT Reports , Problem