HTTP error (http error) - code=404 while executing statements in Snowflake database

[sangeethaLRS]

Hi All,

There is a connectivity error we get in Attunity tasks when it is executing statements in snowflake. It is happening only for few tables that are in tasks.  I tried looking at attrep_apply_exceptions table , but I could not find it in the snowflake database.

Below is the error. Could anyone help on this ?

REST request for URL <snowflake URL> failed: HTTP error (http error) - code=404.
(replicationtask.c:2567)
00002632: 2021-08-31T10:36:39 [TARGET_APPLY ]E: Failed (retcode -1) to execute statement: 'REMOVE @"Database"."PUBLIC"."ATTREP_IS_DATABASE_5a649fb1_9df9_4df7_964d_276188b23c05"/5a649fb1_9df9_4df7_964d_276188b23c05/0/CDC000000AF.csv;' [1022502] (ar_odbc_stmt.c:4862)
00002632: 2021-08-31T10:36:39 [TARGET_APPLY ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: 4 Message: [Snowflake][Snowflake] (4)
REST request for URL <snowflake URL> failed: HTTP error (http error) - code=404.
[1022502] (ar_odbc_stmt.c:4869)

Thanks,

Sangeetha S

[john_wang]

Hello @sangeethaLRS ,

In general it's timeout issue. Can you please add below internal parameters in Snowflake target endpoint, eg

executeTimeout = 900  (default 60   seconds)
loadTimeout    = 1800 (default 1200 seconds)

see below link too:

https://help.qlik.com/en-US/replicate/May2021/Content/Replicate/Main/Snowflake%20Azure%20Target/azur...

if the problem still persists, please open a support ticket with below information:

1. set TARGET_APPLY to Verbose;

2. Reproduce the error, and attach the task Diagnostics Package.

    https://help.qlik.com/en-US/replicate/May2021/Content/Global_Common/Content/SharedEMReplicate/Monito...

Support team will gladly help you.

Regards,

John.

[sangeethaLRS]

Thank you John.

Adding internal parameters does not seem to help. There are still same errors.

Target_apply to be set as internal Parameters or in the Server Logging section? If it is in server Logging section I do see more than components.. Which one to be set as verbose ?

Thanks,

Sangeetha S

[john_wang]

Hello @sangeethaLRS ,

Let's go with a support case.

Regarding the components, see sample below:

Regards,

John.