org.pentaho.di.core.exception.KettleDatabaseException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

If you're not using yet, consider using the SQLServerDataSource to set your server configurations. Also, check if the server is accepting TCP/IP connections and if there's no firewall blocking the connections.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • It is not possible to return binary data from a Microsoft SQL Server table. Instead, an error is thrown that the Binary value could not be converted to a BLOB object. This works fine for a jTDS-based connection (the non-"Native" database type), but it fails for Native (Microsoft-provided JDBC driver) connections. {noformat} 2015/11/11 11:24:47 - Table input.0 - ERROR (version 5.4.0.3-143, build 1 from 2015-08-06 14.29.30 by buildguy) : Unexpected error 2015/11/11 11:24:47 - Table input.0 - ERROR (version 5.4.0.3-143, build 1 from 2015-08-06 14.29.30 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2015/11/11 11:24:47 - Table input.0 - Couldn't get row from result set 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - Unable to get value 'Binary' from database resultset, index 9 2015/11/11 11:24:47 - Table input.0 - The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2414) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2384) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2362) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/11/11 11:24:47 - Table input.0 - at java.lang.Thread.run(Thread.java:745) 2015/11/11 11:24:47 - Table input.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2015/11/11 11:24:47 - Table input.0 - Unable to get value 'Binary' from database resultset, index 9 2015/11/11 11:24:47 - Table input.0 - The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4708) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2853) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2406) 2015/11/11 11:24:47 - Table input.0 - ... 6 more 2015/11/11 11:24:47 - Table input.0 - Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1117) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:2481) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:193) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:132) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2082) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2067) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getBlob(SQLServerResultSet.java:2571) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4677) 2015/11/11 11:24:47 - Table input.0 - ... 9 more {noformat} According to the [Microsoft SQL Server JDBC driver reference|https://msdn.microsoft.com/en-us/library/ms378680(v=sql.110).aspx], the majority of binary data types are not supported with the use of the JDBC getBlob() method, even though we say it's supported in the DatabaseMeta class.
    via by Matt Tucker,
  • It is not possible to return binary data from a Microsoft SQL Server table. Instead, an error is thrown that the Binary value could not be converted to a BLOB object. This works fine for a jTDS-based connection (the non-"Native" database type), but it fails for Native (Microsoft-provided JDBC driver) connections. {noformat} 2015/11/11 11:24:47 - Table input.0 - ERROR (version 5.4.0.3-143, build 1 from 2015-08-06 14.29.30 by buildguy) : Unexpected error 2015/11/11 11:24:47 - Table input.0 - ERROR (version 5.4.0.3-143, build 1 from 2015-08-06 14.29.30 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 2015/11/11 11:24:47 - Table input.0 - Couldn't get row from result set 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - Unable to get value 'Binary' from database resultset, index 9 2015/11/11 11:24:47 - Table input.0 - The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2414) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2384) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2362) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/11/11 11:24:47 - Table input.0 - at java.lang.Thread.run(Thread.java:745) 2015/11/11 11:24:47 - Table input.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2015/11/11 11:24:47 - Table input.0 - Unable to get value 'Binary' from database resultset, index 9 2015/11/11 11:24:47 - Table input.0 - The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4708) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2853) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2406) 2015/11/11 11:24:47 - Table input.0 - ... 6 more 2015/11/11 11:24:47 - Table input.0 - Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from binary to BLOB is unsupported. 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1117) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:2481) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:193) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:132) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2082) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2067) 2015/11/11 11:24:47 - Table input.0 - at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getBlob(SQLServerResultSet.java:2571) 2015/11/11 11:24:47 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4677) 2015/11/11 11:24:47 - Table input.0 - ... 9 more {noformat} According to the [Microsoft SQL Server JDBC driver reference|https://msdn.microsoft.com/en-us/library/ms378680(v=sql.110).aspx], the majority of binary data types are not supported with the use of the JDBC getBlob() method, even though we say it's supported in the DatabaseMeta class.
    via by Matt Tucker,
  • Java y Sql Server
    via by Unknown author,
  • Java SqlServer 2k5 Coonnection Error
    via Stack Overflow by oneProgrammer
    ,
  • SQL Server jdbc connection
    via Stack Overflow by yatinbc
    ,
  • Does JDBI accept UUID parameters?
    via Stack Overflow by Fernando Correia
    ,
    • org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get row from result set Unable to get value 'Binary' from database resultset, index 9 The conversion from binary to BLOB is unsupported. at org.pentaho.di.core.database.Database.getRow(Database.java:2414) at org.pentaho.di.core.database.Database.getRow(Database.java:2384) at org.pentaho.di.core.database.Database.getRow(Database.java:2362) at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:247) at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Thread.java:745) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Unable to get value 'Binary' from database resultset, index 9 The conversion from binary to BLOB is unsupported. at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4708) at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086) at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2853) at org.pentaho.di.core.database.Database.getRow(Database.java:2406) ... 6 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from binary to BLOB is unsupported. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) at com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1117) at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:2481) at com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:193) at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:132) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2082) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2067) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getBlob(SQLServerResultSet.java:2571) at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4677) ... 9 more

    Users with the same issue

    odd
    4 times, last one,
    SteVio1989
    2 times, last one,
    Andreas Häber
    7325 times, last one,
    Unknown visitor1 times, last one,
    musketyr
    1 times, last one,
    94 more bugmates