topic Able to execute the code in Stored process server but not in workspace server in Administration and Deployment

Able to execute the code in Stored process server but not in workspace server

siddhu1 — Fri, 17 Sep 2021 15:19:51 GMT

Hi,

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.

Kind Regards,
Sid

Re: Able to execute the code in Stored process server but not in workspace server

gwootton — Fri, 17 Sep 2021 17:58:26 GMT

Are you using Enterprise Guide to submit both to the Stored Process Server and Workspace Server? Is Enterprise Guide returning any error?

Re: Able to execute the code in Stored process server but not in workspace server

siddhu1 — Mon, 20 Sep 2021 10:34:28 GMT

I am using the SAS Enterprise Guide for both the servers, but there was no error.

I didn't understand why it has ran on Stored process server but not on workspace server.

Thanks,

Siddhartha

Re: Able to execute the code in Stored process server but not in workspace server

gwootton — Mon, 20 Sep 2021 12:20:29 GMT

What happens when you try to execute code on the workspace server?

Re: Able to execute the code in Stored process server but not in workspace server

Jackie_sas — Mon, 20 Sep 2021 16:32:17 GMT

Check the properties of the stored process to see if the server type is set to execute only on the stored process server. You can do this in SAS Management Console. Open the properties and click on the Execution tab. The Server type option specifies what type of server will run that stored process. When it is set to Default server, Enterprise Guide will run the stored process on a workspace server.

Re: Able to execute the code in Stored process server but not in workspace server

Sajid01 — Tue, 21 Sep 2021 12:03:01 GMT

Hello @siddhu1

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.