Incorrect Error Code

[pavannani]

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

[manodwhb]

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

[pavannani]

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

[billimmer]

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.

[pavannani]

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