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