topic Re: Unable to load data from file as source : Location C:\Full_Load_test.csv is not a valid location. Data file(s) location does not exist. in Qlik Replicate

Unable to load data from file as source : Location C:\Full_Load_test.csv is not a valid location. Data file(s) location does not exist.

AKJ — Tue, 30 May 2023 11:47:35 GMT

Hi,

I'm not able to use my CSV file as a source to my Full Load replicate task.

I'm trying to load data from a CSV file to Snowflake hosted on AWS. I can see the target connection working fine with the table getting created, but then the task fails with this error. Please help me to fix this. Am I missing something? I tried to load a .txt file even, still no luck. Basically I'm not able to use any file as source.

Note: Followed this particular link to create my source
https://help.qlik.com/en-US/replicate/May2021/Content/Replicate/Main/File/define_table_and_full_load_data.htm

Re: Unable to load data from file as source : Location C:\Full_Load_test.csv is not a valid location. Data file(s) location does not exist.

SachinB — Tue, 30 May 2023 13:25:51 GMT

Hello @AKJ ,

Could you please cross verify, Whether the above file is existed in above C drive or not? Basically this returns error when file is not existed.

Regards,
Sachin B

Re: Unable to load data from file as source : Location C:\Full_Load_test.csv is not a valid location. Data file(s) location does not exist.

AKJ — Tue, 30 May 2023 14:28:48 GMT

Hi @SachinB ,

The file exists in the mentioned path.

Re: Unable to load data from file as source : Location C:\Full_Load_test.csv is not a valid location. Data file(s) location does not exist.

john_wang — Tue, 30 May 2023 15:17:43 GMT

Hello @AKJ ,

Looks like a privilege issue. Would you please set SOURCE_UNLOAD to Verbose and recreate the error, then check the task log file to understand the root cause further. Or put the .csv file to other drive, eg D:\temp for comparison.

Regards,

John.