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
------------------------------
Others
esspl
------------------------------
Original Message:
Sent: 09-13-2023 10:54
From: Petr Prochazka
Subject: Error while executing shell script - cannot create temporary file
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.
------------------------------
Petr Prochazka
Systems Engineer
P.V.A. systems s.r.o.
Original Message:
Sent: 09-13-2023 07:12
From:
Subject: Error while executing shell script - cannot create temporary file
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
------------------------------
Others
esspl
------------------------------