topic Re: Updated context variable value for toracleinput component in Talend Studio

Updated context variable value for toracleinput component

Anonymous — Wed, 17 Oct 2018 09:02:34 GMT

Hi,

tOracleInput component is not taking context variable updated value. Context variable default value updated in tjava component and connect to toracleinput component with 'OnComponent Ok' link. After updating the context variable value,tjava component is printing updated value and same updated value needs to be used in toracleinput component. However updated context variable value is not passing to toracleinput component and throwing error.

My graph design is :

tsystem -> tjavarow -> tjava -> toracleinput

Please assist.

Regards,

Vivek

Re: Updated context variable value for toracleinput component

Anonymous — Wed, 17 Oct 2018 10:00:12 GMT

Can anybody assist on this issue please ?

Re: Updated context variable value for toracleinput component

fdenis — Wed, 17 Oct 2018 10:00:40 GMT

tOracleIput create connection before job main execution.
if you want to set context to tOracle Input, the best way is to use tRunJob
to set context previously to calling subjob.
so:
create on job with tOracleInput and ….
create a job calling previous one with tRunJob

Re: Updated context variable value for toracleinput component

Anonymous — Wed, 17 Oct 2018 11:29:12 GMT

Used tRunjob and transmit that part to another graph. However still getting the same error.

Regards,

Vivek

Re: Updated context variable value for toracleinput component

Anonymous — Wed, 17 Oct 2018 12:12:26 GMT

Hi,

Can u please share the screen shot of tjava and tOracleInput?

Regards,
Ragu

Re: Updated context variable value for toracleinput component

Anonymous — Wed, 17 Oct 2018 13:14:17 GMT

Cannot upload graph screenshot. However following are the components used in graph.

tSystem - row (main)-> tJavaRow -On Component Ok -> tJava -On Component Ok-> tOracleinout

Regards,

Vivek

Re: Updated context variable value for toracleinput component

Anonymous — Wed, 17 Oct 2018 13:53:18 GMT

Hi Vivek,

Is there any specific reason for using the On Component Ok in your flow? Could you please try below flow and let us know whether there are any changes?

I have used On SubJob Ok in the skeleton flow.

Warm Regards,

Nikhil Thampi

Re: Updated context variable value for toracleinput component

Anonymous — Thu, 18 Oct 2018 08:37:41 GMT

Hi Nikhil,

Thanks .There is no specific reason to use 'oncomponent ok ' however after changing graph according to your design .toracleinput component is throwing same error like below.

Exception in component tOracleInput_1

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Scenario is that tsystem will return db pwd and that db pwd should be updated to old context.password value.Bec context.password is used in toraclecomponent to connect to db.The issue is toracleinput component is not taking the updated context variable value,which is printing correctly in previous tJava component.

Regards,

Vivek

Re: Updated context variable value for toracleinput component

Anonymous — Thu, 18 Oct 2018 08:43:18 GMT

Hi Vivek,

Could you please share the screen shots of tjava and tOracleInput Components for further validation?

You can mask any sensitive information. But I believe you are using variables everywhere without hardcoding. So in ideal case, it should not be a problem.

If the security aspects of your company is not allowing you to take screen shots, I would advise you to raise a Talend support ticket so that they can help you through official channels.

Warm Regards,

Nikhil Thampi