topic Incorrect Error Code in Talend Studio

Incorrect Error Code

pavannani — Sat, 16 Nov 2024 02:38:28 GMT

Hi,

I just could not figure out why my simple tMSSQLRow component does not return Error Code = 1 when there is an error in the sql statement.

I printed error message (using global variable) but it is null. Job has no pre or post components.

version I am using 7.1.1

Is this a bug?

job design and error

Re: Incorrect Error Code

manodwhb — Thu, 23 Apr 2020 05:28:44 GMT

@pavannani , is that query is working in outside of Talend?

Re: Incorrect Error Code

pavannani — Thu, 23 Apr 2020 05:36:04 GMT

Hi Manohar,

No. I changed it so that it errors out as part of my negative testing.

When I check the Die on error option. It exits with error code 1 and the process stops, however I would like the component to fail so I can do other tasks based on that.

Thanks,

Pav

Re: Incorrect Error Code

billimmer — Thu, 23 Apr 2020 14:50:36 GMT

If you put the tMSSQLRow in a sub job you can let it die, and then on the tRunJob component, you can uncheck "die on error" for the sub job. Then you can take other actions based on whether the sub job died or not.

Re: Incorrect Error Code

pavannani — Fri, 24 Apr 2020 08:23:14 GMT

Hi billimmer,

Thanks for your reply. I didn't quite understand the job flow. I can understand you are giving me a work around, however I was wondering why the tMSSQLRow is not failing in the first place with error code 1 when there is an error in the SQL.

Thanks,

Pav