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
  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
  3. 0

    Java parseInt NumberFormatException

    Stack Overflow | 3 years ago | Snay
    java.lang.NumberFormatException: For input string: "1" String value from array is:1 This is not a number:1END For input string: "1"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [1.07 beta 7] Instantly crashes

    GitHub | 2 years ago | keithsimister
    java.lang.NumberFormatException: Invalid float: "nan" > E/AndroidRuntime( 2838): at > android.app.ActivityThread.performResumeActivity(ActivityThread.java:2444) > E/AndroidRuntime( 2838): at > android.app.ActivityThread.handleResumeActivity(ActivityThread.java:2472) > E/AndroidRuntime( 2838): at > android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1986) > E/AndroidRuntime( 2838): at > android.app.ActivityThread.access$600(ActivityThread.java:123) > E/AndroidRuntime( 2838): at > android.app.ActivityThread$H.handleMessage(ActivityThread.java:1147) > E/AndroidRuntime( 2838): at > android.os.Handler.dispatchMessage(Handler.java:99) > E/AndroidRuntime( 2838): at android.os.Looper.loop(Looper.java:137) > E/AndroidRuntime( 2838): at > android.app.ActivityThread.main(ActivityThread.java:4424) > E/AndroidRuntime( 2838): at java.lang.reflect.Method.invokeNative(Native > Method) > E/AndroidRuntime( 2838): at > java.lang.reflect.Method.invoke(Method.java:511) > E/AndroidRuntime( 2838): at > com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784) > E/AndroidRuntime( 2838): at > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551) > E/AndroidRuntime( 2838): at dalvik.system.NativeStart.main(Native Method) > E/AndroidRuntime( 2838): Caused by: java.lang.NumberFormatException: > Invalid float: "nan" > E/AndroidRuntime( 2838): at > java.lang.StringToReal.invalidReal(StringToReal.java:63) > E/AndroidRuntime( 2838): at > java.lang.StringToReal.parseFloat(StringToReal.java:310) > E/AndroidRuntime( 2838): at java.lang.Float.parseFloat(Float.java:300) > E/AndroidRuntime( 2838): at > org.a0z.mpd.MPDStatus.updateStatus(MPDStatus.java:436) > E/AndroidRuntime( 2838): at org.a0z.mpd.MPD.getStatus(MPD.java:1134) > E/AndroidRuntime( 2838): at > com.namelessdev.mpdroid.fragments.NowPlayingFragment.forceStatusUpdate(NowPlayingFragment.java:213) > E/AndroidRuntime( 2838): at > com.namelessdev.mpdroid.fragments.NowPlayingFragment.onResume(NowPlayingFragment.java:543) > E/AndroidRuntime( 2838): at > android.support.v4.app.Fragment.performResume(Fragment.java:1547) > E/AndroidRuntime( 2838): at > android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:978) > E/AndroidRuntime( 2838): at > android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1121) > E/AndroidRuntime( 2838): at > android.support.v4.app.FragmentManagerImpl.moveToState(FragmentManager.java:1103) > E/AndroidRuntime( 2838): at > android.support.v4.app.FragmentManagerImpl.dispatchResume(FragmentManager.java:1911) > E/AndroidRuntime( 2838): at > android.support.v4.app.FragmentActivity.onResumeFragments(FragmentActivity.java:467) > E/AndroidRuntime( 2838): at > android.support.v4.app.FragmentActivity.onPostResume(FragmentActivity.java:456) > E/AndroidRuntime( 2838): at > android.app.Activity.performResume(Activity.java:4579) > E/AndroidRuntime( 2838): at > android.app.ActivityThread.performResumeActivity(ActivityThread.java:2434) > E/AndroidRuntime( 2838): ... 12 more > W/dalvikvm( 2838): threadid=12: thread exiting with uncaught exception > (group=0x409fb1f8) > I/Process ( 2838): Sending signal. PID: 2838 SIG: 9 > W/ActivityManager( 159): Force finishing activity > com.namelessdev.mpdroid/.MainMenuActivity > I/Process ( 159): Sending signal. PID: 2838 SIG: 3 > D/ViewRootImpl( 159): pckname = android > I/ActivityManager( 159): Process com.namelessdev.mpdroid (pid 2838) has > died. > I/DownloadManager( 275): deleting > /data/data/com.android.providers.downloads/cache/downloadfile.zip > W/InputManagerService( 159): Window already focused, ignoring focus gain > of: com.android.internal.view.IInputMethodClient$Stub$Proxy@410b9a00 > V/TabletStatusBar( 224): setLightsOn(true) > D/audio_hw_primary( 87): start_output_stream: card:0, port:0, rate:44100 > V/TabletStatusBar( 224): setLightsOn(true) > D/dalvikvm( 224): GC_CONCURRENT freed 179K, 47% free 8127K/15175K, paused > 2ms+5ms > D/dalvikvm( 1219): GC_CONCURRENT freed 357K, 11% free 7635K/8519K, paused > 6ms+23ms > I/DownloadManager( 275): Initiating request for download 212 > D/dalvikvm( 275): GC_CONCURRENT freed 374K, 10% free 6955K/7687K, paused > 2ms+4ms > D/ViewRootImpl( 2691): pckname = org.jtb.alogcat > D/OpenGLRenderer( 326): Flushing caches (mode 1) > D/OpenGLRenderer( 326): Flushing caches (mode 0) > D/OpenGLRenderer( 224): Flushing caches (mode 0) > D/dalvikvm( 159): GC_CONCURRENT freed 986K, 29% free 11652K/16391K, paused > 4ms+8ms > I/DownloadManager( 275): deleting > /data/data/com.android.providers.downloads/cache/downloadfile.jpeg > I/DownloadManager( 275): Initiating request for download 213 > D/dalvikvm( 275): GC_CONCURRENT freed 389K, 10% free 6979K/7687K, paused > 3ms+4ms > D/WakeOnLan( 990): Updating Widgets. > D/dalvikvm( 159): GC_EXPLICIT freed 559K, 30% free 11589K/16391K, paused > 5ms+11ms > D/audio_hw_primary( 87): start_output_stream: card:0, port:0, rate:44100 > D/dalvikvm( 275): GC_CONCURRENT freed 518K, 11% free 6862K/7687K, paused > 3ms+4ms > D/dalvikvm( 2691): GC_CONCURRENT freed 486K, 18% free 7030K/8519K, paused > 3ms+9ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 46K, 16% free 7160K/8519K, paused > 46ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed I/dalvikvm-heap( 2691): Grow heap > (frag case) to 7.162MB for 44816-byte allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 16% free 7292K/8583K, paused 46ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 16% free 7292K/8583K, paused 35ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.205MB for 44816-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed D/dalvikvm( 2691): GC_FOR_ALLOC > freed 0K, 16% free 7336K/8647K, paused 36ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.282MB for 80016-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed D/dalvikvm( 2691): GC_FOR_ALLOC > freed I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.410MB for > 44816-byte allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed D/dalvikvm( 2691): GC_FOR_ALLOC > freed 0K, 15% free 7546K/8839K, paused 41ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.453MB for 44816-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed D/dalvikvm( 2691): GC_FOR_ALLOC > freed 0K, 15% free 7633K/8903K, paused 25ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.539MB for 44816-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed D/dalvikvm( 2691): GC_FOR_ALLOC > freed 0K, 15% free 7677K/8967K, paused 33ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.582MB for 44816-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 15% free 7721K/9031K, paused 34ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 15% free 7765K/9031K, paused 30ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.667MB for 44816-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 15% free 7809K/9095K, paused 34ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 15% free 7809K/9095K, paused 34ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.710MB for 44816-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 15% free 7853K/9159K, paused 33ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 14% free 7897K/9159K, paused 33ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.795MB for 44816-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 14% free 7941K/9223K, paused 27ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 14% free 7941K/9223K, paused 27ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.838MB for 44816-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 15% free 7985K/9287K, paused 46ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 14% free 8029K/9287K, paused 47ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.924MB for 44816-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 14% free 8073K/9351K, paused 36ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 0K, 14% free 8073K/9351K, paused 33ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 7.967MB for 44816-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed D/dalvikvm( 2691): GC_FOR_ALLOC > freed 79K, 15% free 8097K/9415K, paused 22ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed I/dalvikvm-heap( 2691): Grow heap > (frag case) to 8.037MB for 44816-byte allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed D/dalvikvm( 2691): GC_FOR_ALLOC > freed 49K, 15% free 8146K/9479K, paused 34ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 50K, 14% free 8177K/9479K, paused > 36ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 8.102MB for 80016-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed 4K, 15% free 8250K/9607K, paused 27ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 44K, 15% free 8208K/9607K, paused > 33ms > I/dalvikvm-heap( 2691): Grow heap (frag case) to 8.133MB for 80016-byte > allocation > D/dalvikvm( 2691): GC_FOR_ALLOC freed D/dalvikvm( 159): GC_CONCURRENT > freed 1168K, 30% free 11599K/16391K, paused 3ms+9ms > D/dalvikvm( 275): GC_EXPLICIT freed 372K, 11% free 6866K/7687K, paused > 3ms+4ms > D/WakeOnLan( 990): Updating Widgets. > D/dalvikvm( 2691): GC_FOR_ALLOC freed 389K, 17% free 8154K/9735K, paused > 38ms > I/DownloadManager( 275): deleting > /data/data/com.android.providers.downloads/cache/downloadfile.jpeg > I/DownloadManager( 275): Initiating request for download 214 > D/dalvikvm( 275): GC_CONCURRENT freed 362K, 10% free 6941K/7687K, paused > 2ms+4ms > I/WindowManager( 159): MediaPlayer.is not PlayingVideo > D/dalvikvm( 275): GC_CONCURRENT freed 439K, 11% free 6886K/7687K, paused > 2ms+3ms > D/dalvikvm( 159): GC_CONCURRENT freed 1187K, 30% free 11565K/16391K, > paused 4ms+8ms > D/dalvikvm( 2691): GC_FOR_ALLOC freed 297K, 16% free 8224K/9735K, paused > 40ms > D/audio_hw_primary( 87): start_output_stream: card:0, port:0, rate:44100 > I/ActivityManager( 159): START {act=android.intent.action.CHOOSER > cmp=android/com.android.internal.app.ChooserActivity (has extras)} from pid > 2691 > I/Process ( 159): Sending signal. PID: 2691 SIG: 3 threadid=3: reacting to signal 3 > W/dalvikvm( 2691): threadid=3: spin on suspend #1 > <https://github.com/abarisain/dmix/issues/1> threadid=1 (pcf=0) > W/dalvikvm( 2691): threadid=3: spin on suspend #2 > <https://github.com/abarisain/dmix/issues/2> threadid=1 (pcf=0) "Signal Catcher" daemon prio=5 tid=3 RUNNABLE | group="system" sCount=0 dsCount=0 obj=0x41051080 > self=0x3fd308 | sysTid=2695 nice=0 sched=0/0 cgrp=[no-cpu-subsys] > handle=5238928 | schedstat=( 28192448 107071149 49 ) utm=2 stm=0 core=0
  6. 0

    Support DF similar field-map functions in tnt4j

    GitHub | 2 months ago | igorkry
    java.text.ParseException: Failed to process activity data at position 0

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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