10-26-2012 12:54 PM
Could anyone explain the meaning of the following SAS option part for me? special for "no$stsuffix"
options sastrace = ',,,sd' sastraceloc = saslog no$stsuffix
10-26-2012 01:43 PM
Funny, I've been using that today to try to diagnose some Oracle query nightmares.
Looks like it's documented with sastrace:
10-26-2012 02:45 PM
In this case the nightmares started before I added STRACE. I have a simple join that is running in a stored process. Reading data from an oracle database, using a libref defined in the metadata that uses SAS/ACCESS to Oracle.
The stored process ran fine a week ago. Now the join is crashing a "call tech support" segmentation error.
It's very much like http://support.sas.com/kb/20/460.html but I'm not using views (and I'm on 9.3).
What's driving me crazy is that it worked last week. And now the join works if I run it from EG, works if I batch submit it , and works if I run the stored process on the workspace server. So I think I'm going to have to ask the admin to just restart the stored process server, and see if that helps...