Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

"Die on error" Property not working for tRedshiftRow component

Highlighted
Four Stars

"Die on error" Property not working for tRedshiftRow component

Hi - Below is an behavior that I have noticed while using the tRedshiftRow Component. Can you please let me know if this is a bug or if I am doing something wrong?
As seen in my first Screenshot I have a 'tRedshiftRow' component and an insert statement within it. I have checked the property 'Die on error' for this component so that incase of any errors while doing the insert the process will die and exit. 
However incase of any errors the process is not exiting and instead moving on to the next step in my Job Flow when i connect by the link 'On Component ok'. 
The only way I was able to get the process to exit incase of failure was to add the 'tDie' component explicitly to get it to work. Shouldn't the 'Die on error' property work instead of adding the 'tDie' Component incase of any error?







Thanks,

Highlighted
Moderator

Re: "Die on error" Property not working for tRedshiftRow component

Hi,
The 'die on error' option will stop to run once there is an error.
What's the error message you are catching when doing the insert?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Four Stars

Re: "Die on error" Property not working for tRedshiftRow component

The error message is some data format issue, I am trying to insert a string into a filed which is larger than the defined size of field. I am trying to load 3 files and of them one file has bad data. I was expecting the process to Die the moment it encounters a issue and not proceed to next component. However the process just continues by throwing that error mesg and moves on to the next step. However once i add a 'tDie' component with link as onComponent error the process aborts incase of Error.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog