What will prevent a Stored Process from running in Web Report Studio?

[deleted_user]

Just wondering, and hope someone can drop some hints? What types of things will keep a stored process that runs just fine in EG from running in WRS? I just made a simple SP that works great in EG, but dies in WRS. What types of things should I be on the lookout for?

Thanks so much!

[Cynthia_sas]

If you use any Javascript keywords or built in function names, like VAR, CLASS, DO, ELSE, THROW, DATE, MATH, STRING, OBJECT, NULL, CONST, CASE, NEW, TRY, VOID, WHILE, SUPER, FOR, etc. as parameter/macro variable names, this can cause you to get an "error on page". The stored process may work in EG or the SAS Add-in for Office but it might fail in other clients like WRS or the Portal.
http://support.sas.com/techsup/unotes/SN/018/018502.html

Also, if your stored process is running PROC REPORT and has LINE statements -- the SP will work fine in the other clients, generally, but not in WRS -- most times, you won't see any output at all. A few times, I got a Java exception when I tried this.

And if your SP is using FILE/PUT statements to _WEBOUT, you might have problems:
http://support.sas.com/techsup/unotes/SN/013/013599.html
http://support.sas.com/techsup/unotes/SN/019/019063.html
http://support.sas.com/faq/039/FAQ03934.html

Other possibilities:
http://support.sas.com/techsup/unotes/SN/018/018214.html (your SP might contain < or > tags)
http://support.sas.com/techsup/unotes/SN/016/016056.html (stray & might cause problems -- there's a hot fix for this -- but I'd check with Tech Support first or your Administrator to see if the hot fix has already been applied)
http://support.sas.com/techsup/unotes/SN/020/020225.html (you see an empty row of cells)
http://support.sas.com/techsup/unotes/SN/020/020798.html (call define with style on _ROW_ might not be respected)
http://support.sas.com/techsup/unotes/SN/019/019980.html (SP with style(data) -- generally PROC PRINT)

To find most of these hits, I went to:
http://support.sas.com/techsup and entered this text into the search box:
stored process fail Web Report Studio

Your best bet for a quick response is to contact Tech Support for help and to find out how to turn on and check the log for your SP execution.

cynthia

[deleted_user]

Quite a lot of information!! Thank you SO much... in my case, most likely it's the & issue somewhere in my code, and that's the path I intend to follow and check out.

Thanks!!