09-15-2017 06:20 AM
I am having a problem running Platform B commands from Enterprise Guide.
What I am trying to do is execute one of the B commands (bjobs) from enterprise guide, and piping the results to a dataset, using the below code:
The command works fine from command line in Putty, using the sassrv user, as per the below:
But I get the /usr/bin/ksh: bjobs: not found. error when running from E-Guide.
The B commands are in /EIP/Software/Platform/lsf/9.1/aix-64/bin, and not in /usr/bin/ksh.
The reason behind all this is that we want to automate the some of the b commands to have better visibility on what is happening with out ETLs, to manage our environment resources better
Here is the E-Guide log
25 GOPTIONS ACCESSIBLE; 26 filename jobinfo pipe "bjobs"; 27 28 data getinfo; 29 infile jobinfo pad missover lrecl=3000; 30 input inline $1-500; 31 run; NOTE: The infile JOBINFO is: Pipe command="bjobs" NOTE: 1 record was read from the infile JOBINFO. The minimum record length was 32. The maximum record length was 32. NOTE: The data set WORK.GETINFO has 1 observations and 1 variables. NOTE: Compressing data set WORK.GETINFO increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.19 seconds cpu time 0.00 seconds 32 33 GOPTIONS NOACCESSIBLE; 34 %LET _CLIENTTASKLABEL=; 35 %LET _CLIENTPROCESSFLOWNAME=; 36 %LET _CLIENTPROJECTPATH=; 37 %LET _CLIENTPROJECTPATHHOST=; 38 %LET _CLIENTPROJECTNAME=; 39 %LET _SASPROGRAMFILE=; 40 %LET _SASPROGRAMFILEHOST=; 41 42 ;*';*";*/;quit;run; 2 The SAS System 11:07 Friday, September 15, 2017 43 ODS _ALL_ CLOSE; 44 45 46 QUIT; RUN; 47
09-15-2017 12:59 PM
Sometimes providing full paths to external sources help.
I suspect that the /usr/bin is where the SAS server (?) code sets and without a path to the desired objects that is where it defaults to looking for things.
09-20-2017 08:27 AM
I have tried using the full paths, and the results are still the same.
It creates the output file, but it is empty.
I have even specified the location of the profilels file
x "/EIP/Software/Platform/lsf/conf/profile.lsf; lsid > /EIP/Data/Lev1/Data/ACE_ADM/SourceFiles/bacct_out.txt";