As shown in attached job design there is an error coming in component “tMSSQLSP_2” which is causing job to break i.e. flow after that component is not getting executed. This could be an issue as the flow after component “tMSSQLSP_2” is required to execute.
Just for your information we are executing stored proc through tMSSQLSP_2 and that stored procedure is throwing timeout error.
Is there a way we could avoid breaking of job it should complete its execution.
Solved! Go to Solution.
Your error is down to an unknown server host name. The flow after that component cannot run since it looks like it requires the data that should be returned by the SP.
There are ways to ensure that certain pieces of code ALWAYS run even with Java errors. You can use a tPostJob component to do this (https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/tBjLn1bVQ~QUAlLKz27rCQ)
As the component (tFilterColumns) need the input flow issued from tMSqlSP, if this one failed, the job can't continue.
Based on the error message in the console, it seems the hostname is unknown; check this point first.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.