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 | 10 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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 | 10 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 | 10 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