Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: PDI 6.1 text file output step cannot find file location

  1. #1
    Join Date
    Sep 2014
    Posts
    7

    Default PDI 6.1 text file output step cannot find file location

    I have a transformation that runs inside of a job that creates a text file on a remote LINUX server.
    We have migrated this transformation from PDI 4.8 and it works.
    When using PDI 6.1.0.8 from spoon and kicking off the job to run on our PDI server
    (the same setup as production) the job fails with the error below.
    Anyone know what might be the problem? -- we've checked directory and file permissions.
    The folder is there, but of course it would not be on a C drive.
    It's almost if it thinks the directory is on the local machine...but that just may be a logging misprint...

    Thanks..
    0:46 - Text file output 2.0 - Released server socket on port 0
    2016/12/14 12:00:46 - Text file output.0 - We can not find parent folder [file:///C:/server/pentaho/pentaho/REPORT]!
    2016/12/14 12:00:46 - Text file output.0 - ERROR (version 6.1.0.8-268, build 1 from 2016-11-29 10.00.09 by buildguy) : Couldn't open file file:///C:/server/pentaho/pentaho/REPORT/VH.csv
    2016/12/14 12:00:46 - Text file output.0 - ERROR (version 6.1.0.8-268, build 1 from 2016-11-29 10.00.09 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2016/12/14 12:00:46 - Text file output.0 - Error opening new file : org.apache.commons.vfs2.FileSystemException: Could not create folder "file:///C:".
    2016/12/14 12:00:46 - Text file output.0 -
    2016/12/14 12:00:46 - Text file output.0 - at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.openNewFile(TextFileOutput.java:655)
    2016/12/14 12:00:46 - Text file output.0 - at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.init(TextFileOutput.java:755)
    2016/12/14 12:00:46 - Text file output.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
    2016/12/14 12:00:46 - Text file output.0 - at java.lang.Thread.run(Thread.java:745)
    2016/12/14 12:00:46 - Text file output 2.0 - We can not find parent folder [file:///C:/server/pentaho/pentaho/REPORT]!
    2016/12/14 12:00:46 - Text file output 2.0 - ERROR (version 6.1.0.8-268, build 1 from 2016-11-29 10.00.09 by buildguy) : Couldn't open file file:///C:/server/pentaho/pentaho/REPORT/ARO.csv
    2016/12/14 12:00:46 - Text file output 2.0 - ERROR (version 6.1.0.8-268, build 1 from 2016-11-29 10.00.09 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2016/12/14 12:00:46 - Text file output 2.0 - Error opening new file : org.apache.commons.vfs2.FileSystemException: Could not create folder "file:///C:".
    2016/12/14 12:00:46 - Text file output 2.0 -
    2016/12/14 12:00:46 - Text file output 2.0 - at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.openNewFile(TextFileOutput.java:655)
    2016/12/14 12:00:46 - Text file output 2.0 - at org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.init(TextFileOutput.java:755)
    2016/12/14 12:00:46 - Text file output 2.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
    2016/12/14 12:00:46 - Text file output 2.0 - at java.lang.Thread.run(Thread.java:745)

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You try to create a file on a Linux system using a Windows filepath?
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Sep 2014
    Posts
    7

    Default

    Quote Originally Posted by marabu View Post
    You try to create a file on a Linux system using a Windows filepath?
    No, I trying to create the file on the LINUX system the path does not contain C: as part of it.
    As mentioned it worked (and still works today) on PDI 4.8 --no changes to the step configuration.

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Are you using the Enterprise Edition?
    Your mentioning of "PDI Server" makes me think so.
    So long, and thanks for all the fish.

  5. #5
    Join Date
    Nov 2008
    Posts
    8

    Default

    Your problem could be related to known issue with PDI and UNC paths. What worked in older version no longer works in newer version. There are have been various JIRA issues created with many closed as duplicate or feature not supported. One exception is http://jira.pentaho.com/browse/PDI-13193 that is still open.

  6. #6
    Join Date
    Sep 2014
    Posts
    7

    Default

    Thanks for the replies. Turns out my issue was a missing entry in a configuration file.
    /pentaho/pdi-ee/data-integration-server/pentaho-solutions/system/kettle/slave-server-config.xml
    I'm thinking some installation setups are different but adding an repository entry where the jobs/transformations
    are to be executed gave PDI the information it needed to know what server to look at -- See below contents of
    an slave-server-config.xml.

    <slave_config>
    <max_log_lines>10000</max_log_lines>
    <max_log_timeout_minutes>2880</max_log_timeout_minutes>
    <object_timeout_minutes>240</object_timeout_minutes>
    <role-bindings>
    <role-binding>
    <context-pattern>/run.*</context-pattern>
    <context-pattern>/start.*</context-pattern>
    <context-pattern>/add.*</context-pattern>
    <context-pattern>/execute.*</context-pattern>
    <require>org.pentaho.repository.read</require>
    <require>org.pentaho.repository.execute</require>
    </role-binding>
    </role-bindings>
    <repository>
    <name>repository id</name>
    <username>repository user id</username>
    <password>password</password>
    </repository>

    </slave_config>

Tags for this Thread

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.