topic Unable to load context from database in Talend Studio

Unable to load context from database

Anonymous — Tue, 07 Nov 2017 11:38:34 GMT

Hi,

I have a job as below

I am trying to load the context of tmssqlinput from database. So the context details sit in loadcontext table in mysql. The table has the rows as shown below

Now, my when I get to the extra tab of the job the implicit job details are as follows..

And now when I go the contexts tab of the tmssqlcomponent, the details are as follows

Now when I run the job I get the error,

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
***cannot be resolved to a variable
****cannot be resolved to a variable
***cannot be resolved to a variable
*** cannot be resolved to a variable

The *** is the username, password, databasename, and port, that I have hidden due to privacy guidelines

Any help on why I'm unable to get the context from database would be of great help

Thanks
Rathi

Re: Unable to load context from database

Anonymous — Tue, 07 Nov 2017 12:12:03 GMT

Have you defined the context variables in contexts tab?

Re: Unable to load context from database

Anonymous — Tue, 07 Nov 2017 13:24:08 GMT

Yes chirgal, I have defined them as context.host, context.port, context.database, context.username, context.password

Re: Unable to load context from database

Anonymous — Tue, 07 Nov 2017 13:43:11 GMT

The *** is the username, password, databasename, and port, that I have hidden due to privacy guidelines.

Referring to your above statements, I want to ask is, have you used double quotes while entering above value?

I suspect, you r missing double qoutes

Re: Unable to load context from database

Anonymous — Tue, 07 Nov 2017 13:53:49 GMT

Hi chirgal,

Yes, I had missed the double quotes. Thanks for that 🙂

But, I still get the same error when I run the job

Thanks
Rathi

Re: Unable to load context from database

Anonymous — Tue, 07 Nov 2017 13:58:17 GMT

It means you still missing somewhere.
How many errors are you getting now?

Which variables are unresolved now?

Re: Unable to load context from database

Anonymous — Thu, 09 Nov 2017 06:06:00 GMT

Hello,

Have you already checked this online document about:TalendHelpCentercenario: Reading data from different MySQL databases using dynamically loaded connection parameters?

Best regards

Sabrina