Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Explore Connection In Sybase - Kettle 3.0.0 GA

  1. #1
    Join Date
    Jul 2007
    Posts
    6

    Default Explore Connection In Sybase - Kettle 3.0.0 GA

    Hi All,

    I've a problem with ODBC connection on SybaseIQ (the same with Sybase) when I want to explore Shema's, tables and View on the DB.


    I receive this message :
    Unable to retrieve database information because of an error

    Error getting views from schema [null]

    Column not found
    (see detail here under)

    But when I :
    - Test the connection ==> OK
    - Run a query (Input Table for exemple) ==> OK

    This problem occurs only with version 3.0.0.

    Of course, as I work in a large organisation, I can not change/load a newer version of ODBC drivers.

    Can somebody help me please.

    Thanks



    DETAIL
    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:67)
    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:281)
    at org.pentaho.di.ui.core.database.dialog.GetDatabaseInfoProgressDialog$1.run(GetDatabaseInfoProgressDialog.java:63)
    ... 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.getViews(Database.java:4000)
    at org.pentaho.di.core.database.Database.getViews(Database.java:3969)
    at org.pentaho.di.core.database.DatabaseMetaInformation.getData(DatabaseMetaInformation.java:267)
    ... 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.getViews(Database.java:3987)
    ... 4 more

  2. #2

    Default

    Please post if you have found a solution for this issue

    ~JC
    www.di-solution.com
    Last edited by johnson.cyriac; 07-11-2010 at 04:28 AM.

  3. #3

    Default

    Hi All,

    I got a workaround for this issue.

    Soln:
    Add a Generate Rows with the all the column you need from the source table and Join the actual source with Generate Rows step using an Append Stream Step

    Please see the Transformation attached for your reference

    ~JC
    www.di-solution.com
    Attached Files Attached Files

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.