Topic
  • 2 replies
  • Latest Post - ‏2012-10-05T12:52:55Z by SystemAdmin
SystemAdmin
SystemAdmin
194 Posts

Pinned topic Error in Creating Database Jobs of Oracle Type

‏2012-10-03T11:08:07Z |
Hi,

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)
at com.ibm.scheduling.jobexecutor.JobExecutorManagerSupport.connectAndExecute(JobExecutorManagerSupport.java:139)
at com.ibm.scheduling.agent.core.jobexecutor.LocalJobExecutorManager.executeJob(LocalJobExecutorManager.java:137)
at com.ibm.scheduling.osgi.Framework.executeJob(Framework.java:105)

Caused by: java.lang.NoClassDefFoundError: oracle.jdbc.driver.DMSFactory (initialization failure)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:140)
at oracle.jdbc.driver.PhysicalConnection.createDMSSensors(PhysicalConnection.java:3601)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:626)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:222)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:542)
at com.ibm.scheduling.agent.database.jobexecutor.FakeDriver.connect(FakeDriver.java:38)
at java.sql.DriverManager.getConnection(DriverManager.java:322)
at java.sql.DriverManager.getConnection(DriverManager.java:358)
at com.ibm.scheduling.agent.database.jobexecutor.DatabaseJobExecutor.createConnection(DatabaseJobExecutor.java:319)
at com.ibm.scheduling.agent.database.jobexecutor.DatabaseJobExecutor.execute(DatabaseJobExecutor.java:466)
at com.ibm.scheduling.jobexecutor.JobExecutorManagerSupport.execute(JobExecutorManagerSupport.java:349)
at com.ibm.scheduling.jobexecutor.JobExecutorManagerSupport.connectAndExecute(JobExecutorManagerSupport.java:135)
at com.ibm.scheduling.agent.core.jobexecutor.LocalJobExecutorManager.executeJob(LocalJobExecutorManager.java:137)
at com.ibm.scheduling.osgi.Framework.executeJob(Framework.java:105)

Please note that I've also created a Database Job using DB2, and the job executed succesfully.
Thanks and Regards,
Anand
Updated on 2012-10-05T12:52:55Z at 2012-10-05T12:52:55Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    194 Posts

    Re: Error in Creating Database Jobs of Oracle Type

    ‏2012-10-05T07:15:57Z  
    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).
  • SystemAdmin
    SystemAdmin
    194 Posts

    Re: Error in Creating Database Jobs of Oracle Type

    ‏2012-10-05T12:52:55Z  
    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).
    Hi 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.

    Please Note:
    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.

    Thanks,
    Anand Amit