on 03-14-2018 8:48 AM
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.
Please refer below thread
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi George,
what is the script are you using to execute the job?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
75 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.