org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Date' from database resultset, index 0 [Vertica][JDBC](10140) Error converting value to Timestamp.

Pentaho BI Platform Tracking | Mike Sloper | 4 years ago
  1. 0

    When using a transformation to output to a text file from SQL (Table Input step -> Text File Output step) it fails when there is a field of data type DATE. Example SQL: SELECT CAST('2012-10-05' AS DATE) AS "someDate"; Error Log: 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unexpected error 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Couldn't get row from result set 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to get value 'Date' from database resultset, index 0 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2824) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2796) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2770) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:257) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to get value 'Date' from database resultset, index 0 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1900) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2613) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2816) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : ... 6 more 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Caused by: java.sql.SQLException: [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at com.vertica.utilities.conversion.TypeConverter.toTimestamp(Unknown Source) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at com.vertica.jdbc.SForwardResultSet.getTimestamp(Unknown Source) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1887) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : ... 8 more

    Pentaho BI Platform Tracking | 4 years ago | Mike Sloper
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Date' from database resultset, index 0 [Vertica][JDBC](10140) Error converting value to Timestamp.
  2. 0

    When using a transformation to output to a text file from SQL (Table Input step -> Text File Output step) it fails when there is a field of data type DATE. Example SQL: SELECT CAST('2012-10-05' AS DATE) AS "someDate"; Error Log: 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unexpected error 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Couldn't get row from result set 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to get value 'Date' from database resultset, index 0 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2824) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2796) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2770) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:257) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Unable to get value 'Date' from database resultset, index 0 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1900) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2613) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2816) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : ... 6 more 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Caused by: java.sql.SQLException: [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at com.vertica.utilities.conversion.TypeConverter.toTimestamp(Unknown Source) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at com.vertica.jdbc.SForwardResultSet.getTimestamp(Unknown Source) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1887) 2012/10/05 12:45:48 - Table input 2.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : ... 8 more

    Pentaho BI Platform Tracking | 4 years ago | Mike Sloper
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Date' from database resultset, index 0 [Vertica][JDBC](10140) Error converting value to Timestamp.
  3. 0

    when use a table input and table output with a column defined with date or timestamp get stack trace. Happens with Vertica DB 6.0 and the following vertica jdbc drivers vertica-jdk5-6.0.0-0.jar ,vertica_5.1.6_jdk_5.jar, vertica_5.1.1_jdk_5.jar I will include a simple job along with the ddl for the tables. You can install the sample database Vertica provides in /opt/vertica/examples. This will load the source table for you. My script will create the target table. It also has the source table if you can not load the examples for some reason. does not work.. SELECT date_key ,date , full_date_description , day_of_week , day_number_in_calendar_month , day_number_in_calendar_year , day_number_in_fiscal_month , day_number_in_fiscal_year , last_day_in_week_indicator , last_day_in_month_indicator , calendar_week_number_in_year , calendar_month_name , calendar_month_number_in_year , calendar_year_month , calendar_quarter , calendar_year_quarter , calendar_half_year , calendar_year , holiday_indicator , weekday_indicator , selling_season FROM public.date_dimension does work. SELECT date_key , full_date_description , day_of_week , day_number_in_calendar_month , day_number_in_calendar_year , day_number_in_fiscal_month , day_number_in_fiscal_year , last_day_in_week_indicator , last_day_in_month_indicator , calendar_week_number_in_year , calendar_month_name , calendar_month_number_in_year , calendar_year_month , calendar_quarter , calendar_year_quarter , calendar_half_year , calendar_year , holiday_indicator , weekday_indicator , selling_season FROM public.date_dimension Here is the stack trace: 2012/10/16 14:55:20 - Spoon - Transformation opened. 2012/10/16 14:55:20 - Spoon - Launching transformation [test_edw_lock_bug]... 2012/10/16 14:55:20 - Spoon - Started the transformation execution. 2012/10/16 14:55:20 - Transformation metadata - Natural sort of steps executed in 0 ms (2 time previous steps calculated) 2012/10/16 15:02:03 - Spoon - The transformation has finished!! 2012/10/16 15:15:52 - /Transformation 1 - Dispatching started for transformation [/Transformation 1] 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Unexpected error 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Couldn't get row from result set 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Unable to get value 'Date' from database resultset, index 1 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2758) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2730) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2704) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:257) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Unable to get value 'Date' from database resultset, index 1 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1900) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2613) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2750) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : ... 6 more 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Caused by: java.sql.SQLException: [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at com.vertica.jdbc.SForwardResultSet.getTimestamp(Unknown Source) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1887) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : ... 8 more 2012/10/16 15:15:52 - Table input.0 - Finished reading query, closing connection. 2012/10/16 15:15:52 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2012/10/16 15:15:52 - /Transformation 1 - /Transformation 1 2012/10/16 15:15:52 - /Transformation 1 - /Transformation 1

    Pentaho BI Platform Tracking | 4 years ago | mark warner
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Date' from database resultset, index 1 [Vertica][JDBC](10140) Error converting value to Timestamp.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    when use a table input and table output with a column defined with date or timestamp get stack trace. Happens with Vertica DB 6.0 and the following vertica jdbc drivers vertica-jdk5-6.0.0-0.jar ,vertica_5.1.6_jdk_5.jar, vertica_5.1.1_jdk_5.jar I will include a simple job along with the ddl for the tables. You can install the sample database Vertica provides in /opt/vertica/examples. This will load the source table for you. My script will create the target table. It also has the source table if you can not load the examples for some reason. does not work.. SELECT date_key ,date , full_date_description , day_of_week , day_number_in_calendar_month , day_number_in_calendar_year , day_number_in_fiscal_month , day_number_in_fiscal_year , last_day_in_week_indicator , last_day_in_month_indicator , calendar_week_number_in_year , calendar_month_name , calendar_month_number_in_year , calendar_year_month , calendar_quarter , calendar_year_quarter , calendar_half_year , calendar_year , holiday_indicator , weekday_indicator , selling_season FROM public.date_dimension does work. SELECT date_key , full_date_description , day_of_week , day_number_in_calendar_month , day_number_in_calendar_year , day_number_in_fiscal_month , day_number_in_fiscal_year , last_day_in_week_indicator , last_day_in_month_indicator , calendar_week_number_in_year , calendar_month_name , calendar_month_number_in_year , calendar_year_month , calendar_quarter , calendar_year_quarter , calendar_half_year , calendar_year , holiday_indicator , weekday_indicator , selling_season FROM public.date_dimension Here is the stack trace: 2012/10/16 14:55:20 - Spoon - Transformation opened. 2012/10/16 14:55:20 - Spoon - Launching transformation [test_edw_lock_bug]... 2012/10/16 14:55:20 - Spoon - Started the transformation execution. 2012/10/16 14:55:20 - Transformation metadata - Natural sort of steps executed in 0 ms (2 time previous steps calculated) 2012/10/16 15:02:03 - Spoon - The transformation has finished!! 2012/10/16 15:15:52 - /Transformation 1 - Dispatching started for transformation [/Transformation 1] 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Unexpected error 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Couldn't get row from result set 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Unable to get value 'Date' from database resultset, index 1 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2758) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2730) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2704) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:257) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Unable to get value 'Date' from database resultset, index 1 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1900) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2613) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.Database.getRow(Database.java:2750) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : ... 6 more 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Caused by: java.sql.SQLException: [Vertica][JDBC](10140) Error converting value to Timestamp. 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at com.vertica.jdbc.SForwardResultSet.getTimestamp(Unknown Source) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1887) 2012/10/16 15:15:52 - Table input.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : ... 8 more 2012/10/16 15:15:52 - Table input.0 - Finished reading query, closing connection. 2012/10/16 15:15:52 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2012/10/16 15:15:52 - /Transformation 1 - /Transformation 1 2012/10/16 15:15:52 - /Transformation 1 - /Transformation 1

    Pentaho BI Platform Tracking | 4 years ago | mark warner
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Date' from database resultset, index 1 [Vertica][JDBC](10140) Error converting value to Timestamp.
  6. 0

    tripplite.com | 6 months ago
    java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to bigint.

    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

      [Vertica][JDBC](10140) Error converting value to Timestamp.

      at com.vertica.utilities.conversion.TypeConverter.toTimestamp()
    2. com.vertica.utilities
      TypeConverter.toTimestamp
      1. com.vertica.utilities.conversion.TypeConverter.toTimestamp(Unknown Source)
      1 frame
    3. com.vertica.jdbc
      SForwardResultSet.getTimestamp
      1. com.vertica.jdbc.SForwardResultSet.getTimestamp(Unknown Source)
      1 frame
    4. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:1887)
      2. org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2613)
      3. org.pentaho.di.core.database.Database.getRow(Database.java:2816)
      4. org.pentaho.di.core.database.Database.getRow(Database.java:2796)
      5. org.pentaho.di.core.database.Database.getRow(Database.java:2770)
      6. org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:257)
      7. org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143)
      8. org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      8 frames
    5. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame