Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: Errors writing to file

  1. #1
    Join Date
    Apr 2007
    Posts
    2,010

    Default Errors writing to file

    Hi,

    I get this error writing to a file:

    2008/06/26 10:04:32 - Final output.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : Error writing field content to file
    2008/06/26 10:04:32 - Final output.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.run (TextFileOutput.java:745)
    2008/06/26 10:04:32 - Final output.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.processRow (TextFileOutput.java:148)
    2008/06/26 10:04:32 - Final output.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.writeRowToFile (TextFileOutput.java:193)
    2008/06/26 10:04:32 - Final output.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.writeField (TextFileOutput.java:357)
    2008/06/26 10:04:32 - Final output.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at java.io.BufferedOutputStream.write (null:-1)
    2008/06/26 10:04:32 - Final output.0 - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at java.lang.System.arraycopy (null:-2)

    Yet i can't identify why. As far as i can tell the fields seem fine, and it seems to output 620ish rows before it goes wrong. So i guess it's data related somewhere.. I'll try row level debugging output but it's going to take ages to get to the point of failure.

    One thing I have noticed is that the final hop from add constants to text file output is solid red. Why is that, i can't see anything wrong with it? Is there something I need to know about "add constants"?

    Thanks,
    Dan

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Solid red means copy, green means distribute (if you only have 1 outgoing hop, it's essentially the same)... attach your transformation and if possible the line that causes the abort.

    Regards,
    Sven

  3. #3
    Join Date
    Apr 2007
    Posts
    2,010

    Default

    Ok, attached.

    How do I identify the failing row? is there any easy way to do that within kettle?

    I tried running in debug row level logging mode but it ground to a halt and didnt get to the failing point...
    Last edited by codek; 06-26-2008 at 09:05 AM.

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    Looking at the source code the problem is with "force enclosures" while an enclosure is in the input string as well. And somehow that goes wrong... if you would have a input row that fails we could try debugging it.

    No easy way to get the actual row if row level debugging "doesn't work".

    Regards,
    Sven

  5. #5
    Join Date
    Apr 2007
    Posts
    2,010

    Default

    ah ok, that may well just give me the info i need to find the character and fix it - thanks!

    Dan

  6. #6
    Join Date
    Apr 2007
    Posts
    2,010

    Default

    Ah i found it - it was a " in one of my input fields.

    I think thats not very good error handling - shall I raise a jira? Kettle should handle it, or at least give a decipherable error...

  7. #7
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Filing bugs is free.

  8. #8
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    And encouraged.

  9. #9
    Join Date
    Apr 2007
    Posts
    2,010

  10. #10
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Thanks you!!

    Please note that most if not all of these problems should be gone in version 3.1.

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.