java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :be.ibridge.kettle.core.exception.KettleDatabaseException: Unable to get list of rows from ResultSet : High-order nibble of the byte at array offset 11588 is not valid. Byte value: 40

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Cannot access SOME as/400 tables in NATIVE mode.. It won't work even through the 'database explorer'. It will show layout though.. Just looking at error message I suspected that it was erroring out expecting different data type. When I played around with the SQL statement, selecting and deselecting fields to get, I could see it was erroryihng out only when some columns were selected. Those are the errors I get. java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :be.ibridge.kettle.core.exception.KettleDatabaseException: Unable to get list of rows from ResultSet : High-order nibble of the byte at array offset 11588 is not valid. Byte value: 40 at be.ibridge.kettle.core.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:81) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException: Unable to get list of rows from ResultSet : High-order nibble of the byte at array offset 11588 is not valid. Byte value: 40 at be.ibridge.kettle.core.database.Database.getRows(Database.java:4564) at be.ibridge.kettle.core.database.Database.getRows(Database.java:4520) at be.ibridge.kettle.core.database.Database.getFirstRows(Database.java:4591) at be.ibridge.kettle.core.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:73) ... 1 more Caused by: java.lang.NumberFormatException: High-order nibble of the byte at array offset 11588 is not valid. Byte value: 40 at com.ibm.as400.access.AS400PackedDecimal.throwNumberFormatException(AS400PackedDecimal.java:560) at com.ibm.as400.access.AS400ZonedDecimal.throwNumberFormatException(AS400ZonedDecimal.java:471) at com.ibm.as400.access.AS400ZonedDecimal.toObject(AS400ZonedDecimal.java:451) at com.ibm.as400.access.SQLNumeric.convertFromRawBytes(SQLNumeric.java:89) at com.ibm.as400.access.JDServerRow.getSQLData(JDServerRow.java:497) at com.ibm.as400.access.AS400JDBCResultSet.getValue(AS400JDBCResultSet.java:3625) at com.ibm.as400.access.AS400JDBCResultSet.getLong(AS400JDBCResultSet.java:2938) at be.ibridge.kettle.core.database.Database.getRow(Database.java:3088) at be.ibridge.kettle.core.database.Database.getRow(Database.java:3059) at be.ibridge.kettle.core.database.Database.getRows(Database.java:4544) ... 4 more
    via by Maciej Bogucki,
  • Cannot access SOME as/400 tables in NATIVE mode.. It won't work even through the 'database explorer'. It will show layout though.. Just looking at error message I suspected that it was erroring out expecting different data type. When I played around with the SQL statement, selecting and deselecting fields to get, I could see it was erroryihng out only when some columns were selected. Those are the errors I get. java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :be.ibridge.kettle.core.exception.KettleDatabaseException: Unable to get list of rows from ResultSet : High-order nibble of the byte at array offset 11588 is not valid. Byte value: 40 at be.ibridge.kettle.core.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:81) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException: Unable to get list of rows from ResultSet : High-order nibble of the byte at array offset 11588 is not valid. Byte value: 40 at be.ibridge.kettle.core.database.Database.getRows(Database.java:4564) at be.ibridge.kettle.core.database.Database.getRows(Database.java:4520) at be.ibridge.kettle.core.database.Database.getFirstRows(Database.java:4591) at be.ibridge.kettle.core.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:73) ... 1 more Caused by: java.lang.NumberFormatException: High-order nibble of the byte at array offset 11588 is not valid. Byte value: 40 at com.ibm.as400.access.AS400PackedDecimal.throwNumberFormatException(AS400PackedDecimal.java:560) at com.ibm.as400.access.AS400ZonedDecimal.throwNumberFormatException(AS400ZonedDecimal.java:471) at com.ibm.as400.access.AS400ZonedDecimal.toObject(AS400ZonedDecimal.java:451) at com.ibm.as400.access.SQLNumeric.convertFromRawBytes(SQLNumeric.java:89) at com.ibm.as400.access.JDServerRow.getSQLData(JDServerRow.java:497) at com.ibm.as400.access.AS400JDBCResultSet.getValue(AS400JDBCResultSet.java:3625) at com.ibm.as400.access.AS400JDBCResultSet.getLong(AS400JDBCResultSet.java:2938) at be.ibridge.kettle.core.database.Database.getRow(Database.java:3088) at be.ibridge.kettle.core.database.Database.getRow(Database.java:3059) at be.ibridge.kettle.core.database.Database.getRows(Database.java:4544) ... 4 more
    via by Maciej Bogucki,
    • java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :be.ibridge.kettle.core.exception.KettleDatabaseException: Unable to get list of rows from ResultSet : High-order nibble of the byte at array offset 11588 is not valid. Byte value: 40 at be.ibridge.kettle.core.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:81) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException: Unable to get list of rows from ResultSet : High-order nibble of the byte at array offset 11588 is not valid. Byte value: 40 at be.ibridge.kettle.core.database.Database.getRows(Database.java:4564) at be.ibridge.kettle.core.database.Database.getRows(Database.java:4520) at be.ibridge.kettle.core.database.Database.getFirstRows(Database.java:4591) at be.ibridge.kettle.core.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:73) ... 1 more Caused by: java.lang.NumberFormatException: High-order nibble of the byte at array offset 11588 is not valid. Byte value: 40 at com.ibm.as400.access.AS400PackedDecimal.throwNumberFormatException(AS400PackedDecimal.java:560) at com.ibm.as400.access.AS400ZonedDecimal.throwNumberFormatException(AS400ZonedDecimal.java:471) at com.ibm.as400.access.AS400ZonedDecimal.toObject(AS400ZonedDecimal.java:451) at com.ibm.as400.access.SQLNumeric.convertFromRawBytes(SQLNumeric.java:89) at com.ibm.as400.access.JDServerRow.getSQLData(JDServerRow.java:497) at com.ibm.as400.access.AS400JDBCResultSet.getValue(AS400JDBCResultSet.java:3625) at com.ibm.as400.access.AS400JDBCResultSet.getLong(AS400JDBCResultSet.java:2938) at be.ibridge.kettle.core.database.Database.getRow(Database.java:3088) at be.ibridge.kettle.core.database.Database.getRow(Database.java:3059) at be.ibridge.kettle.core.database.Database.getRows(Database.java:4544) ... 4 more
    No Bugmate found.