Symptom
When trying to upload a file to import complete business objects in Data Workbench, the following error message appears:
"Error occurred processing the CSV file(startline 1) EOF reached before encapsulated token finished."
Environment
SAP Hybris Cloud for Customer 1802 and above.
Reproducing the Issue
-
Enter the Data Workbench work center.
- Navigate to the Import view.
- Select the radio button for Complete Business Objects.
- Select the object which will be imported, and click on Next.
- In the next screen, upload the zip file with the object data.
- When trying to upload the file, the error message appears.
Cause
This error message appears because there are spare commas in the file data. This causes the system to expect a new data that needs to be addressed, however the system does not find enough headers to map this data.
For example:
Field A, Field B, Field C <- the headers of the CSV file
12345, ABCD, WXYZ, <- the data to be imported
In this case, the system will map "12345" to the Field A, "ABCD" to the field B and "WXYZ" to the field C. However the system assumes that there is another field which needs to be populated with a blank value (because of the comma in the end of the row). In this case, the system will raise the error "Error occurred processing the CSV file(startline 1) EOF reached before encapsulated token finished".
Resolution
To solve this issue make sure that all the data in the CSV is being mapped to the correct field from the header, and that there are no spare commas neither in the headers or the data rows.
Keywords
data workbench, upload file, complete business objects, simulation , KBA , LOD-CRM-INT-DWB , Data Workbench , How To