With any DB connection issue or unknown error, need to update a record in table

[Anonymous]

Hi Team,

We are having a scenario where we are iterating list of 5 files through tFileslist and performing various validation and accordingly moving data in some reject data.

Now, we also need to handle a scenario where in case there is any other issue, other than data error like "DB connection" then we have a table where we have filename and status.

So, based on such error like DB connection then we need to update this table for each file with status as 'E'.

Please suggest how to handle these specific error and accordingly update the Postgres DB table.

[fdenis]

are you on free (open) or enterprise version?

[Anonymous]

I am using free version.

[fdenis]

in this case you have to use tLogCatcher.
https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/pMRz1pl8Bv14KnTdRWjiTA

[Anonymous]

Any update?

[Anonymous]

Hello @rohitatcs 

It is very convenient to set the log in job view or use logs and errors to output the record into file or table.

Logs table usually records the messages from Java Exception, tDie and/or tWarn.

Best regards

Sabrina