Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to design a joblet to capture any error in Talend job.
Error Reference Table
=================
Error Code | Error Desc
1010 | Database Correction Error
1020 | Schema validation error
Error Logging Table
===============
Below is the list of columns in Error log table
JobName
Error Code
Error Description
If my job failed with database connection,then I have to insert a entry in Error logging table with error code as "1010" and error description as "Database Correction Error"
Could you please help me
Thanks in advance
Try using a tPostJob component for this logging. A tPostJob component will ensure that anything connected to it will definitely run at the end of your job, even if your job has a critical error before it gets to that point.
Thank You,
I would like to know how to capture the User Defined Error based on the error.
Look at the "Outline" view on your Studio and you can expand each of the components to reveal globalMap values associated with the components. These can be dragged and dropped onto a tJava (to get the Java code) then copied to wherever you want to use them. Take a look here: https://www.talendbyexample.com/talend-studio-outline-panel-reference.html
Do you have answer for this ? Were you able to achieve it ?
How is your joblet designed ?Any suggestions will be highly appreciated.
@shrikavi2008 wrote:
Hi,
I want to design a joblet to capture any error in Talend job.
Error Reference Table
=================
Error Code | Error Desc
1010 | Database Correction Error
1020 | Schema validation error
Error Logging Table
===============
Below is the list of columns in Error log table
JobName
Error Code
Error Description
If my job failed with database connection,then I have to insert a entry in Error logging table with error code as "1010" and error description as "Database Correction Error"
Could you please help me
Thanks in advance