PROC SPDO is not working on SAS EG and Studio

[Manoj07k]

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

[Kurt_Bremser]

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

Use the </> button to post the logs.

[Manoj07k]

<
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
>

[ChrisNZ]

Maybe ask in the data mgt or admin forums?

[LinusH]

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.

[Manoj07k]

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

[DavidHD]

@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

[Manoj07k]

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