How to enable the running of LSF B commands within a SAS front-end application like Enterprise Guide

ruanmet — Fri, 15 Sep 2017 10:20:30 GMT

Greetings all

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

Thanks

Ruan

Re: How to enable the running of LSF B commands within a SAS front-end application like Enterprise G

ballardw — Fri, 15 Sep 2017 16:59:47 GMT

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.

Re: How to enable the running of LSF B commands within a SAS front-end application like Enterprise G

ruanmet — Wed, 20 Sep 2017 12:27:16 GMT

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

data _null_;
x "/EIP/Software/Platform/lsf/conf/profile.lsf; lsid > /EIP/Data/Lev1/Data/ACE_ADM/SourceFiles/bacct_out.txt";
run;

topic Re: How to enable the running of LSF B commands within a SAS front-end application like Enterprise G in SAS Programming

How to enable the running of LSF B commands within a SAS front-end application like Enterprise Guide

Re: How to enable the running of LSF B commands within a SAS front-end application like Enterprise G

Re: How to enable the running of LSF B commands within a SAS front-end application like Enterprise G