topic Re: SASEG | Stored Process Log in Administration and Deployment

SASEG | Stored Process Log

MariaD — Tue, 15 Sep 2020 02:11:51 GMT

Hi folks,

I have a stored process that users access and run through SAS EG. I need to review the log of the execution but every time show me an empty log.

I tried to execute first MPRINT SYMBOLGEN MLOGIC but nothing. Also, I tried to use _debug=log or _debug=trace, but nothing happens.

I need the log to verify why the following error occurs. Any idea?

Re: SASEG | Stored Process Log

AnandVyas — Tue, 15 Sep 2020 04:13:49 GMT

Hi @MariaD

Has this ever worked before? Is the result capabilities set as stream or package? Is the server log enabled for STP and does it log anything on the server?

Re: SASEG | Stored Process Log

andreas_lds — Tue, 15 Sep 2020 04:52:33 GMT

The stored process must return a result package to be used in Enterprise Guide, check that using smc.

Re: SASEG | Stored Process Log

JuanS_OCS — Tue, 15 Sep 2020 10:26:04 GMT

Hello @MariaD ,

I fully agree with the suggestions provided by @AnandVyas and @andreas_lds ! When you are testing a Stored Process the way that you deliver the output is very important. SAS EG does not interpret the outputs as a Web Application, for instance. The error message about BEGIN / END are clear.

I would give a read to some documents:

https://www.lexjansen.com/nesug/nesug09/hw/HW06.pdf

https://support.sas.com/resources/papers/proceedings/proceedings/forum2007/218-2007.pdf

https://support.sas.com/resources/papers/proceedings/proceedings/sugi31/258-31.pdf

I would also enable the SAS EG logging https://support.sas.com/kb/55/414.html and I would check at the SAS Stored Process Server logs in the server itself, for more information.

Best regards,

Juan

Re: SASEG | Stored Process Log

MariaD — Tue, 15 Sep 2020 10:29:02 GMT

Thanks, @andreas_lds The stored process has steam and package as result capabilities.

Regards,