Skip to Content
0
Mar 29, 2018 at 11:05 AM

hot folder interrupting in the middle of a line

481 Views

Hello everyone, When I import csv files on hotfolder sometimes it can be interrupted in the middle of a line. I could not find the cause.

This row on 2770 line in my csv:

ccompany_national_store, ccompany_store;4530;Milka Beyaz Dikdörtgen Çikolata 80 gr;BRN-1223,4.3.2.3;"7622200009794";tr-vat-half;"120201.056699083";;;;;;;;;;;;true;;;;;check;;pieces;1;20;OPENED;;

But it throwing following error:

Error summary:

Caused by: org.springframework.messaging.MessageHandlingException: nested exception is de.hybris.platform.acceleratorservices.dataimport.batch.BatchException: reached EOF and got odd number of '"'! File is corrupt. Error starts in line: "ccompany_national_store, ccompany_store;4530;Milka Beyaz Dikdörtgen Çikolata 80 gr;BRN-1223,4.3.2.3;"7622" and occurs somewhere in the following lines.

Full error:

INFO | jvm 1 | main | 2018/03/29 00:46:01.743 |  org.springframework.integration.dispatcher.AggregateMessageDeliveryException: All attempts to deliver Message to MessageHandlers failed.; nested exception is org.springframework.messaging.MessageHandlingException: nested exception is de.hybris.platform.acceleratorservices.dataimport.batch.BatchException: reached EOF and got odd number of '"'! File is corrupt. Error starts in line: "ccompany_national_store, ccompany_store;4530;Milka Beyaz Dikdörtgen Çikolata 80 gr;BRN-1223,4.3.2.3;"7622" and occurs somewhere in the following lines., failedMessage=GenericMessage [payload=de.hybris.platform.acceleratorservices.dataimport.batch.BatchHeader@1152bc8c[file=/hybris/hybris.ccompany.com/hybris/bin/../../hotfolder/master/ccompany/processing/base_product-20180329054911.csv,catalog=ccompanyProductCatalog,language=en,net=false], headers={file_originalFile=/hybris/hybris.ccompany.com/hybris/bin/../../hotfolder/master/ccompany/base_product-20180329054911.csv, id=25357dce-bafa-a844-dc0d-e03761f8706c, timestamp=1522273561541}].

How can I solve it? Have you any idea? Thanks so much.