Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sangeethaLRS
Contributor
Contributor

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

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

Labels (1)
3 Replies
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
sangeethaLRS
Contributor
Contributor
Author

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
Support
Support

Hello @sangeethaLRS ,

 

Let's go with a support case.

Regarding the components, see sample below:

john_wang_0-1630478766014.png

 

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!