Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Export Textfile with fixed length

  1. #1

    Default Export Textfile with fixed length

    Hello,

    I'm a newbie on Kettle ;-)

    I just made a simple test with an import of a text file. The output is a fixed length file.

    But starting the transformations does always return in an error:

    Code:
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error writing header line: java.lang.ArrayIndexOutOfBoundsException: 0
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.lang.ArrayIndexOutOfBoundsException: 0
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.containsSeparatorOrEnclosure(TextFileOutput.java:869)
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.writeHeader(TextFileOutput.java:502)
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.processRow(TextFileOutput.java:113)
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.lang.Thread.run(Unknown Source)
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Unerwarteter Fehler : 
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error writing line
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : 
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error writing field content to file
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : 0
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : 
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.writeRowToFile(TextFileOutput.java:255)
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.processRow(TextFileOutput.java:170)
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2010/09/20 17:26:13 - Textdatei Output.0 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : java.lang.Thread.run(Unknown Source)
    Does anyone have an idea why this error returns?

    Greetings

    Matthias

    PS: Sorry for my bad english. I hope you can read and understand it^^
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2007
    Posts
    247

    Default

    Hi Matthias,

    there's an issue with this step in 4.0.1 if you don't have any enclosure and leave the "Disable the enclosure fix" option unchecked: http://jira.pentaho.com/browse/PDI-1816

    So in your case: either add an enclosure to your string fields or make sure that the option "Disable the enclosure fix" is properly checked.


    HTH,
    Ben

  3. #3

    Default

    Hi Ben,

    thanks for your (quick) help. Now it works fine and I can start with some more complicated transformations....

    Matthias

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.