Avoid Job Breaking

[Anonymous]

Hi,

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.

[Anonymous]

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)

[TRF]

Hi,

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.

[manodwhb]

can you use On Component Error from tMSSqlSP_2 to tJava and print massage like storeprocedure failed.

[manodwhb]

Did it help you?

[Anonymous]

Sorry for the delayed response. Actually i was out of office for some days.