Traditional web-based reporting with SAS BI tools

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

Reply
Occasional Learner
Posts: 1

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

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!!

 

Stored_Process_SAS_SMC.png

 

 

Stored_Process_SAS_WRS_Error.png


Stored_Process_SAS_WRS_Error.png
Super User
Posts: 5,437

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

Posted in reply to NarasimhaS

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.

Data never sleeps
SAS Super FREQ
Posts: 480

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

Posted in reply to NarasimhaS

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

 

 

Ask a Question
Discussion stats
  • 2 replies
  • 193 views
  • 2 likes
  • 3 in conversation