Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Could not find the context Default

I’ve created a job with connection the oracle DB, and when I try to run it in the tool, I’m getting the error in the picture.

Why the default context list is not available for this job?

Looks like it is something with the settings.

Please advise.

Labels (2)
5 Replies
akumar2301
Specialist II
Specialist II

 

 

it could be jdbc issue. print context and check if these are available before jdbc connection by using tjava or tcontextdump

Anonymous
Not applicable
Author

They are null.
What is the problem?
What should I fix?

Anonymous
Not applicable
Author

I am getting the same problem. I have just upgraded to Talend 7 (Non subscription version) and have imported all my jobs (about 100 of them) and can open and run them in most cases but about 20 of the Jobs have this problem where the context cannot be found when I try to run it from Studio. Even though I can see the contexts no problem in the context tab and everything looks ok

tarting job NBA_Oracle_SASDB_2_CaMaDB_NBAERLIB at 14:03 21/02/2019.

Could not find the context Prod
[statistics] connecting to socket on port 3622
[statistics] connected
Exception in component connectionStatsLogs (NBA_Oracle_SASDB_2_CaMaDB_NBAERLIB)
java.sql.SQLRecoverableException: IO Error: Invalid number format for port number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at java.sql.DriverManager.getConnection(Unknown Source)

Anonymous
Not applicable
Author

My Context groups are in my case "Prod" and "UAT" and for the run above, I was trying to run with "Prod".

 

I tried with build job and then tried to start from windows batch file the job but the contexts directory are missing and the job does not start.

 

I then tried by creating the whole directory structure for context and copied the context properties file manually in and it worked! The job ran successfully.. 

 

So it seems to be a problem in studio with Talend 7.  (I have the latest version downloaded yesterday from sourceforge)

 

Can anyone help out here?

Anonymous
Not applicable
Author

Hi,

The context files like Default.properties have to be in a folder named as your project.

For exemple, this is the directory structure

Directory X

        your_job_launcher.sh

        project_name

              your_job_launcher_0_1

                        Default.properties