topic Re: Failed to remove file: in Qlik Replicate

Failed to remove file:

jm32 — Tue, 16 Apr 2024 14:50:49 GMT

Today we had an error on one of our Qlik Replicate tasks "Failed to remove file:"
Processing aborted due to error 300002:1355844283; incident 3722464.
to execute statement: REMOVE @"PROD"."PUBLIC"."ATTREP_IS_PROD_bf071f72_b1f9_4dc7_b2f8_919759658d9c"/bf071f72_b1f9_4dc7_b2f8_919759658d9c/0/CDC00000215.csv;

What does this error mean?

Re: Failed to remove file:

Dana_Baldwin — Tue, 16 Apr 2024 17:54:37 GMT

Hi @jm32

I don't have documentation on this Snowflake error in our solution database. A web search also did not yield helpful results. Please contact Snowflake support for help with this error code.

Thanks,

Dana

Re: Failed to remove file:

john_wang — Wed, 17 Apr 2024 00:56:58 GMT

Hello @jm32 ,

Agree with @Dana_Baldwin . I happened to find a link from my notes that we ever got such an error before, see article Failed (retcode -1) to execute statement: 'REMOVE.

Hope it helps.

John.

Re: Failed to remove file:

jm32 — Wed, 17 Apr 2024 13:48:09 GMT

Thank you for the reply! I will reach out to Snowflake. It's hard to know what actually failed and if transactions were missed. Should I just do a full reload of the task?

Re: Failed to remove file:

Dana_Baldwin — Wed, 17 Apr 2024 19:07:05 GMT

@jm32

Difficult to say without more context in the log file around when the error happened, and details from Snowflake regarding the error. It's possible the task was able to recover and continue.

Is it feasible to spot check data between source & target to gauge your risk until you have more details from Snowflake?