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

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

sangeethaLRS — Fri, 15 Nov 2024 22:36:50 GMT

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

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

john_wang — Wed, 01 Sep 2021 05:00:50 GMT

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/azure_advanced_prop_SNOW.htm

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/Monitor%20and%20Control%20Tasks/monitor_download_diagnostics.htm

Support team will gladly help you.

Regards,

John.

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

sangeethaLRS — Wed, 01 Sep 2021 05:44:51 GMT

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

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

john_wang — Wed, 01 Sep 2021 06:46:40 GMT

Hello @sangeethaLRS ,

Let's go with a support case.

Regarding the components, see sample below:

Regards,

John.