topic Re: With any DB connection issue or unknown error, need to update a record in table in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 04:41:37 GMT

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.

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

fdenis — Thu, 12 Sep 2019 15:58:43 GMT

are you on free (open) or enterprise version?

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

Anonymous — Fri, 13 Sep 2019 06:38:26 GMT

I am using free version.

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

fdenis — Fri, 13 Sep 2019 08:31:41 GMT

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

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

Anonymous — Fri, 13 Sep 2019 10:10:50 GMT

Any update?

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

Anonymous — Fri, 18 Oct 2019 08:20:28 GMT

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