One Star

When run job, got cannot be resolved to a variable error, how to debug

Hi Everyone,
I try to run a job, it is from oracle 11gR2 , direct load to Greenplum.
The strange thing is I compare my configuration with a co-worker(he is remote),
he got his loading working and send me all his screen shot.
But when I run my "run"
I got these error.
And I try to run with debug-run, it does not help me, it spit out the error.
Wondering how to really "debug" talend's error
Starting job dom_ttt_to_gp at 18:07 15/05/2014.
connecting to socket on port 3849
connected
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
txn_code_dom5 cannot be resolved to a variable
txn_code_dom5 cannot be resolved to a variable
txn_code_dom5 cannot be resolved to a variable
at project0.dom_ttt_to_gp_0_1.dom_ttt_to_gp.tOracleInput_1Process(dom_ttt_to_gp.java:1026)
at project0.dom_ttt_to_gp_0_1.dom_ttt_to_gp.runJobInTOS(dom_ttt_to_gp.java:2155)
at project0.dom_ttt_to_gp_0_1.dom_ttt_to_gp.main(dom_ttt_to_gp.java:2020)
Job dom_ttt_to_gp ended at 18:07 15/05/2014.
6 REPLIES
Moderator

Re: When run job, got cannot be resolved to a variable error, how to debug

Hi,
You should open the code tab and check if there is error java code. If so, you should adjust/modify your component setting based on it. (for example, missing "", etc..). Your screenshots will be helpful for us to address your issue.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: When run job, got cannot be resolved to a variable error, how to debug

Hi Sabrina,
Thank you so much for your suggestion.
I did open the "code" for that job, but the java code is so long, otherwise, I will cut and paste to here.
I wonder what should I be looking/search for?

Thanks
Dominica
One Star

Re: When run job, got cannot be resolved to a variable error, how to debug

Now, I wonder which version of Java I need for TOS_DI-r111943-V5.4.1
since I am running that version of TalenD in my MAC to do evaluation.
I start questioning about my Java's version on my MAC.
Thanks,
Moderator

Re: When run job, got cannot be resolved to a variable error, how to debug

Hi,
You should pay close attention on error line in java code to find out where is the wrong configuration in your job design.
Could you upload your job design and component setting screenshots into forum?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: When run job, got cannot be resolved to a variable error, how to debug

upload the mapping
and the oracle source component,(though, for the oracle component, I have to change the IP address
and the SID name and the password/user , due to security reason, can't post in any forum)
Hopefully from the image, you could spot what I forget.
Thanks again,

Dominica
Moderator

Re: When run job, got cannot be resolved to a variable error, how to debug

Hi,
For registered users, please click on "post reply" (not through the quick post") to get image upload feature. Here is limitation(20 images per post, each image must be less then 1024x768 pixels and 200 KB).
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.