How can I run the Stored Process successfully in SAS Web Report Studio?

[NarasimhaS]

Hi All,

I have created the Stored process by including some Prompts in SAS Management console and set the options of the servers as shown in below first screen and when I try to execute it in SAS WRS then I getting error shown in the second screen.

Can anyone help me how can I get rid of this error? Much appriciate your help!!

[LinusH]

Been quite awhile since I worked with WRS, so I could be out of bounds here.

But WRS i default executing on a pooled WS server. So I would start with to change the server option to "Default".

Another thing to look at is metadata authorization.

[Madelyn_SAS]

The most likely reason why the stored process fails is that you do not have Package output selected. SAS Web Report Studio does not support Streaming stored processes.

I also recommend that you review this SAS note:

http://support.sas.com/kb/47/839.html