while executing the SAS code from the SAS enterprise Guide, I am unable to execute using the SAS workspace server. Checked the Object Spawner log, there is no issue in the log .
The same code has been tried using the SAS Stored process server and it has been executed.
So , please help me to understand how this has been happened.
When a code is executed by the workspace server, it uses the users credentials. Therefore this account must exist on the OS level . Make sure the Id you are using to log in to SAS EG and execute stored process on Workspace server exists in the OS and has necessary privileges in SAS. As a corollary one should not use SAS internal accounts to execute code on the workspace server.
The stored process on stored processes server typically executes with sassrv account and it is sufficient if the user exists in the SAS Metadata and has Read metadata access to the stored process folder.
Therefore as a first step check for the existence and provisioning of necessary privileges of the account.
The SAS Administrator should be the first person to reach out to in this type of cases.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.