topic Re: SQL DB Libraries viewable in SMC but not EG in Administration and Deployment

SQL DB Libraries viewable in SMC but not EG

shoin — Wed, 13 Oct 2021 04:40:47 GMT

Environment:

SAS 9.4 TS1M7 WIN server, 3 machine plus clients

Two non-preassigned sql DB libraries that are using a service ID and PWD for connecting to sql db. A SQLAuth was established, and a group was set sql_users_grp and login was assigned to it.

Issue:

EG those two libraries do not appear for one end user, userX

Troubleshooting and Checks:

UserX could see the said 2 sql DB libraries in SMC
UserX could run a libname statement and establishes connection, all registered tables appear in an EG session, table could be selected and loaded.
There is no Extended attribute defined
UserX is member of the sql_users_grp
SAS Folder location both have sql_users_grp added and have RM, R, W, WMM
SQL Libraries themselves have RM, R, W, WMM for the sql_users_grp and SASUSERS has RM,R
Workspace server, STP, Pooled WSS all have SASUSERS appropriate permission
In SAS EG, all default SASApp-* data libraries, SASHELP, WRSTEMP, etc. all libraries appear, except the two SQL DB libraries.
Checked AD group membership, UID verification all access is as expected
This user except some CI admin access has the same group membership as I (author) have, I have no issue viewing the two SQL DB libraries in SMC and EG.
Access to the two DB schemas was verified.

Stumped why these two libraries not appear in SAS EG session, however they are accessible via libname statement, in SMC (same user) ... 🤔

Thank you in advance,

Re: SQL DB Libraries viewable in SMC but not EG

SASKiwi — Wed, 13 Oct 2021 05:32:01 GMT

Please post the LIBNAME statement that works. There must be some difference between that and how you are defining the same library in SMC.

Re: SQL DB Libraries viewable in SMC but not EG

Jackie_sas — Wed, 13 Oct 2021 20:16:27 GMT

Check the Assign tab of the library properties in SAS Management Console and make sure a server is assigned. This makes the library available to the server and makes the library visible to users of the server. Enterprise Guide only shows libraries that are assigned to the server. Even though SAS Management Console says the is assignment is optional, it is recommended to always assign a server to a library.

Re: SQL DB Libraries viewable in SMC but not EG

shoin — Thu, 21 Oct 2021 16:14:41 GMT

We used the DISPLAY LIBNAME value copied it and ran in a BASE editor session as well as EG session.

Re: SQL DB Libraries viewable in SMC but not EG

shoin — Thu, 21 Oct 2021 16:15:05 GMT

SASApp server is assigned.

Re: SQL DB Libraries viewable in SMC but not EG

shoin — Thu, 21 Oct 2021 18:46:52 GMT

Update

I enabled the EG Client side log. I see that the EG routine finds these libraries but then they do not appear for this user. I hope somehow Chris H. gets to see this
--- begin ---
2021-10-21 12:58:42,888 [9] DEBUG SAS.EG.SDS.Model.SDSCollectionBase [(null)] - SDS-START:100012:Obj 179:DoClear():SDSCollectionBase.cs@365: Clearing collection: [Collection 'Libraries', Item Type = 'SAS.EG.SDS.Model.Library', ObjectID =179], Events = False, itemType = SAS.EG.SDS.Model.Library, Status is Populated
2021-10-21 12:58:42,889 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-START:100013:Obj 235:ClearWithoutEvents():LibraryState.cs@859: Clear library 'CIExports'
2021-10-21 12:58:42,890 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-LOG :Obj 235:ClearWithoutEvents():LibraryState.cs@864: Clearing all AssignedStateMap entries for library CIExports.
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-START:100014:Obj 235:ClearWithoutEvents():LibraryState.cs@866: AssignedStateMap: In Use: Iterate over collection and use each entry.
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-LOG :Obj 235:ClearWithoutEvents():LibraryState.cs@870: Clearing datasets collection objID=237
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.SDSCollectionBase [(null)] - SDS-START:100015:Obj 237:DoClear():SDSCollectionBase.cs@365: Clearing collection: [Collection 'Datasets', Item Type = 'SAS.EG.SDS.Model.Dataset', ObjectID =237], Events = False, itemType = SAS.EG.SDS.Model.Dataset, Status is NotPopulated
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.SDSCollectionBase [(null)] - SDS-END :100015:Obj 237:DoClear()
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-END :100014:Obj 235:ClearWithoutEvents()
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-END :100013:Obj 235:ClearWithoutEvents()
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-START:100016:Obj 231:ClearWithoutEvents():LibraryState.cs@859: Clear library 'CISQLJDE'
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-LOG :Obj 231:ClearWithoutEvents():LibraryState.cs@864: Clearing all AssignedStateMap entries for library CISQLJDE.
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-START:100017:Obj 231:ClearWithoutEvents():LibraryState.cs@866: AssignedStateMap: In Use: Iterate over collection and use each entry.
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-END :100017:Obj 231:ClearWithoutEvents()
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-END :100016:Obj 231:ClearWithoutEvents()
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-START:100018:Obj 233:ClearWithoutEvents():LibraryState.cs@859: Clear library 'CISQLMCD'
2021-10-21 12:58:42,891 [9] DEBUG SAS.EG.SDS.Model.LibraryState [(null)] - SDS-LOG :Obj 233:ClearWithoutEvents():LibraryState.cs@864: Clearing all AssignedStateMap entries for library CISQLMCD.

Re: SQL DB Libraries viewable in SMC but not EG

SASKiwi — Thu, 21 Oct 2021 18:57:33 GMT

But what was the outcome? We can't help you if you say you did something without posting the result.

Please post the SAS log of the LIBNAME you ran. Also if it assigned without any error, post a screenshot of the EG Server list window showing the created library in expanded mode.