Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Dinesh-Thangarasu
Contributor II
Contributor II

execute statement: PUT [Snowflake]; Failed to put file ; Error encountered when executing file transfer:

Table 'dbo'.'sharp' (subtask 6 thread 1) is suspended. Failed (retcode -1) to execute statement: PUT 'file:///opt/qlik/gateway/movement/data/tasks/TASK_QCh/cloud/6/LOAD00000001.csv' '@"ATTREP_TST_bd12"/6/' AUTO_COMPRESS = TRUE SOURCE_COMPRESSION = NONE OVERWRITE = TRUE;; RetCode: SQL_ERROR SqlState: HY000 NativeError: 40 Message: [Snowflake][Snowflake] (40)
Error encountered when executing file transfer: Failed to upload file /opt/qlik/gateway/movement/data/tasks/TASK_QCh/cloud/6/LOAD00000001.csv.
; Failed to send file /opt/qlik/gateway/movement/data/tasks/TASK_QCh/cloud/6/LOAD00000001.csv to Snowflake stage; Failed to put file '/opt/qlik/gateway/movement/data/tasks/TASK_QCh/cloud/6/LOAD00000001.csv', size 336848; Handling End of table 'DB'.'sharp' loading failed by subtask 6 thread 1k 1 thread 1

Labels (1)
3 Replies
john_wang
Support
Support

Hello @Dinesh-Thangarasu ,

It’s not clear yet whether this is a one-time/random error or if it persists. Since multiple factors can cause the same error, we suggest the following checks:

1. Verify that the staging drive has sufficient free space.

2. If parallel load is enabled, try disabling it.

3. Consult with your IT team to confirm whether any security software or network restrictions could be blocking file transfers.

4. Reduce the “Max file size (MB)” parameter in the endpoint settings.

5. For deeper troubleshooting, set keepCSVfiles = TRUE in target Endpoint, rerun the task,
and retrieve the generated CSV file from the Replicate server. Then, test uploading it manually using the PUT command in SnowSQL.

6. If the issue continues, our support team can assist further. Please set target_load/target_apply to verbose, reproduce the issue, and provide the Task Diagnostic Package along with decrypted verbose task logs.

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Dinesh-Thangarasu
Contributor II
Contributor II
Author

Hello @john_wang - We have a replication task with 10 tables , only 2 tables are getting replicate , rest of the tables are failed with PUT error.

Staging folder have sufficient space in gateway server

Tried by disabling parallel process , but still getting the same error.

Following log captured after enabling the verbose logging

Line 200362: 04078946: 2026-02-22T13:14:01:876306 [TARGET_LOAD     ]I:  Load finished for table 'dbo'.'Test' (Id = 1). 199573 rows received. 0 rows skipped. Volume transferred 169222936.  (streamcomponent.c:4149)
Line 200403: 04078946: 2026-02-22T13:18:06:654173 [TARGET_LOAD     ]T:  Handling End of table 'dbo'.'Test' loading failed by subtask 1 thread 1 [1022502]  (endpointshell.c:3208)
Line 200410: 04078946: 2026-02-22T13:18:06:654173 [TARGET_LOAD     ]E:  Handling End of table 'dbo'.'Test' loading failed by subtask 1 thread 1 [1022502]  (endpointshell.c:3208)
Line 200411: 04078803: 2026-02-22T13:18:06:660685 [TASK_MANAGER    ]W:  Table 'dbo'.'Test' (subtask 1 thread 1) is suspended. Failed (retcode -1) to execute statement: PUT 'file:///opt/qlik/gateway/movement/data/tasks/TASK_QChoo/cloud/1/LOAD00000001.csv' '@"ATTREP_Test_fffaf23b"/1/' AUTO_COMPRESS = TRUE SOURCE_COMPRESSION = NONE OVERWRITE = TRUE;; RetCode: SQL_ERROR  SqlState: HY000 NativeError: 40 Message: [Snowflake][Snowflake] (40) 
Line 200413:     ; Failed to send file opt/qlik/gateway/movement/data/tasks/TASK_QChoo/cloud/1/LOAD00000001.csv to Snowflake stage; Failed to put file 'opt/qlik/gateway/movement/data/tasks/TASK_QChoo/cloud/1/LOAD00000001.csv', size 30857228; Handling End of table 'dbo'.'Test' loading failed by subtask 1 thread 1  (replicationtask.c:3249)

 

SachinB
Support
Support

Hello @Dinesh-Thangarasu ,

 

 1. Verify the ODBC logs

2. If you find any errors related to SSL when Qlik Replicate running the PUT command then it will be mostly related to a firewall issue.

3. Also, could you please run the PUT command outside of Replicate using Snowsql, which will give clarity for the failure.


Regards,

Sachin B