Symptom
- Spreadsheet report file sent to SFTP via Provisioning Scheduled Job cannot be opened (problem with content or corrupt), but the same export generated from within BizX Scheduled Reports opens successfully
- When you try downloading the file from SFTP and renaming it from .xls to .zip, you are able to open the file and extract the xls file inside the zip file.
Environment
SAP SuccessFactors Reporting and Analytics
Cause
The option ''Unzip export file if it is zipped'' is switched off in the scheduled job configuration.
In this case, the output file is a zip file, but the SFTP will honor the file name with the extension provided in the job configuration, which is .xls.
Resolution
You can either do the following:
- Rename the files to .zip in the scheduled job configuration in Provisioning > Manage Scheduled Jobs so that you get a .zip file in FTP
- Or check/enable the "Unzip export file if it is zipped" in the job configuration, which appears below the Report Name field.
Keywords
SFTP zip, SFTP file corrupted, SFTP Excel, SFTP report .xls , KBA , LOD-SF-ANA-VIE , List View, Spreadsheet & Classic reports , Problem
Product
SAP SuccessFactors HCM Core 1708