Qlik Replicate Failure

[NewbieQlik]

I have created a replication task to replicate the data from source oracle DB to snowflake as part of my initial load.For some tables the load failed after loading some portion of the data from the table with below error.

Handling End of table 'schemaname'.'Tablename' loading failed by subtask 8 thread 1
Failed to put file '/opt/attunity/replicate/data/tasks/orcl_conn/cloud/94/LOAD00000005.csv', size 1559884194
Failed to send file /opt/attunity/replicate/data/tasks/orcl_conn/cloud/94/LOAD00000005.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 /opt/attunity/replicate/data/tasks/orcl_conn/cloud/94/LOAD00000005.csv.

Failed (retcode -1) to execute statement: 'PUT 'file:///opt/attunity/replicate/data/tasks/orcl_conn/cloud/94/LOAD00000005.csv' @"snowflakedb"."PUBLIC"."ATTREP_IS_ABC_3c11ce5e_b751_4e72_833d_e64dae8e0389"/94/ AUTO_COMPRESS = TRUE SOURCE_COMPRESSION = NONE ;'

Trying to understand why this failed and how to resolve this

[QFabian]

it seems user permissions to me

[NewbieQlik]

Source table has 28481216 records and when checked the target it has got 24036394 records, so it loaded partial data and then failed. If it due to the user permission then it shouldnt have loaded any records.

[ts_sunilkumar]

Hi:

We too face the same issue. Did you happen to resolve the issue. Please let me know.

[NewbieQlik]

I am not sure the root cause but reloading the table kind of fixed the issue.

[lyka]

Hi,

We've seen issues where in it maybe related to the snowflake odbc driver version.

What version do you use?

Thanks,

lyka

[mbjohnson123]

I just saw the same thing against a SQL Managed Instance.  One table failed out of a hundred and was suspended with the error 40 msg.  I retried and it worked.  SQL Error 40 appeared to be "Unable to open connection" .

RetCode: SQL_ERROR SqlState: HY000 NativeError: 40 Message: [Snowflake][Snowflake] (40)
Error encountered when executing file transfer: Failed to upload file...

[lyka]

Hello,

Please upgrade the snowflake driver to 2.22.3 and retest. There is a fix that maybe related to this issue

https://docs.snowflake.com/en/release-notes/client-change-log-odbc.html

SNOW-219403
Added support for configurable parameters to enable fast fail and specify the maximum number of retries for PUT command failures.

thanks,

Lyka

[SrishtiD]

How can I get the details about SNOW-219403. I need to understand how to enable fast fail and specify max number of retried for PUT.

[AutomatedUser]

Are there any updates on this?  We're on the May 2022 release using v2.24.0 of the Snowflake ODBC driver and we're still experiencing this exact issue.