topic Is there a way to run status from tDBRow Component? in Talend Studio

Is there a way to run status from tDBRow Component?

dipanjan93 — Sat, 16 Nov 2024 02:57:39 GMT

I am trying to get run status of tDBRow component using its global variable - (String)globalMap.get("tDBRow_2_ERROR_MESSAGE"). But this is returning no value while printing it using System.out.println in tJava.

Is there way/better way to get the status from tDBRow component?

Re: Is there a way to run status from tDBRow Component?

Anonymous — Wed, 18 Mar 2020 09:22:55 GMT

Hi
Have you checked the 'Die on error' option? If enabled, the component will throws the error once it has error during the execution, otherwise, the status of component is always successful.

Regards
Shong

Re: Is there a way to run status from tDBRow Component?

dipanjan93 — Wed, 18 Mar 2020 16:57:21 GMT

Hi @shong - Fortunately this should have printed success status even if the "Die on Error" option is unchecked!

Re: Is there a way to run status from tDBRow Component?

Anonymous — Thu, 19 Mar 2020 02:37:18 GMT

Hi
The job only returns the execution status of the whole job, not for each component, if you want to output the status of special components, link the component to a tJava or tWarn using onComponentOK for successful or onComponentError for failed, explicitly print or output the status of component.

Regards
Shong