topic Re: tlogcatcher is not been called when SFTP connection in subjob fails. in Talend Studio

tlogcatcher is not been called when SFTP connection in subjob fails.

ramnn — Fri, 12 Oct 2018 16:51:52 GMT

Hi,

My use case is as follows.

1. Main job - This will call 2 subjobs
2. Subjob - I am doing file transfer in my 2nd subjob. I got sftp connection (ConnectException) when trying to connect to SFTP server. My job got tLogCatcher in my subjob but that was not been called in this error scenario.

Note: I have unchecked "Die on Error" from all the components and checked "Catch Java Exception", "Catch tDie", "Catch tWarn" and "Catch tActionFailure" in tLogCatcher.

I have attached my main and sub job.

Please help!

Regards

Re: tlogcatcher is not been called when SFTP connection in subjob fails.

Anonymous — Sat, 13 Oct 2018 07:17:16 GMT

Ram,

The appropriate way to handle error is to connect the SFTP component to a tDie or tWarn using onComponentError.

SFTP failure is not a java exception. You have also unchecked the "Die on error" in the component. So to cauch the error, it needs to be connected with onComponentOK.

Please use tWarn and tDie where ever you wanted to handle the error with a return code greater than 0. You can also use tJava component and use system.exit(1);

Hope this helps!!!!

Regards,

Ragu

Re: tlogcatcher is not been called when SFTP connection in subjob fails.

ramnn — Wed, 17 Oct 2018 13:08:17 GMT

Hi Ragu,

Thanks for your reply. Actually SFTP connection failure is throwing "java.net.ConnectException". There was a problem with MySql component which was stopping the mysql update and an email option.

Thanks for your help.

Regards