org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'String(25)<binary-string>' from database resultset, index 1 [Vertica][JDBC](10400) Invalid type for data - column: 2, type: byte[].

Pentaho BI Platform Tracking | mark warner | 2 years ago
  1. 0

    Trying to use lazy conversion on Table input for Vertica as a source. Get following stack trace when preview or run transformation. {noformat} 2014/10/08 07:56:54 - Table input.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2014/10/08 07:56:54 - Table input.0 - Couldn't get row from result set 2014/10/08 07:56:54 - Table input.0 - 2014/10/08 07:56:54 - Table input.0 - Unable to get value 'String(25)<binary-string>' from database resultset, index 1 2014/10/08 07:56:54 - Table input.0 - [Vertica][JDBC](10400) Invalid type for data - column: 2, type: byte[]. 2014/10/08 07:56:54 - Table input.0 - 2014/10/08 07:56:54 - Table input.0 - 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2398) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2368) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2344) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2014/10/08 07:56:54 - Table input.0 - at java.lang.Thread.run(Thread.java:745) 2014/10/08 07:56:54 - Table input.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/10/08 07:56:54 - Table input.0 - Unable to get value 'String(25)<binary-string>' from database resultset, index 1 2014/10/08 07:56:54 - Table input.0 - [Vertica][JDBC](10400) Invalid type for data - column: 2, type: byte[]. 2014/10/08 07:56:54 - Table input.0 - 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4743) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.Vertica5DatabaseMeta.getValueFromResultSet(Vertica5DatabaseMeta.java:91) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2852) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2390) 2014/10/08 07:56:54 - Table input.0 - ... 6 more 2014/10/08 07:56:54 - Table input.0 - Caused by: java.sql.SQLDataException: [Vertica][JDBC](10400) Invalid type for data - column: 2, type: byte[]. 2014/10/08 07:56:54 - Table input.0 - at com.vertica.exceptions.ExceptionConverter.toSQLException(Unknown Source) 2014/10/08 07:56:54 - Table input.0 - at com.vertica.jdbc.common.SForwardResultSet.getBytes(Unknown Source) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4705) 2014/10/08 07:56:54 - Table input.0 - ... 10 more 2014/10/08 07:56:54 - Table input.0 - Finished reading query, closing connection. 2014/10/08 07:56:55 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2014/10/08 07:56:55 - customer_to_customer_vertica_bulk - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Errors detected! 2014/10/08 07:56:55 - Spoon - The transformation has finished!! 2014/10/08 07:56:55 - customer_to_customer_vertica_bulk - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Errors detected! 2014/10/08 07:56:55 - customer_to_customer_vertica_bulk - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Errors detected! 2014/10/08 07:56:55 - customer_to_customer_vertica_bulk - Transformation detected one or more steps with errors. 2014/10/08 07:56:55 - customer_to_customer_vertica_bulk - Transformation is killing the other steps! {noformat}

    Pentaho BI Platform Tracking | 2 years ago | mark warner
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'String(25)<binary-string>' from database resultset, index 1 [Vertica][JDBC](10400) Invalid type for data - column: 2, type: byte[].
  2. 0

    Trying to use lazy conversion on Table input for Vertica as a source. Get following stack trace when preview or run transformation. {noformat} 2014/10/08 07:56:54 - Table input.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2014/10/08 07:56:54 - Table input.0 - Couldn't get row from result set 2014/10/08 07:56:54 - Table input.0 - 2014/10/08 07:56:54 - Table input.0 - Unable to get value 'String(25)<binary-string>' from database resultset, index 1 2014/10/08 07:56:54 - Table input.0 - [Vertica][JDBC](10400) Invalid type for data - column: 2, type: byte[]. 2014/10/08 07:56:54 - Table input.0 - 2014/10/08 07:56:54 - Table input.0 - 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2398) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2368) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2344) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2014/10/08 07:56:54 - Table input.0 - at java.lang.Thread.run(Thread.java:745) 2014/10/08 07:56:54 - Table input.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/10/08 07:56:54 - Table input.0 - Unable to get value 'String(25)<binary-string>' from database resultset, index 1 2014/10/08 07:56:54 - Table input.0 - [Vertica][JDBC](10400) Invalid type for data - column: 2, type: byte[]. 2014/10/08 07:56:54 - Table input.0 - 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4743) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.Vertica5DatabaseMeta.getValueFromResultSet(Vertica5DatabaseMeta.java:91) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2852) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2390) 2014/10/08 07:56:54 - Table input.0 - ... 6 more 2014/10/08 07:56:54 - Table input.0 - Caused by: java.sql.SQLDataException: [Vertica][JDBC](10400) Invalid type for data - column: 2, type: byte[]. 2014/10/08 07:56:54 - Table input.0 - at com.vertica.exceptions.ExceptionConverter.toSQLException(Unknown Source) 2014/10/08 07:56:54 - Table input.0 - at com.vertica.jdbc.common.SForwardResultSet.getBytes(Unknown Source) 2014/10/08 07:56:54 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4705) 2014/10/08 07:56:54 - Table input.0 - ... 10 more 2014/10/08 07:56:54 - Table input.0 - Finished reading query, closing connection. 2014/10/08 07:56:55 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2014/10/08 07:56:55 - customer_to_customer_vertica_bulk - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Errors detected! 2014/10/08 07:56:55 - Spoon - The transformation has finished!! 2014/10/08 07:56:55 - customer_to_customer_vertica_bulk - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Errors detected! 2014/10/08 07:56:55 - customer_to_customer_vertica_bulk - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Errors detected! 2014/10/08 07:56:55 - customer_to_customer_vertica_bulk - Transformation detected one or more steps with errors. 2014/10/08 07:56:55 - customer_to_customer_vertica_bulk - Transformation is killing the other steps! {noformat}

    Pentaho BI Platform Tracking | 2 years ago | mark warner
    org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'String(25)<binary-string>' from database resultset, index 1 [Vertica][JDBC](10400) Invalid type for data - column: 2, type: byte[].
  3. 0

    EclipseLink/Examples/Distributed - Eclipsepedia

    eclipse.org | 3 months ago
    java.sql.SQLDataException: The resulting value is outside the range for the data type BIGINT. Error Code: -1 Call: UPDATE PARAMETERS SET MAXPATH = ?, MAXVALUE = ?, NEXTNUMBERTOSEARCH = ?, VERSION = ? WHERE ((ID = ?) AND (VERSION = ?)) bind => [958, 85563713241241454980420, 1980976057694913983, 2, 451, 1] Query: UpdateObjectQuery(org.eclipse.persistence.example.distributed.collatz.model.Parameters@451( id: 451))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    EclipseLink/Examples/Distributed - Eclipsepedia

    eclipse.org | 3 months ago
    org.hibernate.exception.DataException: could not update: [org.dataparallel.collatz.business.Parameters#32768]
  6. 0

    HyperSQL Database Engine (HSQLDB) / Discussion / Open Discussion:invalid character value for cast exception

    sourceforge.net | 6 months ago
    java.sql.SQLDataException: data exception: invalid character value for cast

    1 unregistered visitors
    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.SQLDataException

      [Vertica][JDBC](10400) Invalid type for data - column: 2, type: byte[].

      at com.vertica.exceptions.ExceptionConverter.toSQLException()
    2. com.vertica.exceptions
      ExceptionConverter.toSQLException
      1. com.vertica.exceptions.ExceptionConverter.toSQLException(Unknown Source)
      1 frame
    3. com.vertica.jdbc
      SForwardResultSet.getBytes
      1. com.vertica.jdbc.common.SForwardResultSet.getBytes(Unknown Source)
      1 frame
    4. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4705)
      2. org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086)
      3. org.pentaho.di.core.database.Vertica5DatabaseMeta.getValueFromResultSet(Vertica5DatabaseMeta.java:91)
      4. org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2852)
      5. org.pentaho.di.core.database.Database.getRow(Database.java:2390)
      6. org.pentaho.di.core.database.Database.getRow(Database.java:2368)
      7. org.pentaho.di.core.database.Database.getRow(Database.java:2344)
      8. org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247)
      9. org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138)
      10. org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      10 frames
    5. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame