Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Getting Error connecting PDI 6.1 with Oracle 12C

  1. #1

    Default Getting Error connecting PDI 6.1 with Oracle 12C

    I have installed Pdi 6.1 CE on Centos 7.Also, i have installed the java 7 and set the JAVA_HOME variable:echo $JAVA_HOME
    /usr/java/jdk1.7.0_80
    Also i have tried to make connection with oracle 12c and getting below mentioned error.Also ,i have copied the required jar file into the lib folder:
    1. ojdbc7
    2. ojdbc7_g
    3. ojdbc7dms
    4. ojdbc7dms_g

    ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsole
    2017/02/15 16:11:11 - user_lookup.0 - at oracle.jdbc.driver.DMSFactory.<clinit>(DMSFactory.java:43)
    2017/02/15 16:11:11 - user_lookup.0 - at oracle.jdbc.driver.PhysicalConnection.createDMSSensors(PhysicalConnection.java:5190)
    2017/02/15 16:11:11 - user_lookup.0 - at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:810)
    2017/02/15 16:11:11 - user_lookup.0 - at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:415)
    2017/02/15 16:11:11 - user_lookup.0 - at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:26)
    2017/02/15 16:11:11 - user_lookup.0 - at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:607)
    2017/02/15 16:11:11 - user_lookup.0 - at java.sql.DriverManager.getConnection(DriverManager.java:571)
    2017/02/15 16:11:11 - user_lookup.0 - at java.sql.DriverManager.getConnection(DriverManager.java:215)
    2017/02/15 16:11:11 - user_lookup.0 - at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:101)
    2017/02/15 16:11:11 - user_lookup.0 - at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:81)
    2017/02/15 16:11:11 - user_lookup.0 - at org.pentaho.di.core.database.Database.normalConnect(Database.java:425)
    2017/02/15 16:11:11 - user_lookup.0 - at org.pentaho.di.core.database.Database.connect(Database.java:364)
    2017/02/15 16:11:11 - user_lookup.0 - at org.pentaho.di.core.database.Database.connect(Database.java:335)
    2017/02/15 16:11:11 - user_lookup.0 - at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.connectDatabase(DatabaseLookup.java:635)
    2017/02/15 16:11:11 - user_lookup.0 - at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.init(DatabaseLookup.java:572)
    2017/02/15 16:11:11 - user_lookup.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
    2017/02/15 16:11:11 - user_lookup.0 - at java.lang.Thread.run(Thread.java:745)
    2017/02/15 16:11:11 - user_lookup.0 - Caused by: java.lang.ClassNotFoundException: oracle.dms.console.DMSConsole
    2017/02/15 16:11:11 - user_lookup.0 - at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
    2017/02/15 16:11:11 - user_lookup.0 - at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    2017/02/15 16:11:11 - user_lookup.0 - at java.security.AccessController.doPrivileged(Native Method)
    2017/02/15 16:11:11 - user_lookup.0 - at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    2017/02/15 16:11:11 - user_lookup.0 - at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
    2017/02/15 16:11:11 - user_lookup.0 - at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    2017/02/15 16:11:11 - user_lookup.0 - ... 17 more
    2017/02/15 16:11:11 - Database lookup.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Error initializing step [Database lookup]
    2017/02/15 16:11:11 - Table output.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Error initializing step [Table output]
    2017/02/15 16:11:11 - Database lookup.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.DMSFactory
    2017/02/15 16:11:11 - Database lookup.0 - at oracle.jdbc.driver.PhysicalConnection.createDMSSensors(PhysicalConnection.java:5190)
    2017/02/15 16:11:11 - Database lookup.0 - at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:810)
    2017/02/15 16:11:11 - Database lookup.0 - at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:415)
    2017/02/15 16:11:11 - Database lookup.0 - at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:26)
    2017/02/15 16:11:11 - Database lookup.0 - at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:607)
    2017/02/15 16:11:11 - Database lookup.0 - at java.sql.DriverManager.getConnection(DriverManager.java:571)
    2017/02/15 16:11:11 - Database lookup.0 - at java.sql.DriverManager.getConnection(DriverManager.java:215)
    2017/02/15 16:11:11 - Database lookup.0 - at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:101)
    2017/02/15 16:11:11 - Database lookup.0 - at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:81)
    2017/02/15 16:11:11 - Database lookup.0 - at org.pentaho.di.core.database.Database.normalConnect(Database.java:425)
    2017/02/15 16:11:11 - Database lookup.0 - at org.pentaho.di.core.database.Database.connect(Database.java:364)
    2017/02/15 16:11:11 - Database lookup.0 - at org.pentaho.di.core.database.Database.connect(Database.java:335)
    2017/02/15 16:11:11 - Database lookup.0 - at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.connectDatabase(DatabaseLookup.java:635)
    2017/02/15 16:11:11 - Database lookup.0 - at org.pentaho.di.trans.steps.databaselookup.DatabaseLookup.init(DatabaseLookup.java:572)
    2017/02/15 16:11:11 - Database lookup.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
    2017/02/15 16:11:11 - Database lookup.0 - at java.lang.Thread.run(Thread.java:745)
    2017/02/15 16:11:11 - Table output.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.DMSFactory
    2017/02/15 16:11:11 - Table output.0 - at oracle.jdbc.driver.PhysicalConnection.createDMSSensors(PhysicalConnection.java:5190)
    2017/02/15 16:11:11 - Table output.0 - at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:810)
    2017/02/15 16:11:11 - Table output.0 - at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:415)
    2017/02/15 16:11:11 - Table output.0 - at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:26)
    2017/02/15 16:11:11 - Table output.0 - at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:607)
    2017/02/15 16:11:11 - Table output.0 - at java.sql.DriverManager.getConnection(DriverManager.java:571)
    2017/02/15 16:11:11 - Table output.0 - at java.sql.DriverManager.getConnection(DriverManager.java:215)
    2017/02/15 16:11:11 - Table output.0 - at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:101)
    2017/02/15 16:11:11 - Table output.0 - at org.osjava.sj.loader.SJDataSource.getConnection(SJDataSource.java:81)
    2017/02/15 16:11:11 - Table output.0 - at org.pentaho.di.core.database.Database.normalConnect(Database.java:425)
    2017/02/15 16:11:11 - Table output.0 - at org.pentaho.di.core.database.Database.connect(Database.java:364)
    2017/02/15 16:11:11 - Table output.0 - at org.pentaho.di.core.database.Database.connect(Database.java:335)
    2017/02/15 16:11:11 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.init(TableOutput.java:523)
    2017/02/15 16:11:11 - Table output.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
    2017/02/15 16:11:11 - Table output.0 - at java.lang.Thread.run(Thread.java:745)
    2017/02/15 16:11:23 - user_ga_activity - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Step [user_lookup.0] failed to initialize!
    2017/02/15 16:11:23 - user_ga_activity - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Step [Table output.0] failed to initialize!
    2017/02/15 16:11:23 - user_ga_activity - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Step [Database lookup.0] failed to initialize!
    Unable to prepare and initialize this transformation

    can anyone suggest me how we can resolve this issues.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Here's how you go about this: Find the jar containing class oracle.jdbc.driver.DMSFactory and get the best download following the links.
    So long, and thanks for all the fish.

  3. #3

    Default

    Thanks a lot for your quick response ..Can you please tell me how i know which jar is compatible with Java 7. ? Any document

    As per my finding oracle 12C is required following jars file which i have already share with u


    Quote Originally Posted by marabu View Post
    Here's how you go about this: Find the jar containing class oracle.jdbc.driver.DMSFactory and get the best download following the links.

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    When I follow the link for ojdbc6dms.jar Oracle says Java 1.4 or newer is required.
    So long, and thanks for all the fish.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.