Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-4265

Unable to close openFile file with Excel Output

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 4.0.0 GA, 4.1.0 GA (Platform Release 3.7.0)
    • Fix Version/s: 4.0.2, 4.1.1
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      Windows XP

      Description

      Just upgraded to 4.0 from 3.2. I have a transformation that takes data from a database and creates a spreadsheet from a template. It was working fine under 3.2, but now I receive an error when trying to run the transformation (see below). I swapped the Excel Output step with a Text file output and didn't have any problems, so I believe it is specific to just the Excel Output step.

      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : Unable to close openFile file : file:///E:/reports/ahoskie_mold_forecast_100706.xls
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : java.lang.NullPointerException
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : java.lang.System.arraycopy(Native Method)
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : jxl.read.biff.File.read(File.java:220)
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : jxl.read.biff.Record.getData(Record.java:117)
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : jxl.biff.XCTRecord.getData(XCTRecord.java:48)
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : jxl.biff.WritableRecordData.getBytes(WritableRecordData.java:71)
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : jxl.write.biff.File.write(File.java:147)
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:902)
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : org.pentaho.di.trans.steps.exceloutput.ExcelOutput.closeFile(ExcelOutput.java:583)
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : org.pentaho.di.trans.steps.exceloutput.ExcelOutput.dispose(ExcelOutput.java:653)
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
      2010/07/06 08:50:08 - Excel Output.0 - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : java.lang.Thread.run(Unknown Source)
      2010/07/06 08:50:08 - mold_forecast_report_test - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : Errors detected!
      2010/07/06 08:50:08 - mold_forecast_report_test - ERROR (version 4.0.0-stable, build 13376 from 2010-06-15 11.00.26 by buildguy) : Errors detected!

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jganoff Jordan Ganoff (Inactive)
              Reporter:
              dba_alex Alex Meadows
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: