Pentaho

Hi,

I am trying to execute simple shell file, which has #!/bin/bash
echo "Hello World", but I am getting error - 

ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error running shell [/frameworkdir/pentaho/testshell.sh] : java.lang.Exception: Unable to create temporary file to execute

Hi,

generally job entry shell creates temporally file in temp directory (defined by sys. property java.io.tmpdir, as default on linux is /tmp). So you don't have write access to this directory.

And pls provide full stack trace of error.

ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error running shell [/frameworkdir/pentaho/testshell.sh] : java.lang.Exception: Unable to create temporary file to execute

Hi,

Please find the full trace of error log,

Also We are not able to find the location of temp directory ( using oracle linux 9 ) 

-----

2023/09/05 15:14:21 - Kitchen - Logging is at level : Basic
2023/09/05 15:14:21 - Kitchen - Start of run.
2023/09/05 15:14:21 - RepositoriesMeta - Reading repositories XML file: /home/oracle/.kettle/repositories.xml
2023/09/05 15:14:25 - main - Start of job execution
2023/09/05 15:14:25 - main - Starting entry [Initialize]
2023/09/05 15:14:28 - Initialize - Using run configuration [Pentaho local]
2023/09/05 15:14:29 - main - Starting entry [Main_Job]
2023/09/05 15:14:32 - main - Starting entry [EMAIL_ERROR_LOGS]
2023/09/05 15:14:32 - main - Starting entry [ABORT_EMAIL_FAILED]
2023/09/05 15:14:32 - main - Finished job entry [ABORT_EMAIL_FAILED] (result=[false])
2023/09/05 15:14:32 - main - Finished job entry [EMAIL_ERROR_LOGS] (result=[false])
2023/09/05 15:14:32 - main - Finished job entry [Main_Job] (result=[false])
2023/09/05 15:14:32 - main - Finished job entry [Initialize] (result=[false])
2023/09/05 15:14:32 - main - Job execution finished
2023/09/05 15:14:32 - Kitchen - Finished!
2023/09/05 15:14:32 - Kitchen - Start=2023/09/05 15:14:25.688, Stop=2023/09/05 15:14:32.858
2023/09/05 15:14:32 - Kitchen - Processing ended after 7 seconds.

-20050: ORA-20050: ORA-20061:
2023/09/05 15:14:31 - POL_Bulk - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error running shell [/frameworkdir/pentaho/software/AresJobScheduler/POL-JSClientV1.0.sh] : java.lang.Exception: Unable to create temporary file to execute scriptORA-06512: at "DBADMIN.APP_PENTAHO", line 312
ORA-06512: at "DBADMIN.APP_PENTAHO", line 352

ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error running shell [/frameworkdir/pentaho/testshell.sh] : java.lang.Exception: Unable to create temporary file to execute

Hi Petr Prochazka,

We are able to execute same thing with version 4.2.

but 9.4 is throwing error,

also /tmp has all access

we are using,

os - linux oracle 4

executing jobs from custom scheduler

ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error running shell [/frameworkdir/pentaho/testshell.sh] : java.lang.Exception: Unable to create temporary file to execute

This would be problem of Oracle server instance not PDI. Check that Oracle has access to /tmp directory or change Java Temp dir via java.io.tmpdir system property.

ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error running shell [/frameworkdir/pentaho/testshell.sh] : java.lang.Exception: Unable to create temporary file to execute