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.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert 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.

Solutions on the web

via Pentaho BI Platform Tracking by Matt Tucker, 1 year ago
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.
via Pentaho BI Platform Tracking by Matt Tucker, 1 year ago
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.
via Pentaho BI Platform Tracking by mark warner, 1 year ago
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[].
via Pentaho BI Platform Tracking by mark warner, 1 year ago
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.
via Pentaho BI Platform Tracking by Mike Sloper, 1 year ago
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.
via Pentaho BI Platform Tracking by Geoffrey Cleaves, 11 months ago
2015/03/12 11:10:17 - entrance hadoop input.0 - Couldn't get row from result set 2015/03/12 11:10:17 - entrance hadoop input.0 - 2015/03/12 11:10:17 - entrance hadoop input.0 - Unable to get value 'Date' from database resultset, index 1 2015/03/12
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 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)
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)
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)

Users with the same issue

Once, 1 month ago
6 times, 3 months ago
4 times, 4 months ago
Samebug visitor profile picture
Unknown user
Once, 9 months ago
Once, 10 months ago
94 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.