[SOURCE_UNLOAD ]E: Data error found: No delimiter found after a valid value on quotes mode

[KellyHobson]

I encountered this error when testing a csv file source endpoint.

When I setting up the task, I used the defaults in the Source File endpoint.

From logs I saw:

00041100: 2022-03-25T10:26:45 [SOURCE_UNLOAD ]E: Data error found: No delimiter found after a valid value on quotes mode - file: C:\tmp\datatest.csv, Record number: 2, Offset: 10 [1020417] (csv_util.c:545)
00041100: 2022-03-25T10:26:45 [SOURCE_UNLOAD ]E: CSV Util failed to write value to buffer [1020417] (csv_util.c:1003)
00041100: 2022-03-25T10:26:45 [SOURCE_UNLOAD ]E: Failed to read record number: 2. [1020417] (file_unload.c:259)
00041100: 2022-03-25T10:26:45 [SOURCE_UNLOAD ]E: Failed to init unloading table. [1020417] (file_unload.c:395)

When I opened in Notepad, I saw my csv file had CRFL carriage return and not FL.

I updated the source endpoint settings to resolve the 'Record delimiter field'.

Table was then able to load in the task. 

Environment

• Qlik Replicate 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.