06-25-2018 05:51 PM
Hello All – We are using SAS VA 7.3 and want to know (as an Admin) how to start the LASR Servers after re-start of SAS Server and its services (SAS Services).
Here is my scenario:
We have an internal application which our operation staff using to run jobs, processes, scheduling different job flow through our company.
I have created an automated process to stop and start SAS services, this process will get called by our internal application in case of unexpected like power outage… this way all of SAS services will load in order.
I have also have a process in place which will load LASR tables. Both two above processes do work very well but one thing that I have not able to figure out is how to automate and start the LASR Server after SAS Services are started. If LASR Servers are not started the automated process could not load the tables into LASR. I am looking for a SAS script or something similar that I can place into a .bat file which can be called by our external tool right after all SAS Services are started. I will attach an image and much appreciated any feedback and help.
06-25-2018 11:14 PM
In your "internal application" which restarts the other SAS services, have you included a script to restart the LASR services?
cd SAS-config-dir/Levn/Applications/SASVisualAnalyticsX.X/ HighPerformanceConfiguration/LASRMonitor.sh restart
(This is a Linux command, but the same would apply for your Windows *.bat script)
You can also define certain LASR tables to "Reload-On-Start" so they are always available (once the LASR servers are up).
Is that what you are after, or is something more detailed?
06-26-2018 01:04 PM
Thank you to both of your @AndrewHowell and @alexal for your reply and info. @AndrewHowell I was able to branch to the folder but there the only file is there a .bat file which is empty, it just contains the some info text and that's all. Based on the SAS document I can't use the autoload to load database tables and that's what I am doing.
Autoload is not a universal method. You cannot autoload ZIP files, database tables, or data from Google Analytics, Facebook, or Twitter.
06-27-2018 12:02 AM
Autoload - correct: this is limited to SAS tables, CSV files & Excel spreadsheets.
To my knowledge, when installing a SAS platform, the deployment scripts create a range of customised site-specific "start" and "stop" script files, which should perform precisely what you are after. I'm concerned you might be asking us for generic solutions to a specific issue.
I suggest you discuss with whoever installed your SAS platform.
06-27-2018 01:01 AM
Agree @AndrewHowell, SAS did the install. I normally like the community first just in-case someone been through the same. I will post the result and my findings from SAS support.