07-21-2016 10:18 PM
07-22-2016 01:33 AM
What exactly have you tried already that caused the freezes?
(which files were changed, what options were set etc)
07-22-2016 09:51 AM
We have tried to inject the parameter before the sas command that gets executed on SAS EG Launch. We also tried to put it in !SASROOT/sasv9.cfg and !SASROOT/sasv9_local.cfg. Both dont seem to work when we tried to have it launch EG and connect into the Grid, which as I understand it is when the Workspace Server is being launched by the GRID.
07-22-2016 03:23 AM
I'm curious to know what the purpose is of trying to collect all SAS session logs? If it is for tracking what products and procedures are being run then this can be done more easily using SAS Environment Manager monitoring and the same tool is good for performance monitoring too.
07-22-2016 09:53 AM
We have an Audit, Compliance, and Regulatory requirement to begin tracking, quite literally, everything in our SAS Environment that is running. The Requirement is more granular than aggregates surrounding PROC's and SAS Products, that we do have and get from Environment Manager.
07-22-2016 09:47 AM
I am almost certain that the freeze is caused by the ALTLOG option that's being enabled for your environment.
Do you have the Workspace Server log enabled?
Especially the Workspace Server might cause problems as it writes a single log for each user. Given that, plus an option to "copy" a dup of logs somewhere, might be too much for the resources you have, the resources SAS uses.
Going in the opposite direction, if the ALTLOG is set up for the SAS Servers, yet the Workspace Server log is not enabled, it might run
indefinitely, trying to find the Workspace Server log. Other log files are enabled per default, which is why I am highlighting the WS log.
As mentioned in a post earlier, one way to go would be using the Environment Manager:
What is Environment Manager:
Using the Report Center:
Take a look at the reporting, one of the features provided by Environment Manager, to see which objects, items and resources you can
report on, and monitor. It is a great tool!
There is an Ask the Expert recording and upcoming sessions for Environment Manager,
see http://support.sas.com/training/askexpert.html, under Administration.
Aside from Env Manager, here is a blog that talks about logging events
Hope this helps.
07-22-2016 10:47 AM
So our workspace servers are grid launched, and the logs are enabled, we havent turned on TRACE yet but that is my next step to see what TRACE will tell us, but in the standard logging configuration we havent been able to see that the workspace server was even launched. We get this error in EG
[Error] Failed to start the server.
[Error] The launch of server SASApp - Workspace Server for user <XXXXXX> failed.
07-22-2016 11:06 AM
Do you get this error when logging on, or, when users submit jobs? Does that happen for every user?
Could you provide a screenshot of this error message? Also, did you check the Metadata Server log and Object Spawner
log? There is most likely more info that'll help to troubleshoot.
Did you run into these problems before using the ALTLOG option, meaning, did this ever work before?
Also, are you on 9.4, and, would Environment Manager be an option? It would nicely provide what you are looking for.
07-27-2016 12:06 PM
We are using SASV9_OPTIONS to make sure that altlog is recorded across the Grid environment. Since this option is set in UNIX/LINUX we can make sure we have what we need to make the log collision proof accross the cluster.
Since some sessions are logged and others arent under Grid-Launched Workspace Servers using -ALTLOG we are using the Environment Manager Postgres instance to our advantage to record and reconcile instances of each type of session so that we can track what is being done in the environement at all times.
The default sas executable at !SASROOT/sas has been modified to accomodate these changes and log all uses of that executable.
07-27-2016 03:55 PM
Good to see you found a solution.
Personally I think your audit requirement is way over the top. I can understand doing this for business-critical processes but for every SAS job?! I guess you are now going to have fun managing potentially hundreds of SAS log files being generated each day...I hope you don't have to analyse all these.
07-27-2016 04:10 PM
We have Python code that reassembles the SAS code and does analysis on what it is doing. We previoulsy used a similar situation to parse our RTrace logs in an old environment.
As far as management is concerned, the logs are centrally located and reconciled to our Hadoop environment so that we can catalog and parse them at will. The high compression ratio of the logs has made them extremely easy to store and rextract into files that the Python code can then mine.