Error Logging

[shrikavi2008]

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

[Anonymous]

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.

[shrikavi2008]

Thank You,

I would like to know how to capture the User Defined Error based on the error.

[Anonymous]

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

[Anonymous]

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

---