Skip to main content
Question

Do errors propagate during extraction?

  • March 28, 2023
  • 6 replies
  • 30 views

Forum|alt.badge.img+5

Hi all - looking to complete an extraction and I am running into a behavior that I'm not sure if it is intended. As you can see, one SS shows successful extraction of tables labeled 800 and up. However, when an earlier tabled primed for extraction fails to run (labeled 100-800), the previously shown passing tables fail. Any ideas on what is going on here?

6 replies

Forum|alt.badge.img+14
  • Level 8
  • March 29, 2023

Hi, it says on the error that Metadata has been changes, meaning the current table schema mismatch with the new data. You can resolved this by doing a FULL load or if it is not an option then you can go to extraction settings and select Option B. Included metadata changes.

 

image 

 


Forum|alt.badge.img+5
  • Author
  • Level 2
  • March 31, 2023

Hi Rio,

 

Thanks for the quick reply. That makes sense to solve metadata issues, but my main question was to understand why a failed extraction of one table causes the rest of the queued extractions to fail. Do you have any insight on why that happens?


Forum|alt.badge.img+14
  • Level 8
  • April 3, 2023

Hi, sure, it depends on the data extracted, if the rest of the queued table extract is dependent on the failed extract then the rest will also fail. This is like when the header table fails, so is its Line Item table.

 

HTH


Forum|alt.badge.img+5
  • Author
  • Level 2
  • April 3, 2023

Hi, sure, it depends on the data extracted, if the rest of the queued table extract is dependent on the failed extract then the rest will also fail. This is like when the header table fails, so is its Line Item table.

 

HTH

Is there a method to view the dependencies on a given table? These tables in question do not execute a join on each other or anything.


Forum|alt.badge.img+14
  • Level 8
  • April 3, 2023

Is there a method to view the dependencies on a given table? These tables in question do not execute a join on each other or anything.

Can you provide what data connection or system in question ?


Forum|alt.badge.img+5
  • Author
  • Level 2
  • April 3, 2023

Is there a method to view the dependencies on a given table? These tables in question do not execute a join on each other or anything.

We are using a JDBC connection to a DB2 database.