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

KellyHobson — Fri, 25 Mar 2022 17:55:27 GMT

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

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.

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

FCMA_Steve — Thu, 18 Sep 2025 22:26:01 GMT

We received the same error for a different reason. Already specified \r\n as the record delimiter. Clearing the value from Escape character resolved the issue. Specifically, the input file consisted all but one field wrapped in double-quotes. The 1st field contains integer values like this:

88921,"Lisa","L"

Qlik Replicate threw this error: Data error found: No delimiter found after a valid value on quotes mode

We initially resolved by wrapping the integer field with double-quotes via pre-cleansing Python script. After locating this post we tested the original file with empty values for Null character & Escape character.

I would love to know if Qlik has documentation about the management of "quotes mode" behavior. Thanks for your post.

article [SOURCE_UNLOAD ]E: Data error found: No delimiter found after a valid value on quotes mode in Official Support Articles

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

Environment

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