I have a stored process with a dynamic prompt created from a file in LIB BG3X00.
Process works great in Enterprise Guide.
When deployed to the portal, however, I get an error message LIBREF not assigned. (see attachments)
I have the libname explicitly in my stored process but I think the prompts are executing BEFORE the libname statement.
If I'm right, how do I correct?
I had a similar problem for stored processes that are spawning using the Stored Process Server under the SAS General Servers account (instead of Workspace Servers under user's ID). If I recall correctly, I had to 1) make sure the SAS General Servers account had permissions on the library and 2) restart Object Spawners.
To further elaborate on @Timmy2383:
The SAS General Servers is not a user account in SAS metadata, it is a group account. But it is connected to the operating system user account sassrv, which is used to run pooled servers (that includes the STP server).
So you have to make sure that SAS General Servers as a group has Authorization for the library in SAS metadata, and that sassrv as a user has the necessary operating system permissions (read and execute) on the directory and its contents.
Hi! I suspect I'm having the same issue. What are the permissions required for the SAS General Servers group on the library and members?
I gave that group ReadMetadata and Read to both library and member, restarted the object spawner (on SASApp WS Server) and nothing changed.
Are things different for an DBMS library?
Just dawned on me that the SAS General Servers group was not a member of the group with the Oracle account defined...
I even removed the explicit permissions to the library and table in metadata and it works after restarting the ObjectSpawner.
Thanks for the help here!
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.