topic Re: Error while running a stored process in Developers

Error while running a stored process

Abhijit92Das02 — Mon, 15 Feb 2016 10:49:20 GMT

Hi All,

I am persistently getting an error while trying to run my Stored process -

Error - An error occurred executing the stored process job "<Stored Process name>".The stored process library failed to retrieve the result.This stored process does not appear to have generated a result package.Are %STPBEGIN/%STPEND used in the stored process?Did the stored process run without errors?

Can anybody suggest possible fix for this.

Re: Error while running a stored process

Timmy2383 — Mon, 15 Feb 2016 12:28:19 GMT

It looks like it might be expecting a Package result. Is that actually what you intend? What kind of output is it supposed to generate? If just ODS output of some kind then try having "streaming" results checked instead of "package" in you stored process options.

Also, if this stored process is meant to be run just within EG then uncheck the option to "append %STPBEGIN and %STPEND macros".

Re: Error while running a stored process

sabid — Tue, 17 Dec 2019 14:36:16 GMT

Hi.. I am having this error as well. Our project is created and then consumed through a SAS web portal. Also, where do I make the changes described here? In the EG file

Thanks!