General Discussion

 View Only

Pentaho Server 7.1 with Kettle transformation with database connection

  • 1.  Pentaho Server 7.1 with Kettle transformation with database connection

    Posted 17 days ago

    Hello Pentaho Developer Community,

    I am using Pentaho server 7.1 in that I defined my database connection in "Manage Data Source" , also defined in context.xml( Also check connection independtly) . I also tested all connection working perfectly but when I run kettle transformation it gives the below error.

    org.pentaho.di.core.exception.KettleDatabaseException: 
    2022/05/05 19:13:56 - Test - Unable to get database metadata from this database connection
    2022/05/05 19:13:56 - Test -  at java.lang.Thread.run (Thread.java:748)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:69)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.trans.steps.tableinput.TableInput.init (TableInput.java:356)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.trans.step.BaseStep.stopAll (BaseStep.java:2915)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.trans.Trans.stopAll (Trans.java:1889)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning (TableInput.java:299)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.core.database.Database.cancelQuery (Database.java:727)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2917)
    2022/05/05 19:13:56 - Test - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
    2022/05/05 19:13:56 - Test - Unable to get database metadata from this database connection
    2022/05/05 19:13:56 - Test -  at java.lang.Thread.run (Thread.java:748)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:69)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.trans.steps.tableinput.TableInput.init (TableInput.java:356)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.trans.step.BaseStep.stopAll (BaseStep.java:2915)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.trans.Trans.stopAll (Trans.java:1889)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning (TableInput.java:299)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.core.database.Database.cancelQuery (Database.java:727)
    2022/05/05 19:13:56 - Test -  at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2917)
    2022/05/05 19:13:56 - Test - 
    2022/05/05 19:13:56 - Test - 	at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2919)
    2022/05/05 19:13:56 - Test - 	at org.pentaho.di.core.database.Database.cancelQuery(Database.java:727)
    2022/05/05 19:13:56 - Test - 	at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:299)
    2022/05/05 19:13:56 - Test - 	at org.pentaho.di.trans.Trans.stopAll(Trans.java:1889)
    2022/05/05 19:13:56 - Test - 	at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2915)
    2022/05/05 19:13:56 - Test - 	at org.pentaho.di.trans.steps.tableinput.TableInput.init(TableInput.java:356)
    2022/05/05 19:13:56 - Test - 	at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
    2022/05/05 19:13:56 - Test - 	at java.lang.Thread.run(Thread.java:748)
    2022/05/05 19:13:56 - Test - Caused by: java.lang.NullPointerException
    2022/05/05 19:13:56 - Test - 	at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2917)
    2022/05/05 19:13:56 - Test - 	... 7 more