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

Excel Output running in a *nix environment cannot use templates created on Windows

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Won't Fix
    • Affects Version/s: 4.0.0 GA
    • Fix Version/s: None
    • Component/s: Step
    • Labels:
      None
    • Environment:
      Ubuntu 10.10 64-bit, UTF-8 default file system encoding
    • PDI Sub-component:
    • 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:
      Ubuntu 10.04

      Description

      If an Excel Output step is executed on a machine with a default file encoding of UTF-8 that used an Excel spreadsheet that was saved with Cp1252 encoding, the Java Excel API (jxl) library fails to correctly read the bytes of the template thus producing the following exception:

      2010/08/06 12:08:31 - Excel 11.0 - ERROR (version 4.0.0-GA, build 13347 from 2010-06-03 16.14.10 by buildguy) : Unable to close openFile file : file:///opt/pentaho/my_path/output.xls
      2010/08/06 12:08:31 - Excel 11.0 - ERROR (version 4.0.0-GA, build 13347 from 2010-06-03 16.14.10 by buildguy) : java.lang.ArrayIndexOutOfBoundsException
      2010/08/06 12:08:31 - Excel 11.0 - ERROR (version 4.0.0-GA, build 13347 from 2010-06-03 16.14.10 by buildguy) : java.lang.System.arraycopy(Native Method)
      2010/08/06 12:08:31 - Excel 11.0 - ERROR (version 4.0.0-GA, build 13347 from 2010-06-03 16.14.10 by buildguy) : jxl.biff.StringHelper.getBytes(StringHelper.java:127)
      2010/08/06 12:08:31 - Excel 11.0 - ERROR (version 4.0.0-GA, build 13347 from 2010-06-03 16.14.10 by buildguy) : jxl.write.biff.WriteAccessRecord.<init>(WriteAccessRecord.java:59)
      2010/08/06 12:08:31 - Excel 11.0 - ERROR (version 4.0.0-GA, build 13347 from 2010-06-03 16.14.10 by buildguy) : jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:726)
      2010/08/06 12:08:31 - Excel 11.0 - ERROR (version 4.0.0-GA, build 13347 from 2010-06-03 16.14.10 by buildguy) : org.pentaho.di.trans.steps.exceloutput.ExcelOutput.closeFile(ExcelOutput.java:583)
      2010/08/06 12:08:31 - Excel 11.0 - ERROR (version 4.0.0-GA, build 13347 from 2010-06-03 16.14.10 by buildguy) : org.pentaho.di.trans.steps.exceloutput.ExcelOutput.dispose(ExcelOutput.java:653)
      2010/08/06 12:08:31 - Excel 11.0 - ERROR (version 4.0.0-GA, build 13347 from 2010-06-03 16.14.10 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)
      2010/08/06 12:08:31 - Excel 11.0 - ERROR (version 4.0.0-GA, build 13347 from 2010-06-03 16.14.10 by buildguy) : java.lang.Thread.run(Thread.java:636)
      2010/08/06 12:08:31 - Excel 11.0 - Procesamiento finalizado (I=0, O=1, R=1, W=1, U=0, E=1

        Attachments

        1. bill_template.xls
          22 kB
        2. prueba templates.ktr
          14 kB
        3. report_template.xls
          6 kB
        4. report.xls
          15 kB

          Issue Links

            Activity

              People

              Assignee:
              project admin Triage
              Reporter:
              jganoff Jordan Ganoff (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: