Catch all type of errors

[McJingles]

How to catch all types of errors in Talend.?

Is there any examples of generating an error and catch those errors.

Please let me know how to do that.

Thanks in Advance..!!

[Anonymous]

Hi
You can use tLogCatcher to catch the Java error, customize error thrown by tDie component. To generate an example error for testing, use tFileInputDelimited to read the a file that does not exist, it will thrown FileNotFound Java exception.

Regards
Shong

[McJingles]

Thanks @shong 

But, I can catch Java exception error and SQL query error by using tLogCatcher alone.

How can I catch the errors like Data truncation and Type mismatch: int to string errors.?

Capture.JPG

[Anonymous · Accepted solution]

If these error occurs on DB components, and you want to catch them, check the 'Die on error' box, these SQL error will be thrown out and can be captured by tLogCatcher.

[McJingles]

Thanks @shong 

And one more is how can I catch the mismatch type error like int to string which occurs in the tMap component.?

[Anonymous]

The mismatch type error is Java exception error, make sure the 'die on error' box is checked on tMap.

[McJingles]

There is no such option in the tMap component, @shong 

[Anonymous]

Hello,

Please see the setting screenshot.

Best regards

Shong

[tnewbie]

Hello Shong,

Enabling 'Die on Error' would fail the job, is there where the job would still move on and enable us to capture the errors.

Example:

I have Million records in my source table, 999999th record has a data value that will be truncated, if I enable 'Die on Error' this error will be captured but my job would fail, is there a way where i would still continue and be able to capture the error?

Thanks

[Anonymous]

@tnewbie, it is possible capture the error and continue to process next record, you need to iterate the records one by one, but the performance is bad if the data volume is big.