topic Re: PROC SPDO is not working on SAS EG and Studio in Administration and Deployment

PROC SPDO is not working on SAS EG and Studio

Manoj07k — Wed, 09 Jun 2021 07:19:03 GMT

Guys , I'm trying to alter ACL of SPDS tables but PROC SPDO is not working on SAS EG and Studio.

The code doesn't give any error and no output as well. But, the same works well in server with sas -nodms.

SPD(LAX) 5.4 HF(3)

SAS 9.4 M6

Linux

Thanks,

Manoj

Re: PROC SPDO is not working on SAS EG and Studio

Kurt_Bremser — Wed, 09 Jun 2021 09:55:42 GMT

Please post the corresponding log segemnts from your interactive and batch runs.

Use the </> button to post the logs.

Re: PROC SPDO is not working on SAS EG and Studio

ChrisNZ — Thu, 10 Jun 2021 01:27:34 GMT

Maybe ask in the data mgt or admin forums?

Re: PROC SPDO is not working on SAS EG and Studio

LinusH — Thu, 10 Jun 2021 06:48:01 GMT

Perhaps you are using different config files.

Check what values you have for the MSG and PATH options when running EG/Studio, to verify that they include paths to your SPDS client.

Also check the spdsnsrv and spdsserv logs.

Re: PROC SPDO is not working on SAS EG and Studio

DavidHD — Thu, 10 Jun 2021 08:33:50 GMT

@Manoj07k I believe that in the libname statement you need aclspecial=yes and of course the user that you use to connect to the lib needs to be the same. When you connect using EG these might not be the same as on the server when you have pre-assigned libs.

Hope this helps,

David

Re: PROC SPDO is not working on SAS EG and Studio

Manoj07k — Thu, 10 Jun 2021 10:41:26 GMT

Thanks David.

I do use aclspecial=yes in libname statement. Please find the logs of server (nodms) and SAS Stuido.
Code:

LIBNAME &lib sasspds "&lib" HOST='localhost' Serv="5457" USER="&uid" PASSWORD="&psw" ACLSPECIAL=yes;
PROC SPDO LIB=&lib.;
SET ACLUSER spdsrvp;
LIST ACL _ALL_;
run;

At Server :

11?
NOTE: This is a SPD 5.4 (HF3) Engine
executing SAS (r) 9.4 (TS1M6) on the Linux platform.
NOTE: User spdsrvp(ACL Group ) connected to SPD(LAX) 5.4 HF(3) server at
10.5.134.44.
NOTE: Libref VNX_MIG1 was successfully assigned as follows:
Engine: SASSPDS
Physical Name: :20546/XXXXXXX/VNX_MIG1/

12?
NOTE: Enter "?;" to get info on all the SPDO commands.
Enter "SPDSMAC;" to get list and setting of all SPD macros.

13?
NOTE: Acluser has been set to SPDSRVP.

14?

The SAS System 1
Thursday, June 10, 2021 10:07:00 AM

ACL Info for *.DATA

Owner = SPDSRVP
Group =
Default Access (R,W,A,C) = (N,N,N,N)
Group Access (R,W,A,C) = (N,N,N,N)
User = AAAA, Access (R,W,A,C) = (Y,Y,Y,Y)
User = MMMMM, Access (R,W,A,C) = (Y,Y,Y,N)
User = FFFFF, Access (R,W,A,C) = (Y,Y,Y,N)
User = YYYY, Access (R,W,A,C) = (Y,Y,Y,N)
User = XXXX, Access (R,W,A,C) = (Y,Y,Y,N)

At SAS Stuido:

82 LIBNAME &lib sasspds "&lib" HOST='localhost' Serv="5457" USER="&uid" PASSWORD="&psw" ACLSPECIAL=yes;
NOTE: User spdsrvp(ACL Group ) connected to SPD(LAX) 5.4 HF(3) server at 10.5.134.46.
NOTE: Libref VNX_MIG1 was successfully assigned as follows:
Engine: SASSPDS
Physical Name: :6071/XXXXXXXX/VNX_MIG1/
83 PROC SPDO LIB=&lib.;
NOTE: Enter "?;" to get info on all the SPDO commands.
Enter "SPDSMAC;" to get list and setting of all SPD macros.
84 SET ACLUSER spdsrvp;
NOTE: Acluser has been set to SPDSRVP.
85 LIST ACL _ALL_;
86 run;

87

Re: PROC SPDO is not working on SAS EG and Studio

Manoj07k — Thu, 10 Jun 2021 10:37:22 GMT

Hi , Just checked the MSG and PATH it was same at server and in Studio :

MSGPATH=$SASHOME/grid_binaries/SASFoundation/9.4/misc/tkspddrv
PATH=$SASINSTALL/scripts:$SASHOME/spds_binaries/SASScalablePerformanceDataServer/5.4/bin:/bin:$SASHOME/grid_binaries/Secure/sasexe:$SASROOT/pm/10.2/bin:$SASROOT/pm/10.2/linux2.6-glibc2.3-x86_64/bin:$SASROOT/lsf/10.1/linux2.6-glibc2.3-x86_64/etc:$SASROOT/lsf/10.1/linux2.6-glibc2.3-x86_64/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/bin

Re: PROC SPDO is not working on SAS EG and Studio

Manoj07k — Thu, 10 Jun 2021 10:40:35 GMT

<
LIBNAME &lib sasspds "&lib" HOST='localhost' Serv="5457" USER="&uid" PASSWORD="&psw" ACLSPECIAL=yes;
PROC SPDO LIB=&lib.;
SET ACLUSER spdsrvp;
LIST ACL _ALL_;
run;

At Server :

11?
NOTE: This is a SPD 5.4 (HF3) Engine
executing SAS (r) 9.4 (TS1M6) on the Linux platform.
NOTE: User spdsrvp(ACL Group ) connected to SPD(LAX) 5.4 HF(3) server at
10.5.134.44.
NOTE: Libref VNX_MIG1 was successfully assigned as follows:
Engine: SASSPDS
Physical Name: :20546/XXXXXXX/VNX_MIG1/

12?
NOTE: Enter "?;" to get info on all the SPDO commands.
Enter "SPDSMAC;" to get list and setting of all SPD macros.

13?
NOTE: Acluser has been set to SPDSRVP.

14?

The SAS System 1
Thursday, June 10, 2021 10:07:00 AM

ACL Info for *.DATA

Owner = SPDSRVP
Group =
Default Access (R,W,A,C) = (N,N,N,N)
Group Access (R,W,A,C) = (N,N,N,N)
User = AAAA, Access (R,W,A,C) = (Y,Y,Y,Y)
User = MMMMM, Access (R,W,A,C) = (Y,Y,Y,N)
User = FFFFF, Access (R,W,A,C) = (Y,Y,Y,N)
User = YYYY, Access (R,W,A,C) = (Y,Y,Y,N)
User = XXXX, Access (R,W,A,C) = (Y,Y,Y,N)

At SAS Stuido:

82 LIBNAME &lib sasspds "&lib" HOST='localhost' Serv="5457" USER="&uid" PASSWORD="&psw" ACLSPECIAL=yes;
NOTE: User spdsrvp(ACL Group ) connected to SPD(LAX) 5.4 HF(3) server at 10.5.134.46.
NOTE: Libref VNX_MIG1 was successfully assigned as follows:
Engine: SASSPDS
Physical Name: :6071/XXXXXXXX/VNX_MIG1/
83 PROC SPDO LIB=&lib.;
NOTE: Enter "?;" to get info on all the SPDO commands.
Enter "SPDSMAC;" to get list and setting of all SPD macros.
84 SET ACLUSER spdsrvp;
NOTE: Acluser has been set to SPDSRVP.
85 LIST ACL _ALL_;
86 run;

87
>