topic Re: Custom Error Handling in Talend Studio

Custom Error Handling

shrikavi2008 — Wed, 15 May 2019 03:32:14 GMT

Hi,

I'm working on Error Logging.

I want to insert a record in Audit log table and another records in Error Log table in case of job failure or any validation issue,

The reason to insert a records in Audit_Log is Log_Id(PK) in Audit_Log is FK in Error Log Table.

Audit_Log Error_Log

======= ========

Log_Id Error_Code

Job_Status Error_desc

Start_Time Log_Id

End_Time

For this requirement, my joblet design will be as below

tLogCatcher =====> tmap =====> Audit_Log(Not AMC table, it custom table)

| onsubjobok

tjava(dummy)

| oncomponentOk

tLogCatcher =====> tmap =====> Error_Log(Not AMC table, it custom table)

Not able to connect above 2 tLogCatcher component with onsubjobok hence used tjava(dummy)

Could you please let me know anyone has better approach than this

Re: Custom Error Handling

Anonymous — Fri, 17 May 2019 17:59:51 GMT

Subjobs starting with the tLogCatcher do not need to be attached to any other subjobs. They are not really part of the normal job flow. Just don't connect them.

Re: Custom Error Handling

shrikavi2008 — Sat, 18 May 2019 02:47:28 GMT

@rhall Thank your reply.

The reason to connect the 2 subjob is first insert a record in to Audit_log table(Log_Id is a PK), then insert into another record in Error_log table with Log_Id(get the Log_Id from Audit_Log)

Re: Custom Error Handling

Anonymous — Sat, 18 May 2019 12:21:59 GMT

OK. If an order is important, you could simply link your tLogCatcher to a tHashOutput component. Then at the end of your job use a tHashInput (connected to a tPostJob component) to retrieve your logs from memory and add them to both tables in the order in which you wish.