Pentaho Execute Process doesn't seem to launch script files Pentaho Execute Process doesn't seem to launch script files shell shell

Pentaho Execute Process doesn't seem to launch script files


This step, like many other steps, is executed for each row returned from the previous step. Hence, if you have no previous step then your "Execute a process" step is never executed.

  • Please, add some input step before your "Execute process step" (for example, data grid step). And connect it with your "Execute a process" step (press middle mouse button on the input step, drag to the "Execute a process" step, release mouse button).

"Process Field" is supposed to contain name of the field of the input dataset. The value of this field will be interpreted as a shell command.

  • If you use Data grid as the input step, please create new String field in your data grid step. Then create some rows on the "Data" tab of the step and place commands as values of the field. Finally, edit your "Execute a process": put the name of the field you have created into the "Process Field". Then run your transformation.

Some notes: AFAIK, you have to add cmd.exe /C before your shell command in Windows. E.g.cmd.exe /C echo "Hello, world">d:\test.log. And regarding the folder: it is very likely, that your current directory would be the folder, from which you run your spoon.sh or spoon.bat.


Folder may be made somewhere other than where you think. Temporarily change your script to:

echo Current Directory=%CD%mkdir new_folderdirpause