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

Pentaho BI Platform Tracking | Maciej Bogucki | 9 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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

    Pentaho BI Platform Tracking | 9 years ago | 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
  2. 0

    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

    Pentaho BI Platform Tracking | 9 years ago | 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

    Root Cause Analysis

    1. 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()
    2. JT400
      AS400JDBCResultSet.getLong
      1. com.ibm.as400.access.AS400PackedDecimal.throwNumberFormatException(AS400PackedDecimal.java:560)
      2. com.ibm.as400.access.AS400ZonedDecimal.throwNumberFormatException(AS400ZonedDecimal.java:471)
      3. com.ibm.as400.access.AS400ZonedDecimal.toObject(AS400ZonedDecimal.java:451)
      4. com.ibm.as400.access.SQLNumeric.convertFromRawBytes(SQLNumeric.java:89)
      5. com.ibm.as400.access.JDServerRow.getSQLData(JDServerRow.java:497)
      6. com.ibm.as400.access.AS400JDBCResultSet.getValue(AS400JDBCResultSet.java:3625)
      7. com.ibm.as400.access.AS400JDBCResultSet.getLong(AS400JDBCResultSet.java:2938)
      7 frames
    3. be.ibridge.kettle
      GetPreviewTableProgressDialog$1.run
      1. be.ibridge.kettle.core.database.Database.getRow(Database.java:3088)
      2. be.ibridge.kettle.core.database.Database.getRow(Database.java:3059)
      3. be.ibridge.kettle.core.database.Database.getRows(Database.java:4544)
      4. be.ibridge.kettle.core.database.Database.getRows(Database.java:4520)
      5. be.ibridge.kettle.core.database.Database.getFirstRows(Database.java:4591)
      6. be.ibridge.kettle.core.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:73)
      6 frames
    4. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame