SASEG | Stored Process Log

[MariaD]

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?

[Anand_V]

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? 

[andreas_lds]

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

[MariaD]

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

Regards,

[JuanS_OCS]

Hello @MariaD ,

I fully agree with the suggestions provided by @Anand_V 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