Pentaho

 View Only
  • 1.  Unable to run shell script in Pentaho 9.4

    Posted 10-26-2023 09:48

    Hi Team,

    We are now upgrading our pentaho version from 4.2 to 9.4. We are facing same error while executing any shell scripting transformation through OS server. We are scheduling all of our Pentaho Jobs through Linux OS server. We have already tried all possible ways to fix this and gave the permission as well, still unable to identify the exact issue. Below is the error log. 

    Kindly help us out of this issue.

    -20050: ORA-20050: ORA-20061: 
    2023/10/18 06:10:33 - TUN_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/TUN-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
    


    ------------------------------
    Saubhagya Pradhan
    Others
    Alshaya Group
    ------------------------------


  • 2.  RE: Unable to run shell script in Pentaho 9.4

    Posted 11-07-2023 13:07

    Hi @Saubhagya Pradhan

    IMHO it's permission problem of Oracle server. I answered it this topic.

    So check permission to temp dir (default /tmp) or change temp dir for java via system property java.io.tmpdir.



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------



  • 3.  RE: Unable to run shell script in Pentaho 9.4

    Posted 11-07-2023 13:21

    And please provide full stacktrace of error.



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------