Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Really weird sittuation

  1. #1
    Join Date
    Jun 2007
    Posts
    476

    Default Really weird sittuation

    Hi all, I have a transformation that list files from directory, ads a string depending on the name and sends the rest to an output file. I a really weird problem:

    If I preview the file output with spoon and set the variable ${RUTA} to the path I need, it works ok, but if I Run it with spoon also setting the variable, it doesnt do the variable substitution and sends me the following:
    Code:
    2008/09/30 11:32:36) : org.apache.commons.vfs.FileSystemException: Could not list the contents of "file:///home/rodrigo/pdi/${RUTA}/DATOS" because it is not a folder.
    I'm running on Ubuntu Linux 64 bits, java version "1.6.0_14" and kettle 3.1 (Build version : 826 Build date : Tue Sep 30 11:32:36 CDT 2008)

    I'm attaching my ktr and any help will be appretiated

    Thanks
    Attached Files Attached Files
    Rodrigo Haces
    TAM / Enterprise Architect
    Pentaho

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

    Default

    How do you set the variable... via a parameter in spoon?

    Regards,
    Sven

  3. #3
    Join Date
    Jun 2007
    Posts
    476

    Default

    Quote Originally Posted by sboden View Post
    How do you set the variable... via a parameter in spoon?

    Regards,
    Sven
    When yuo run a trans on spoon, in the right part of the screen therr is a box were you can set a variable and its value
    Rodrigo Haces
    TAM / Enterprise Architect
    Pentaho

  4. #4
    Join Date
    Jun 2007
    Posts
    476

    Default

    Testing arround this only happens with the "Get File Names" step at th 3.1, any other step makes the Variable substitution OK. Cheking the JIRA there is a case

    http://jira.pentaho.com/browse/PDI-776

    It said solved, I guess @ 3.2 but I can't upgrade to 3.2 now, we would need to test all our process and can be a little pain in the ......

    Is there a workaround for this?
    Rodrigo Haces
    TAM / Enterprise Architect
    Pentaho

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.