topic Re: [resolved] tMysqlInput ignore error in Talend Studio

[resolved] tMysqlInput ignore error

Anonymous — Sat, 04 Feb 2017 02:43:08 GMT

hi,
have a job that has to iterate a set of records and feed it to tMysqlInput component. I want to set it up in a way that even if tMysqlInput encounters an error, it will proceed to the next iteration.
tMysqlInput_1 -> IterateEachRecord ->tMysqlInput_2 -> tMysqOutput_1
Please help me on how to do this.

thank you so much!
-Chim

Re: [resolved] tMysqlInput ignore error

Anonymous — Sat, 04 Feb 2017 04:18:58 GMT

You need to design the jobs like this:
main job:
tmysqlinput1--iterate--tRunJob

tRunJob: call the child job, and pass the current record to child job, refer to this KB article to learn how to pass data from main job to child job with context variables, uncheck the 'die on error' option to make the main job continue to execute even though the child encounters an error.

child job:
tMysqlInput_2 -> tMysqOutput_1

Regards
Shong

Re: [resolved] tMysqlInput ignore error

Anonymous — Sat, 04 Feb 2017 06:04:50 GMT

great - thanks!