Pentaho

 View Only
  • 1.  plugin issue

    Posted 07-05-2022 14:01
      |   view attached
    Hi, I have specific flows with me that I need to update. Before it, I install the snowflake plugin in Pentaho.  i started getting one error
    2022/06/23 20:35:38 - Table input.0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
    2022/06/23 20:35:38 - Table input.0 - Couldn't get row from result set
    2022/06/23 20:35:38 - Table input.0 -  at java.lang.Thread.run (null:-1)
    2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.trans.step.RunThread.run (RunThread.java:62)
    2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.trans.steps.tableinput.TableInput.processRow (TableInput.java:143)
    2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery (TableInput.java:265)
    2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.database.Database.getRow (Database.java:2712)
    2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.database.Database.getRow (Database.java:2734)
    2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.database.Database.getRow (Database.java:2756)
    2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet (DatabaseMeta.java:3030)
    2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet (BaseDatabaseMeta.java:2138)
    2022/06/23 20:35:38 - Table input.0 -  at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet (ValueMetaBase.java:5309)
    2022/06/23 20:35:38 - Table input.0 -  at net.snowflake.client.jdbc.SnowflakeBaseResultSet.getTimestamp (SnowflakeBaseResultSet.java:302)
    2022/06/23 20:35:38 - Table input.0 -  at net.snowflake.client.jdbc.SnowflakeResultSetV1.getTimestamp (SnowflakeResultSetV1.java:236)
    2022/06/23 20:35:38 - Table input.0 -  at net.snowflake.client.core.SFBaseResultSet.getTimestamp (SFBaseResultSet.java:522)
    2022/06/23 20:35:38 - Table input.0 - 
    2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.Database.getRow(Database.java:2764)
    2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.Database.getRow(Database.java:2734)
    2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.Database.getRow(Database.java:2712)
    2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:265)
    2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143)
    2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
    2022/06/23 20:35:38 - Table input.0 -   at java.lang.Thread.run(Unknown Source)
    2022/06/23 20:35:38 - Table input.0 - Caused by: java.lang.NullPointerException
    2022/06/23 20:35:38 - Table input.0 -   at net.snowflake.client.core.SFBaseResultSet.getTimestamp(SFBaseResultSet.java:522)
    2022/06/23 20:35:38 - Table input.0 -   at net.snowflake.client.jdbc.SnowflakeResultSetV1.getTimestamp(SnowflakeResultSetV1.java:236)
    2022/06/23 20:35:38 - Table input.0 -   at net.snowflake.client.jdbc.SnowflakeBaseResultSet.getTimestamp(SnowflakeBaseResultSet.java:302)
    2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:5309)
    2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2138)
    2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:3030)
    2022/06/23 20:35:38 - Table input.0 -   at org.pentaho.di.core.database.Database.getRow(Database.java:2756)
    2022/06/23 20:35:38 - Table input.0 -   ... 6 more

    This error is coming in table input step where i have used sql statement as SELECT * FROM TABLENAME.

    kindly provide the solution.



    ------------------------------
    SHIVAM KUMAR
    Systems Engineer
    DECIMAL POINT ANALYTICS LIMITED
    ------------------------------


  • 2.  RE: plugin issue

    Posted 07-06-2022 19:23
    Hi

    From what I can see in the code, the jdbc connector is not working as expected.   It appears to be using a really old version of the snowflake jdbc code .  Maybe try converting the database connect to a Generic one and specify the driver name stuff instead

    ------------------------------
    Andrew Cave
    Systems Engineer
    BizCubed Pty Ltd
    Australia
    ------------------------------



  • 3.  RE: plugin issue

    Posted 07-30-2022 16:23
    Shivam
    Are you still experiencing this issue? Would you be able to test with 9.3 as we have upgraded the snowflake jdbc driver to their latest?

    ------------------------------
    Carlos Lopez
    Application Architecture Engineering - Expert
    Hitachi Vantara
    ------------------------------