topic SAS Code runs on Workspace Server but not on Stored Process Server in SAS Programming

SAS Code runs on Workspace Server but not on Stored Process Server

Aasth — Mon, 25 Feb 2019 20:32:32 GMT

Hi everyone,

I have a sas code that works well in the SAS workspace server but it cannot populate data on the tables when ran from the stored process server. It is the same code with the same username and password hard-coded for the sas db2 connection? Can anyone help me with this issue?

Re: SAS Code runs on Workspace Server but not on Stored Process Server

VDD — Mon, 25 Feb 2019 20:59:09 GMT

Does the server have DB2 installed?

or is the DB2 installed on your workstation and that is why it works!!!!

Re: SAS Code runs on Workspace Server but not on Stored Process Server

Aasth — Mon, 25 Feb 2019 21:13:22 GMT

Yes the server has DB2 installed and also DB2 is installed on my workstation. Other programs run its just this one thats not running

Re: SAS Code runs on Workspace Server but not on Stored Process Server

SASKiwi — Mon, 25 Feb 2019 21:31:21 GMT

Please post your Stored Process server SAS log for the program.

Re: SAS Code runs on Workspace Server but not on Stored Process Server

Aasth — Tue, 26 Feb 2019 15:17:17 GMT

I have attached a snip of the error . The username and password for making db connection is the same as it's the same program that runs in Workspace server.