Skip to Content
0

Failing to execute a job sh file in Data Services

Mar 14 at 08:48 AM

58

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ravi kiran Pagidi Mar 14 at 09:00 AM
0

Hi George,

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Here is the error that I am getting when I try to run the script in linux

$ ./Job_Dim_District.sh
/opt/app/sap/boxi42/dataservices/bin/AL_RWJobLauncher: error while loading share d libraries: libebus.so.3.3.2.7: cannot open shared object file: No such file or directory

The script was generated in data services management console and exported to linux.

Here is my script under Job_Schedule job in data services

# TRIGGERING Job_Dim_District----------------------------------------------------------------------------------------------------------------------------
Print('Triggering Job_Dim_District');

Print(exec('/opt/app/sap/boxi42/dataservices/log/Job_Dim_District.sh','',8));

#Remain idle for 2 secs so that Job Status is Stable (Status moves from S to D for a Successful Job and E for Error)

Sleep(2000);

#Pick up the latest job Start time

$MaxTimestamp= sql('DS_BODS_REPO', 'SELECT MAX(START_TIME) FROM ALVW_HISTORY WHERE SERVICE=\'Job_Dim_District\'');

PRINT($MaxTimestamp);

#Check the latest status of the preceding job

$JobStatus = sql('DS_BODS_REPO', 'SELECT STATUS FROM ALVW_HISTORY WHERE SERVICE=\'Job_Dim_District\' AND START_TIME=\'[$MaxTimestamp]\'');

PRINT($JobStatus);

if ($JobStatus='E')

begin

PRINT('Job_Dim_District Job Failed');

raise_exception('Job_Dim_District Job Failed');

end

else

begin

print('Job_Dim_District Job Finished Successfully');

end

0
0
Ravi kiran Pagidi Mar 14 at 02:58 PM
0
Show 1 Share
10 |10000 characters needed characters left 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

0