topic Re: Using the to global var in tSystem component in Talend Studio

Using the to global var in tSystem component

Anonymous — Sat, 16 Nov 2024 05:29:31 GMT

Hi ,

I have a job(Main_Job) which calls other jobs(like Job_1, Job_2, Job_3) by using Tsystem component jobs sequentially.

Here my requirement is, if the Job_1 fails i want to capture it in Main_job and kill the remaining jobs which are in the queue.

Can anyone please help me how to capture the error into a context or table.

Thanks in advance.

Regards

ShaX

Re: Using the to global var in tSystem component

Anonymous — Tue, 25 Jun 2019 09:39:15 GMT

Hi
Can you upload a screenshot of your current job design? It will be helpful for us to understand your problem well.
Thanks!
Shong

Re: Using the to global var in tSystem component

Anonymous — Tue, 25 Jun 2019 09:53:17 GMT

Hi @shong ,

PFA images,

As you can in the Caprure1, Before calling the job from Tsystem component, am inserting the job name as "R" in JOBMASTER & JOBEXECUTION, on the called job is completed am updating "R" as "C" and if the job fails i want to update as "F" which am doing as seen in the Capture2.

Regards

ShaX

Capture1.PNG
Capture2.PNG

Re: Using the to global var in tSystem component

Anonymous — Thu, 27 Jun 2019 10:07:05 GMT

Any help on this please

Re: Using the to global var in tSystem component

Anonymous — Thu, 27 Jun 2019 11:57:45 GMT

Hi
What's the error messages thrown on tSystem ? Can you show an error example? I see you have used tLogCatcher component in the job to capture the Java exception or tDie's error.

Regards
Shong

Re: Using the to global var in tSystem component

Anonymous — Fri, 28 Jun 2019 06:41:22 GMT

Hi @shong ,

Suppose am calling 4 jobs using TSystem, in 3rd job i got error like "Table or view doesn't exist".

I can see this error on console.

Here my requirement is to kill the job when an error occurs, instead of calling the next job, which is not happening now.

Please help me how to catch errors coming from TSystem component and kill other jobs in sequence.

Regards

ShaX

Re: Using the to global var in tSystem component

Anonymous — Fri, 28 Jun 2019 19:34:36 GMT

Hi @ShaX ,

By default tSystem Error is passed through Console.

In the basic settings of tSystem chose Standard Output and Error Output to "to Global variable" and call the Global variable in tJava to get the error output.

In addition you can also use the Exit Value Global variable for tSystem in the run if condition to pass the control to your sub Jobs.

((String)globalMap.get("tSystem_1_ERROROUTPUT"))

((Integer)globalMap.get("tSystem_1_EXIT_VALUE"))!=0

Thanks and Regards,

Subhadip

Re: Using the to global var in tSystem component

Anonymous — Tue, 02 Jul 2019 05:24:35 GMT

hi @subhadip13 ,

Thanks for your reply