Log error from tDBRow component without stopping the job

quentin-vigne — Thu, 13 Feb 2025 10:24:33 GMT

Hi,

I'm having trouble finding the right way to log SQL error from a tDBRow component without actually stopping the job.

In the above job I have a tLoop component launching in parralel my subjob. the tDBInput retrieve a query from a table and the tDBRow execute that query.

If the tDBRow give back an error, I know it because in the console / TMC there is an "Error" message. Now I want to log this error in a table, I tried using OnComponentError but it doesn't work unless in click on "Die on error" in the tDBRow component, which stop entirely the job and this isn't what I want.

I find it weird that when the component say there is an error, it doesnt trigger automatically the "OnComponentError" and it actually triggers the "OnComponentOk"

I tried using "if" link and other component based on tDBRow_2_ERROR_MESSAGE value, but since I'm parallelizing the job it doesn't log the actual query that is in error

Any idea how to achieve what I want ?

Re: Log error from tDBRow component without stopping the job

Shicong_Hong — Wed, 04 Feb 2026 07:51:39 GMT

Hello

- Move tDBRow component to a child job and log the error in the child job, pass the current query from main job to child job, please refer to this KB article.

- Use a tRunJob component to call the child job, uncheck the 'Die on error' option on tRunJob.

- Check the 'Die on error' option on tDBRow component. This ensures that the component throws out the error, allowing you to catch and log it.

Regards

Shicong

topic Re: Log error from tDBRow component without stopping the job in Talend Studio

Log error from tDBRow component without stopping the job

Re: Log error from tDBRow component without stopping the job