Task failed due to ereror.

[desmondchew]

We have a new task replicating from Oracle 11g on premise into target Snowflake.

We are unable to do a first load.

Table 'DW'.'STG_GIF (subtask 0 thread 1) is suspended. Failed (retcode -1) to execute statement: COPY INTO "LZ_LEGACYODS"."attrep_changes6B7BA0C5A790E127"("seq", "col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", "col11", "col12", "col13", "col14", "col15", "col16", "col17", "col18", "col19", "col20", "col21", "col22", "col23", "col24", "col25", "col26", "col27", "col28", "col29", "col30", "col31", "col32", "col33", "col34", "col35", "col36", "col37", "col38", "col39", "col40", "col41", "col42", "col43", "col44", "col45", "col46", "col47", "col48", "col49", "col50", "col51", "col52", "col53", "col54", "col55", "col56", "col57", "col58", "col59", "col60", "col61", "col62", "col63", "col64", "col65", "col66", "col67", "col68", "col69", "col70", "col71", "col72", "col73", "col74", "col75", "col76", "col77", "col78", "col79", "col80", "col81", "col82", "col83", "col84", "col85", "col86", "col87", "col88", "col89", "col90", "col91", "col92", "col93", "col94", "col

A data error was encountered. Refer to the 'attrep_apply_exceptions' table for details.

May I know where can I find attrep_apply_exceptions table in Snowflake? Is it in the schema Snowflake?

Desmond

[Steve_Nguyen]

@desmondchew 

1. the attrep_apply_exceptions is on snowflake on your public or the schema that task is set for.

2. if attrep_apply_exceptions , then the table most likely is on CDC. so i assume that the full load is complete.

3. you can try to enable upsert for snowflake :

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Implementing-UPSERT-and-MERGE...