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,
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:57ZThis is the accepted answer. This is the accepted answer.Hi 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:55ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
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.