java.lang.ArrayIndexOutOfBoundsException: 5

Pentaho BI Platform Tracking | Phillip Cole | 7 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

    TO REPRODUCE 1. Open kettle with transformation dim_lookup_test.ktr. 2. Ensure CSV File input step is going to read from data1.txt 3. Create SQL tables and datasources as required (see postgres_tabledef.sql) 4. Run transformation 5. Notice four records are correctly created in dim_lookup_test table 6. Edit CSV file input step and change to read from data2.txt 7. Run transformation again EXPECTED RESULT SCD Type II records added to dim_lookup_test table ACTUAL RESULT The following error occurs 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : Unexpected error : 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : java.lang.ArrayIndexOutOfBoundsException: 5 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dimInsert(DimensionLookup.java:1071) 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:601) 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:202) 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1594) 2009/10/06 12:24:02 - Dimension lookup/update.0 - Finished processing (I=2, O=0, R=2, W=1, U=0, E=1) 2009/10/06 12:24:02 - Spoon - The transformation has finished!! 2009/10/06 12:24:02 - dim_lookup_test - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : Errors detected! 2009/10/06 12:24:02 - dim_lookup_test - Transformation detected one or more steps with errors. 2009/10/06 12:24:02 - dim_lookup_test - Transformation is killing the other steps!

    Pentaho BI Platform Tracking | 7 years ago | Phillip Cole
    java.lang.ArrayIndexOutOfBoundsException: 5
  2. 0

    TO REPRODUCE 1. Open kettle with transformation dim_lookup_test.ktr. 2. Ensure CSV File input step is going to read from data1.txt 3. Create SQL tables and datasources as required (see postgres_tabledef.sql) 4. Run transformation 5. Notice four records are correctly created in dim_lookup_test table 6. Edit CSV file input step and change to read from data2.txt 7. Run transformation again EXPECTED RESULT SCD Type II records added to dim_lookup_test table ACTUAL RESULT The following error occurs 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : Unexpected error : 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : java.lang.ArrayIndexOutOfBoundsException: 5 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dimInsert(DimensionLookup.java:1071) 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:601) 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:202) 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) 2009/10/06 12:24:02 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1594) 2009/10/06 12:24:02 - Dimension lookup/update.0 - Finished processing (I=2, O=0, R=2, W=1, U=0, E=1) 2009/10/06 12:24:02 - Spoon - The transformation has finished!! 2009/10/06 12:24:02 - dim_lookup_test - ERROR (version 3.2.3 from 2009/10/06 12:19:12.510) : Errors detected! 2009/10/06 12:24:02 - dim_lookup_test - Transformation detected one or more steps with errors. 2009/10/06 12:24:02 - dim_lookup_test - Transformation is killing the other steps!

    Pentaho BI Platform Tracking | 7 years ago | Phillip Cole
    java.lang.ArrayIndexOutOfBoundsException: 5
  3. 0

    The following transformation works with 2.5.2 and throws the following error with 3.x 2007/10/29 17:00:56 - MonthDesc Gen.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0) 2007/10/29 17:00:56 - MonthDesc Norm.0 - Finished processing (I=0, O=0, R=1, W=12, U=0, E=0) 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : Unexpected error : 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : java.lang.ArrayIndexOutOfBoundsException: 1 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dimUpdate(DimensionLookup.java:866) 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:417) 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:198) 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1246) 2007/10/29 17:00:58 - Value Mapper.0 - Finished processing (I=0, O=0, R=214, W=214, U=0, E=0) 2007/10/29 17:00:58 - 1825 Tage anlegen.0 - Finished processing (I=0, O=0, R=0, W=1655, U=0, E=0) 2007/10/29 17:00:58 - MonthDesc.0 - Finished processing (I=0, O=0, R=578, W=566, U=0, E=0) 2007/10/29 17:00:58 - Java Script Value.0 - Finished processing (I=0, O=0, R=215, W=214, U=0, E=0) 2007/10/29 17:00:58 - DayOfWeekDesc.0 - Finished processing (I=0, O=0, R=924, W=917, U=0, E=0) 2007/10/29 17:00:58 - Days_since.0 - Finished processing (I=0, O=0, R=1304, W=1304, U=0, E=0) 2007/10/29 17:00:58 - Dimension lookup/update.0 - Finished processing (I=1, O=0, R=1, W=0, U=0, E=1) 2007/10/29 17:00:58 - Calc Date.0 - Finished processing (I=0, O=0, R=953, W=952, U=0, E=0) 2007/10/29 17:00:58 - Spoon - The transformation has finished!!

    Pentaho BI Platform Tracking | 9 years ago | Markus Kaemmerer
    java.lang.ArrayIndexOutOfBoundsException: 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    The following transformation works with 2.5.2 and throws the following error with 3.x 2007/10/29 17:00:56 - MonthDesc Gen.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0) 2007/10/29 17:00:56 - MonthDesc Norm.0 - Finished processing (I=0, O=0, R=1, W=12, U=0, E=0) 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : Unexpected error : 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : java.lang.ArrayIndexOutOfBoundsException: 1 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dimUpdate(DimensionLookup.java:866) 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:417) 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:198) 2007/10/29 17:00:57 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1246) 2007/10/29 17:00:58 - Value Mapper.0 - Finished processing (I=0, O=0, R=214, W=214, U=0, E=0) 2007/10/29 17:00:58 - 1825 Tage anlegen.0 - Finished processing (I=0, O=0, R=0, W=1655, U=0, E=0) 2007/10/29 17:00:58 - MonthDesc.0 - Finished processing (I=0, O=0, R=578, W=566, U=0, E=0) 2007/10/29 17:00:58 - Java Script Value.0 - Finished processing (I=0, O=0, R=215, W=214, U=0, E=0) 2007/10/29 17:00:58 - DayOfWeekDesc.0 - Finished processing (I=0, O=0, R=924, W=917, U=0, E=0) 2007/10/29 17:00:58 - Days_since.0 - Finished processing (I=0, O=0, R=1304, W=1304, U=0, E=0) 2007/10/29 17:00:58 - Dimension lookup/update.0 - Finished processing (I=1, O=0, R=1, W=0, U=0, E=1) 2007/10/29 17:00:58 - Calc Date.0 - Finished processing (I=0, O=0, R=953, W=952, U=0, E=0) 2007/10/29 17:00:58 - Spoon - The transformation has finished!!

    Pentaho BI Platform Tracking | 9 years ago | Markus Kaemmerer
    java.lang.ArrayIndexOutOfBoundsException: 1

    Root Cause Analysis

    1. java.lang.ArrayIndexOutOfBoundsException

      5

      at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dimInsert()
    2. org.pentaho.di
      DimensionLookup.run
      1. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dimInsert(DimensionLookup.java:1071)
      2. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:601)
      3. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:202)
      4. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
      5. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1594)
      5 frames