java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error getting views from schema [null] Column not found

Pentaho BI Platform Tracking | Elry Allen | 5 years ago
  1. 0

    BMC ODBC Driver is version: 7.5 I have searched the archives and found some interesting threads on the BMC ODBC driver; however, I have yet to see a resolution. Pentaho Spoon currently shows "Remedy Action Request System" as a connection type under Database Connections. When I test the connection I get the message: Connection to database [ARS_CONN] is OK. Hostname: Port : 1521 Database Name: ARS_CONN This type of connection fails because it looks like it has the wrong information. Somehow the settings are being translated into a database connection. This approach will fail since the BMC ODBC Driver does not connect to the database, but it connects to the BMC Application Server using Remedy server login parameters. The Remedy tables that are presented through this driver are not tables, but views that are composite of multiple underlying tables. Is there anyway Spoon can be setup to just call the ODBC Driver and pass it parameters to make the connection? Yes, we can connect to the Database directly using the Database Connection types, but then we will have to do a number of conversions on a lot of fields. When you go through the Remedy ODBC Driver - there are no conversions. If a Spoon Developer needs more information - please let me know. Thanks. This is the error that results: ========================================================================= java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error getting views from schema [null] Column not found at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:71) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error getting views from schema [null] Column not found at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:393) at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:67) ... 1 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error getting views from schema [null] Column not found at org.pentaho.di.core.database.Database.getViewMap(Database.java:4068) at org.pentaho.di.core.database.Database.getViews(Database.java:4002) at org.pentaho.di.core.database.Database.getViews(Database.java:3997) at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:371) ... 2 more Caused by: java.sql.SQLException: Column not found at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(Unknown Source) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source) at org.pentaho.di.core.database.Database.getViewMap(Database.java:4060) ... 5 more =========================================================================

    Pentaho BI Platform Tracking | 5 years ago | Elry Allen
    java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error getting views from schema [null] Column not found
  2. 0

    BMC ODBC Driver is version: 7.5 I have searched the archives and found some interesting threads on the BMC ODBC driver; however, I have yet to see a resolution. Pentaho Spoon currently shows "Remedy Action Request System" as a connection type under Database Connections. When I test the connection I get the message: Connection to database [ARS_CONN] is OK. Hostname: Port : 1521 Database Name: ARS_CONN This type of connection fails because it looks like it has the wrong information. Somehow the settings are being translated into a database connection. This approach will fail since the BMC ODBC Driver does not connect to the database, but it connects to the BMC Application Server using Remedy server login parameters. The Remedy tables that are presented through this driver are not tables, but views that are composite of multiple underlying tables. Is there anyway Spoon can be setup to just call the ODBC Driver and pass it parameters to make the connection? Yes, we can connect to the Database directly using the Database Connection types, but then we will have to do a number of conversions on a lot of fields. When you go through the Remedy ODBC Driver - there are no conversions. If a Spoon Developer needs more information - please let me know. Thanks. This is the error that results: ========================================================================= java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error getting views from schema [null] Column not found at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:71) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error getting views from schema [null] Column not found at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:393) at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:67) ... 1 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error getting views from schema [null] Column not found at org.pentaho.di.core.database.Database.getViewMap(Database.java:4068) at org.pentaho.di.core.database.Database.getViews(Database.java:4002) at org.pentaho.di.core.database.Database.getViews(Database.java:3997) at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:371) ... 2 more Caused by: java.sql.SQLException: Column not found at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(Unknown Source) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source) at org.pentaho.di.core.database.Database.getViewMap(Database.java:4060) ... 5 more =========================================================================

    Pentaho BI Platform Tracking | 5 years ago | Elry Allen
    java.lang.reflect.InvocationTargetException: Problem encountered getting information from the database: org.pentaho.di.core.exception.KettleDatabaseException: Unable to retrieve database information because of an error Error getting views from schema [null] Column not found
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Read excel file - Java Programming Help - KnowCoding.com

    knowcoding.com | 1 year ago
    java.sql.SQLException: Column not found

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Column not found

      at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn()
    2. sun.jdbc.odbc
      JdbcOdbcResultSet.getString
      1. sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(Unknown Source)
      2. sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
      2 frames
    3. org.pentaho.di
      GetDatabaseInfoProgressDialog$1.run
      1. org.pentaho.di.core.database.Database.getViewMap(Database.java:4060)
      2. org.pentaho.di.core.database.Database.getViews(Database.java:4002)
      3. org.pentaho.di.core.database.Database.getViews(Database.java:3997)
      4. org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:371)
      5. org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:67)
      5 frames
    4. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame