Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
it could be jdbc issue. print context and check if these are available before jdbc connection by using tjava or tcontextdump
They are null.
What is the problem?
What should I fix?
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)
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?
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