Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
ramnn
Contributor
Contributor

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

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

Labels (3)
2 Replies
Anonymous
Not applicable

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

 

ramnn
Contributor
Contributor
Author

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