java.lang.ArrayIndexOutOfBoundsException: 5

Pentaho BI Platform Tracking | Joey Smith | 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

    When trying to use the "Split every...Rows" feature of Excel Output, the following error appears (output below is from 3.0.2, same error happens on 3.0.1): 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : Unable to close openFile file 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : java.lang.ArrayIndexOutOfBoundsException: 5 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at jxl.biff.IndexMapping.getNewIndex(IndexMapping.java:68) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at jxl.biff.FormattingRecords.rationalize(FormattingRecords.java:388) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at jxl.write.biff.WritableWorkbookImpl.rationalize(WritableWorkbookImpl.java:984) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:692) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.closeFile(ExcelOutput.java:479) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:78) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.run(ExcelOutput.java:563) Additionally, the second file opened ("foo_1.xls") always seems to have a size of zero, even though the first ("foo_0.xls") file has an appropriate size, as do subsequent files up to the error being tripped (I can usually get to "foo_3.xls", or the 4th file). I will attach a simple KTR that duplicates the problem.

    Pentaho BI Platform Tracking | 9 years ago | Joey Smith
    java.lang.ArrayIndexOutOfBoundsException: 5
  2. 0

    When trying to use the "Split every...Rows" feature of Excel Output, the following error appears (output below is from 3.0.2, same error happens on 3.0.1): 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : Unable to close openFile file 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : java.lang.ArrayIndexOutOfBoundsException: 5 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at jxl.biff.IndexMapping.getNewIndex(IndexMapping.java:68) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at jxl.biff.FormattingRecords.rationalize(FormattingRecords.java:388) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at jxl.write.biff.WritableWorkbookImpl.rationalize(WritableWorkbookImpl.java:984) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:692) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.closeFile(ExcelOutput.java:479) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:78) 2008/04/01 02:38:32 - Excel Output.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.run(ExcelOutput.java:563) Additionally, the second file opened ("foo_1.xls") always seems to have a size of zero, even though the first ("foo_0.xls") file has an appropriate size, as do subsequent files up to the error being tripped (I can usually get to "foo_3.xls", or the 4th file). I will attach a simple KTR that duplicates the problem.

    Pentaho BI Platform Tracking | 9 years ago | Joey Smith
    java.lang.ArrayIndexOutOfBoundsException: 5
  3. 0

    ArrayIndexOutOfBoundException with jxl api when trying to copy content from one sheet to another

    Stack Overflow | 5 years ago
    java.lang.ArrayIndexOutOfBoundsException: 56
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Jxl arrayIndexOutofBoundException

    Google Groups | 10 years ago | Proton Projects - Moin
    java.lang.ArrayIndexOutOfBoundsException: 441
  6. 0

    if condition in formula in jxl

    Coderanch | 8 years ago | prinz reyes
    java.lang.ArrayIndexOutOfBoundsException: 165

    Root Cause Analysis

    1. java.lang.ArrayIndexOutOfBoundsException

      5

      at jxl.biff.IndexMapping.getNewIndex()
    2. jxl
      WritableWorkbookImpl.write
      1. jxl.biff.IndexMapping.getNewIndex(IndexMapping.java:68)
      2. jxl.biff.FormattingRecords.rationalize(FormattingRecords.java:388)
      3. jxl.write.biff.WritableWorkbookImpl.rationalize(WritableWorkbookImpl.java:984)
      4. jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:692)
      4 frames
    3. org.pentaho.di
      ExcelOutput.run
      1. org.pentaho.di.trans.steps.exceloutput.ExcelOutput.closeFile(ExcelOutput.java:479)
      2. org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:78)
      3. org.pentaho.di.trans.steps.exceloutput.ExcelOutput.run(ExcelOutput.java:563)
      3 frames