While creating database job or DBMS type Oracle, following error is getting displayed while doing Test Connection.
_AWSJCS011E An internal error has occurred. The error is the following: "AWKJDE142E The get execution log could not be requested from the address "https://<hostname>:<port-no>/ita/JobManager"_
_The following error occurred: "AWSITA122E A Java exception occurred while calling the command "TestConnection". " "._
And also while submitting and running the same job, following error traces are coming:
Sep 14, 2012 6:24:30 PM com.ibm.scheduling.agent.core.jobexecutor.LocalJobExecutorManager executeJob
SEVERE: The following execption occured while executing job 'BHUKRK219280D_1#JOBS.DATABASE2.JNUM-81088074'
Throwable occurred: com.ibm.scheduling.exception.OperationFailedException: oracle.jdbc.driver.DMSFactory (initialization failure)
Caused by: java.lang.NoClassDefFoundError: oracle.jdbc.driver.DMSFactory (initialization failure)
Please note that I've also created a Database Job using DB2, and the job executed succesfully.
Thanks and Regards,
This topic has been locked.
2 replies Latest Post - 2012-10-05T12:52:55Z by SystemAdmin
Pinned topic Error in Creating Database Jobs of Oracle Type
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-05T12:52:55Z at 2012-10-05T12:52:55Z by SystemAdmin
Re: Error in Creating Database Jobs of Oracle Type2012-10-05T07:15:57Z in response to SystemAdminHi Anand,
Please check your Oracle DB Driver and Lib path, the error likely with JDBC Driver / class path (java.lang.NoClassDefFoundError: oracle.jdbc.driver.DMSFactory).
Re: Error in Creating Database Jobs of Oracle Type2012-10-05T12:52:55Z in response to SystemAdminHi Janak,
You are right, the issue is because of JDBC Driver / Class Path only, we have tried many options on the same but unable to resolve it.
Oracle server 11gr2 is installed on the same machine. Is client also required? Is it something wrong with the installation of Oracle server.
The same TWS setup is running the DB2 Database Jobs successfully.
Any help / suggestion further is highly appreciable.