topic Re: Error Logging in Talend Studio

Error Logging

shrikavi2008 — Mon, 06 May 2019 16:47:10 GMT

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

Re: Error Logging

Anonymous — Mon, 06 May 2019 17:08:58 GMT

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.

Re: Error Logging

shrikavi2008 — Tue, 07 May 2019 06:32:58 GMT

Thank You,

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

Re: Error Logging

Anonymous — Tue, 07 May 2019 16:23:27 GMT

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

Re: Error Logging

Anonymous — Wed, 25 Mar 2020 12:52:39 GMT

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