BookmarkSubscribeRSS Feed
MariaD
Barite | Level 11

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?

 

Screen Shot 2020-09-14 at 23.10.11.jpg

 

4 REPLIES 4
AnandVyas
Ammonite | Level 13

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
Jade | Level 19

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

MariaD
Barite | Level 11

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

 

Regards,

JuanS_OCS
Amethyst | Level 16

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 756 views
  • 3 likes
  • 4 in conversation