Seven Stars

Avoid Job Breaking

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Eleven Stars

Re: Avoid Job Breaking

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

Manohar B
5 REPLIES
Fifteen Stars

Re: Avoid Job Breaking

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)

Rilhia Solutions
Thirteen Stars TRF
Thirteen Stars

Re: Avoid Job Breaking

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.


TRF
Eleven Stars

Re: Avoid Job Breaking

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

Manohar B
Eleven Stars

Re: Avoid Job Breaking

Did it help you?

Manohar B
Seven Stars

Re: Avoid Job Breaking

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