Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Error getting fields

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default Error getting fields

    Hello Everyone,

    I am trying to read the attached file and getting the following error (see below):

    What does it mean and what should I do?

    I would prefer using text input file vs. csv, since I need to process whole folder.

    Regards,
    Alex

    org.pentaho.di.core.exception.KettleFileException:

    DOS format was specified but only a single line feed character was found, not 2


    at org.pentaho.di.trans.steps.textfileinput.TextFileInput.getLine(TextFileInput.java:108)
    at org.pentaho.di.ui.trans.steps.textfileinput.TextFileInputDialog.getCSV(TextFileInputDialog.java:2655)
    at org.pentaho.di.ui.trans.steps.textfileinput.TextFileInputDialog.get(TextFileInputDialog.java:2572)
    at org.pentaho.di.ui.trans.steps.textfileinput.TextFileInputDialog.access$300(TextFileInputDialog.java:117)
    at org.pentaho.di.ui.trans.steps.textfileinput.TextFileInputDialog$5.handleEvent(TextFileInputDialog.java:537)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.trans.steps.textfileinput.TextFileInputDialog.open(TextFileInputDialog.java:727)
    at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126)
    at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7728)
    at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2744)
    at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:1993)
    at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6940)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Attached Files Attached Files

  2. #2

    Default

    change the format to unix .

  3. #3
    Join Date
    Sep 2011
    Posts
    171

    Default

    Awesome, it worked! Do you know why it prefers UNIX over DOS?

  4. #4
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Hi.
    It's not question of preference.

    DOS uses CRLF as row delimiter, while UNIX uses LF only.
    Therefore, if you set a DOS format, it expects CRLF and not only LF.

    Mick

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.