topic Re: Pass Tcontextload values to parent job in Talend Studio

Pass Tcontextload values to parent job

desanip — Sat, 16 Nov 2024 06:06:41 GMT

Hello everyone,

I am trying to load database parameter values from an external file to tcontextload and then used a tBufferOutput in the child job to push the informations Iwant to return to the parent job.

The schema of the tBufferOutput is be the same as the one which is declared for the tRunJob.

In the parent job i have redshift and aws components that i have to connect to.Can someone tell me how to set context variables in code (in tJava) components?

If someone can send me the job flow or how it should look like, it would be great.

Thanks.

Re: Pass Tcontextload values to parent job

akumar2301 — Tue, 09 Apr 2019 22:14:16 GMT

In tjava

context.variablename = newvalue

Re: Pass Tcontextload values to parent job

desanip — Tue, 09 Apr 2019 22:21:42 GMT

Hi akumar,

Can you please elaborate? In the trunjob, i checked the option "Transmit whole context" and "Die on child error" and i am not passing any context parameters. Next, in the tjava component you said i should have context.variablename = newvalue. what do you mean by new value? I didn't get you. When i use the code context.AWS_accountid = row3.AWS_accountid in tjava, it says aws_accountid variable cannot be resolved or is not a field

Re: Pass Tcontextload values to parent job

manodwhb — Wed, 10 Apr 2019 06:19:28 GMT

@desanip ,chekc the below links,

https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/xH2TyYr_AmQnKwOYlqVCvA

https://community.talend.com/t5/Design-and-Development/Returning-a-value-from-a-child-Job-to-the-parent-Job/ta-p/21571

Re: Pass Tcontextload values to parent job

Anonymous — Wed, 10 Apr 2019 09:12:35 GMT

Hi @desanip

While assigning the value context.AWS_accountid = row3.AWS_accountid could you please try using tjavarow instead of tjava and see if it works.

Regards,

Pratheek Manjunath

Re: Pass Tcontextload values to parent job

akumar2301 — Wed, 10 Apr 2019 10:55:58 GMT

in ParentJob

Re: Pass Tcontextload values to parent job

desanip — Wed, 10 Apr 2019 14:02:10 GMT

Thanks for the replies everyone.

I am afraid i still dont get it. All i am trying to do is to return the values of the child job to parent job. In job4 i am bringing the database conenction parameters as a key/value pair and passign to tbuuferout. in job3 I am using trunjob to call the child job and then use a tjavarow to set the context so that i can use them in s3 and redshift components. In the trunjob, do i just check "Transmit whole context" and it should take care of everything?

In the tjavarow, i am setting contexts like this "context.AWS_accountid = input_row.AWS_accountid". Is this correct?

Job3 screenshot has the parent job.

Job4 is the child job.

job3.PNG
job4.PNG

Re: Pass Tcontextload values to parent job

akumar2301 — Wed, 10 Apr 2019 14:10:45 GMT

"Transmit whole context" is to transfer context from Parent to child not otherway around.

http://garpitmzn.blogspot.com/2012/11/transmit-whole-context-from-parent-to.html

Re: Pass Tcontextload values to parent job

desanip — Wed, 10 Apr 2019 15:22:54 GMT

Ok abhishek. In that case what should i be passing the context param section of trunjob? Should i assign context variables in tjavarow? If so, can you please show me how?

Thanks for your patience and prompt replies

Re: Pass Tcontextload values to parent job

akumar2301 — Wed, 10 Apr 2019 15:29:57 GMT

I am not sure what is your use case but if you want to transfer context from child to Parent , you can simply follow the screen shot which I gave above.

in Child

tContextDump -- tBufferOutput

in Parent -

tRunjob ( same schema as tContextDump ) -- tContextLoad

Re: Pass Tcontextload values to parent job

desanip — Wed, 10 Apr 2019 16:22:29 GMT

I will try to explain to the best of my abilities:

I am trying to bring in the context from outside of the talend job(Storing all the context in properties file). So i am loading all the context using tcontextload and then using tcontextdump and then encoding the password and then to ttbufferout . I am fine until here. So i want to make this a resuable job and use this in all the exising talend jobs i have and use the context in s3 and redshift components.. So i am using trunjob in the parent job. I have not checked the "transfer all context".

From here on, I am having the problem. You said connect the tcontextload to trunjob in parent, I did the same and it doesn't seem to work. Do you think what you see in the data flow screenshot is, right?

job5.PNG
job7.PNG

Re: Pass Tcontextload values to parent job

desanip — Thu, 11 Apr 2019 02:47:53 GMT

Thanks aravind and everyone who replied.
The job is working now as expected.