Skip to Content

Failing to execute a job sh file in Data Services

Hie gurus.I am trying to schedule jobs in data services management console by creating a Job Schedule with a script inside which contains the order of execution of jobs.The BI platform is hosted on a linux machine.In Data services management console I clicked the excution command and the Job.sh file was created.However when I try to run the Job in data services,it gives me the error below:

5116 1742333760 JOB 14/3/2018 10:39:15 AM Job <Job_Schedule> of runid <2018031410391451161742333760> is initiated by user <oracle>.
5116 1742333760 JOB 14/3/2018 10:39:15 AM Processing job <Job_Schedule>.
5116 1742333760 JOB 14/3/2018 10:39:15 AM Initializing transcoder for datastore <DS_BODS_REPO> to transcode between engine codepage<Unicode (UTF-16)> and datastore
5116 1742333760 JOB 14/3/2018 10:39:15 AM codepage <<DEFAULT>>
5116 1742333760 JOB 14/3/2018 10:39:15 AM Optimizing job <Job_Schedule>.
5116 1742333760 JOB 14/3/2018 10:39:15 AM Job <Job_Schedule> is started.
5116 1742333760 PRINTFN 14/3/2018 10:39:15 AM Triggering Job_Dim_District
5116 1742333760 PRINTFN 14/3/2018 10:39:15 AM 1: Cannot create process with image file <opt/app/sap/boxi42/dataservices/log/Job_Dim_District.sh> and command line
5116 1742333760 PRINTFN 14/3/2018 10:39:15 AM <opt/app/sap/boxi42/dataservices/log/Job_Dim_District.sh>, due to error <No such file or directory>.
5116 1742333760 PRINTFN 14/3/2018 10:39:17 AM NULL
5116 1742333760 PRINTFN 14/3/2018 10:39:17 AM NULL
5116 1742333760 PRINTFN 14/3/2018 10:39:17 AM Job_Dim_District Job Finished Successfully
5116 1742333760 JOB 14/3/2018 10:39:17 AM Job <Job_Schedule> is completed successfully.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 14 at 09:00 AM

    Hi George,

    what is the script are you using to execute the job?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14 at 02:58 PM
    Add comment
    10|10000 characters needed characters exceeded

    • Hie?,I have added the parameter(al_env.sh) in the user environmental variable,however when I run the Job,it gives an error(empty file received) in data services management console