Snowflake data ingestion issue

[Sukanya2]

I am facing below errors in my Oracle to snowflake data replication environment:

Handling End of table 'WMSOWN'.'TRLR' loading failed by subtask 5 thread 1
Failed to put file 'D:\Attunity\tasks\sgprpt1_logstream_to_snowflake\cloud\47\LOAD00000001.csv', size 1918830
Failed to send file D:\Attunity\tasks\sgprpt1_logstream_to_snowflake\cloud\47\LOAD00000001.csv to Snowflake stage
RetCode: SQL_ERROR SqlState: HY000 NativeError: 40 Message: [Snowflake][Snowflake] (40)
Error encountered when executing file transfer: Failed to upload file D:\Attunity\tasks\sgprpt1_logstream_to_snowflake\cloud\47\LOAD00000001.csv.

Failed (retcode -1) to execute statement: PUT 'file://D:\\Attunity\\tasks\\sgprpt1_logstream_to_snowflake\\cloud\\47\\LOAD00000001.csv' @"CORE_DEV_RL_SGPRPT1_DB"."PUBLIC"."ATTREP_IS_CORE_DEV_RL_SGPRPT1_DB_77289a94_ccd5_3a4d_a142_72eb7f68de2d"/47/ AUTO_COMPRESS = TRUE SOURCE_COMPRESSION = NONE ;

And also the target side, staging directory is fine we checked with the DBA team. Still we are facing this issue.

Any inputs why and how to over come?

[john_wang]

Hello @Sukanya2 ,

Thanks for post in Qlik Community!

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.