2217576 - Attachment Uploads: Set system property 'com.sap.jvm.ZipEntry.encoding' to 'CP437'

When trying to upload attachments through Live Profile Import in Provisioning, the scheduled job fails with the following error:

com.successfactors.jobscheduler.ScheduledJobExecutionException: com.successfactors.jobscheduler.ScheduledJobExecutionException: java.lang.IllegalArgumentException: Malformed entry of zip or jar file. Set system property 'com.sap.jvm.ZipEntry.encoding' to 'CP437' (…)

SuccessFactors Employee Profile

This error occurs when there are non-ASCII characters (special characters) included within the .csv or the filenames of the files inside the zipped archive you are using for the import. For correcting this issue, the customer must remove both the non-ASCII characters from .csv and the filenames of the files contained in the zipped archive.

If the customer needs help identifying where the incorrect files are, you can follow the below steps:

1. Get customer’s approval that you can download and analyze the data of their zipped file
2. Once approval is provided, download the zip file from their FTP site and extract it to a folder inside your computer. Remember that this folder must be deleted afterwards for Data Security reasons

Now for the next steps you will need to have Notepad++ installed in your computer. As of the date this KBA was created, Notepad++ is a white listed program in SAP SRI. For more information about where to download or restrictions involved, please consult SAP SRI in SAP portal.

1. Open the .csv file with Notepad++
2. Hit CTRL+F for the search window to appear.
3. On the find window, change the Search Mode to Regular expression and look for the following String: [^\x00-\x7F]+

This will search for any characters contained inside the .csv file that are out of the ASCII table byte range. As an example, if I run this search in a file that contains the character “ã” and click in “Find all in current document”, Notepad++ will indicate what are the rows that contain invalid characters.

 The process above can be used by reviewing the customer’s .csv and afterwards providing them a list with the rows they need to fix and by consequence the filenames being reference in those rows as well.

If you follow the steps above and the import is still not working, it may indicate that they have corrected the .csv but not the names of the files contained on the zipped file. Notepad++ can’t be used to identify non-ASCII characters inside file names, so if this is the case you can follow the below steps.

1. If you do not have it already, extract their zipped file to a folder in your computer. Once again, remember that this folder must be deleted afterwards for Data Security reasons.
2. Copy the directory of the folder where you extracted the data.
3. Use the attached JAVA application “test-non_ASCII.jar”. This application will search the name of every file contained on the directory you provide to it and create a text file containing the ones that have non-ASCII characters

IMPORTANT: This JAVA application is not to be shared with customers. This was developed by support for support, and can only be used by SuccessFactors Support Engineers.

Example

Inside a folder, I have added a few test files with three of them containing non-ASCII characters:

Click twice on the .jar file and an input window will appear for you to add the directory of the folder you want to search:

Add the correct path and hit OK. This will create a file named “nonAsciiResults.txt” next to the “test-non_ASCII.jar” file. If you open the text file it will show you what are the file names that contain non-ASCII characters:

com.successfactors.jobscheduler.ScheduledJobExecutionException: com.successfactors.jobscheduler.ScheduledJobExecutionException: java.lang.IllegalArgumentException: Malformed entry of zip or jar file. Set system property 'com.sap.jvm.ZipEntry.encoding' to 'CP437', Error, non-ASCII characters, background, employee profile, Notepad++,  com.sap.jvm.ZipEntry.encoding, attachements , KBA , LOD-SF-EP-BGD , Background Elements , LOD-SF-EP-JOB , Scheduled jobs , Problem