jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded

Pentaho BI Platform Tracking | Vikas Bhardwaj | 3 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    CSV - Lazy conversion gives an error message, but everything works. Here is the example of error message. If I switch Lazy conversion off then error disappears. 2011/09/29 12:00:31 - Spoon - Transformation opened. 2011/09/29 12:00:31 - Spoon - Launching transformation [TestForSelectValues]... 2011/09/29 12:00:31 - Spoon - Started the transformation execution. 2011/09/29 12:00:31 - TestForSelectValues - Dispatching started for transformation [TestForSelectValues] 2011/09/29 12:00:31 - Transformation metadata - Natural sort of steps executed in 0 ms (4 time previous steps calculated) 2011/09/29 12:00:31 - CSV file input.0 - Header row skipped in file 'N:\Daily Positions\State Street\Pentaho\Null in CashPercentage\2010-08-04 SS Position.csv' 2011/09/29 12:00:31 - CSV file input.0 - Finished processing (I=597, O=0, R=0, W=596, U=0, E=0) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Error writing field (0,3) : java.lang.NullPointerException 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : java.lang.NullPointerException 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:424) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:279) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeRowToFile(ExcelOutput.java:215) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:147) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Unknown Source) 2011/09/29 12:00:31 - Select values.0 - Finished processing (I=0, O=0, R=596, W=596, U=0, E=0) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - Finished processing (I=0, O=2, R=3, W=2, U=0, E=1) 2011/09/29 12:00:31 - Spoon - The transformation has finished!! 2011/09/29 12:00:31 - TestForSelectValues - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected! 2011/09/29 12:00:31 - TestForSelectValues - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected! 2011/09/29 12:00:31 - TestForSelectValues - TestForSelectValues 2011/09/29 12:00:31 - TestForSelectValues - TestForSelectValues

    Pentaho BI Platform Tracking | 6 years ago | Alex Sviridov
    java.lang.NullPointerException
  2. 0

    CSV - Lazy conversion gives an error message, but everything works. Here is the example of error message. If I switch Lazy conversion off then error disappears. 2011/09/29 12:00:31 - Spoon - Transformation opened. 2011/09/29 12:00:31 - Spoon - Launching transformation [TestForSelectValues]... 2011/09/29 12:00:31 - Spoon - Started the transformation execution. 2011/09/29 12:00:31 - TestForSelectValues - Dispatching started for transformation [TestForSelectValues] 2011/09/29 12:00:31 - Transformation metadata - Natural sort of steps executed in 0 ms (4 time previous steps calculated) 2011/09/29 12:00:31 - CSV file input.0 - Header row skipped in file 'N:\Daily Positions\State Street\Pentaho\Null in CashPercentage\2010-08-04 SS Position.csv' 2011/09/29 12:00:31 - CSV file input.0 - Finished processing (I=597, O=0, R=0, W=596, U=0, E=0) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Error writing field (0,3) : java.lang.NullPointerException 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : java.lang.NullPointerException 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:424) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:279) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeRowToFile(ExcelOutput.java:215) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:147) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : at java.lang.Thread.run(Unknown Source) 2011/09/29 12:00:31 - Select values.0 - Finished processing (I=0, O=0, R=596, W=596, U=0, E=0) 2011/09/29 12:00:31 - Microsoft Excel Output.0 - Finished processing (I=0, O=2, R=3, W=2, U=0, E=1) 2011/09/29 12:00:31 - Spoon - The transformation has finished!! 2011/09/29 12:00:31 - TestForSelectValues - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected! 2011/09/29 12:00:31 - TestForSelectValues - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected! 2011/09/29 12:00:31 - TestForSelectValues - TestForSelectValues 2011/09/29 12:00:31 - TestForSelectValues - TestForSelectValues

    Pentaho BI Platform Tracking | 6 years ago | Alex Sviridov
    java.lang.NullPointerException
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Am having problems with the attached transformation and tab-delimited input file. Any suggestions? Results when running with lazy conversion checked: 2008/06/17 16:49:56 - Read New DRG File.0 - Finished processing (I=746, O=0, R=0, W=745, U=0, E=0) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Error writing field (0,1) : org.pentaho.di.core.exception.KettleValueException: 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : new_drg_code String<binary-string> : There was a data type error: the data type of java.lang.String object [1] does not correspond to value meta [String<binary-string>] 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : org.pentaho.di.core.exception.KettleValueException: 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : new_drg_code String<binary-string> : There was a data type error: the data type of java.lang.String object [1] does not correspond to value meta [String<binary-string>] 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.core.row.ValueMeta.getString(ValueMeta.java:1317) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:279) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:203) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeRowToFile(ExcelOutput.java:174) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:108) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2444) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.run(ExcelOutput.java:630) Results when running with lazy conversion unchecked: 2008/06/17 16:50:54 - Read New DRG File.0 - Starting to run... 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Unexpected error : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : org.pentaho.di.core.exception.KettleException: 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : org.pentaho.di.core.exception.KettleFileException: 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Exception reading line using NIO 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Exception reading line using NIO 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.openNextFile(CsvInput.java:312) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.processRow(CsvInput.java:96) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2444) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.run(CsvInput.java:641) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Caused by: org.pentaho.di.core.exception.KettleFileException: 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Exception reading line using NIO 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.readOneRow(CsvInput.java:557) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.openNextFile(CsvInput.java:292) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : ... 3 more 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Caused by: java.lang.ArrayIndexOutOfBoundsException: -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.readOneRow(CsvInput.java:544) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : ... 4 more

    Pentaho BI Platform Tracking | 9 years ago | kdikken
    org.pentaho.di.core.exception.KettleValueException: new_drg_code String<binary-string> : There was a data type error: the data type of java.lang.String object [1] does not correspond to value meta [String<binary-string>]
  5. 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

    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. jxl.write.biff.RowsExceededException

      The maximum number of rows permitted on a worksheet been exceeded

      at jxl.write.biff.WritableSheetImpl.getRowRecord()
    2. jxl
      WritableSheetImpl.addCell
      1. jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:1170)
      2. jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1146)
      2 frames
    3. org.pentaho.di
      ExcelOutput.run
      1. org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:319)
      2. org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:235)
      3. org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeRowToFile(ExcelOutput.java:206)
      4. org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:138)
      5. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
      6. org.pentaho.di.trans.steps.exceloutput.ExcelOutput.run(ExcelOutput.java:665)
      6 frames