AnsweredAssumed Answered

Job "Load Data Warehouse" cannot connect to DWH database

Question asked by GeorgSchmid2014 on Jul 8, 2015
Latest reply on Jul 8, 2015 by GeorgSchmid2014

Hi all,

 

While I can access my DWH Oracle database with sqlplus and Toad, the ETL Job "Load Data Warehouse" cannot connect to the DWH database.

 

Could this be related to the JDBC driver used by the Kettle tool?

 

Any hint is highly welcome

 

This is the messing in the bg-dwh.log:

 

Error connecting to database: (using class com.ca.clarity.jdbc.oracle.OracleDriver)

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (ppm_dwh) was not recognized by the Oracle server.

 

 

 

 

  at org.pentaho.di.core.database.Database.normalConnect(Database.java:415)

  at org.pentaho.di.core.database.Database.connect(Database.java:353)

  at org.pentaho.di.core.database.Database.connect(Database.java:306)

  at org.pentaho.di.core.database.Database.connect(Database.java:294)

  at org.pentaho.di.job.Job.beginProcessing(Job.java:966)

  at org.pentaho.di.job.Job.execute(Job.java:474)

  at org.pentaho.di.job.Job.run(Job.java:407)

Caused by: org.pentaho.di.core.exception.KettleDatabaseException:

Error connecting to database: (using class com.ca.clarity.jdbc.oracle.OracleDriver)

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (ppm_dwh) was not recognized by the Oracle server.

 

 

  at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:540)

  at org.pentaho.di.core.database.Database.normalConnect(Database.java:399)

  ... 6 more

Caused by: java.sql.SQLNonTransientConnectionException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (ppm_dwh) was not recognized by the Oracle server.

  at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)

  at com.ca.clarity.jdbc.oracle.OracleImplConnection.a(Unknown Source)

  at com.ca.clarity.jdbc.oracle.OracleImplConnection.ah(Unknown Source)

  at com.ca.clarity.jdbc.oracle.OracleImplConnection.b(Unknown Source)

  at com.ca.clarity.jdbc.oracle.OracleImplConnection.z(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.BaseConnection.b(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.BaseConnection.k(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.BaseConnection.a(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.BaseConnection.a(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.BaseDriver.connect(Unknown Source)

  at java.sql.DriverManager.getConnection(DriverManager.java:571)

  at java.sql.DriverManager.getConnection(DriverManager.java:215)

  at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:524)

  ... 7 more

Outcomes