Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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