java.lang.ArrayIndexOutOfBoundsException: 1

Pentaho BI Platform Tracking | Markus Kaemmerer | 9 years ago
  1. 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
  2. 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
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 0

    ArrayIndexOutOfBounds When Splitting String

    Stack Overflow | 4 years ago | n0shadow
    java.lang.ArrayIndexOutOfBoundsException: 1

    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.ArrayIndexOutOfBoundsException

      1

      at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dimUpdate()
    2. org.pentaho.di
      DimensionLookup.run
      1. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dimUpdate(DimensionLookup.java:866)
      2. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:417)
      3. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:198)
      4. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1246)
      4 frames