Pentaho: Unexpected error running shell (java.lang.IllegalArgumentException: Invalid environment variable name:) -


i'm attempting run .bat file in kettle using "shell" function. however, pentaho throwing error, showing have invalid environment variable name. i'm @ complete loss resolve this, hence post.

i've provided output log file text below:

2017/09/11 11:09:14 - spoon - starting job...
2017/09/11 11:09:14 - test_job - start of job execution
2017/09/11 11:09:14 - test_job - starting entry [test_batch.bat]
2017/09/11 11:09:14 - test_batch.bat - running on platform : windows 7
2017/09/11 11:09:14 - test_batch.bat - executing command : cmd.exe /c "\desktop\test_batch.bat"
2017/09/11 11:09:14 - test_batch.bat - error (version 5.3.0.0-213, build 1 2015-02-02_12-17-08 buildguy) : unexpected error running shell [\desktop\test_batch.bat] : java.lang.illegalargumentexception: invalid environment variable name: "
2017/09/11 11:09:14 - test_batch.bat - error (version 5.3.0.0-213, build 1 2015-02-02_12-17-08 buildguy) : java.lang.illegalargumentexception: invalid environment variable name: "
2017/09/11 11:09:14 - test_batch.bat - @ java.lang.processenvironment.validatename(unknown source)
2017/09/11 11:09:14 - test_batch.bat - @ java.lang.processenvironment.put(unknown source)
2017/09/11 11:09:14 - test_batch.bat - @ java.lang.processenvironment.put(unknown source)
2017/09/11 11:09:14 - test_batch.bat - @ org.pentaho.di.job.entries.shell.jobentryshell.executeshell(jobentryshell.java:568)
2017/09/11 11:09:14 - test_batch.bat - @ org.pentaho.di.job.entries.shell.jobentryshell.execute(jobentryshell.java:416)
2017/09/11 11:09:14 - test_batch.bat - @ org.pentaho.di.job.job.execute(job.java:716)
2017/09/11 11:09:14 - test_batch.bat - @ org.pentaho.di.job.job.execute(job.java:859)
2017/09/11 11:09:14 - test_batch.bat - @ org.pentaho.di.job.job.execute(job.java:532)
2017/09/11 11:09:14 - test_batch.bat - @ org.pentaho.di.job.job.run(job.java:424)
2017/09/11 11:09:14 - test_job - finished job entry [test_batch.bat] (result=[false])
2017/09/11 11:09:14 - test_job - job execution finished
2017/09/11 11:09:14 - spoon - job has ended.

if can advise on above it'd appreciated!

thanks

you want run bat file executes job? not run command line job. right?

in case command line kitchen /job=job-path. full doc here , forum (for example) here.

the command can included in bat file, provided bat file can find kitchen excutable. have noticed pentaho removed kitchen.exe replace kitchen.bat, can copy call line.

in case want run transformation, command pan.bat.


Comments

Post a Comment