PDA

View Full Version : Really weird sittuation



rhaces
07-31-2009, 11:52 PM
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:
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

sboden
08-03-2009, 03:25 AM
How do you set the variable... via a parameter in spoon?

Regards,
Sven

rhaces
08-03-2009, 09:50 AM
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

rhaces
08-03-2009, 01:54 PM
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?