BookmarkSubscribeRSS Feed
MALIGHT
Fluorite | Level 6

While developing new reports and dashboards in VA, we set our AUTOLOAD process on our Linux o/s to occur
every 5 minutes for expediency.  We have recently attempted to Autoload tables that are so large that it appears
the first attempt to load them begins but they do not finish loading within 5 minutes when the next AUTOLOAD
cycle kicks off. What is the expected behavior in this situation? Does the failure to load the first time prevent the
Autoloader from attempting again, unless the table's timestamp is updated? Or does the AUTOLOADer continue to
work on loading the original table in the background, not attempting a new load despite the AUTOLOAD process
kicking off every 5 minutes, and will eventually complete. We've seen what looks like the 2nd scenario happen in a few
situations, but the Autoloader.sas7bdat file which is a log of the Autoloader attempts shows no indication of the table
loading in background. We just eventually notice the table appeared when viewing Manage Environment in VA.

3 REPLIES 3
ChrisHemedinger
Community Manager

HI Marty,

I *think* that when an AUTOLOAD is in process, a marker file (autoload.pid) is put in place in the scripts directory to serves as a cue that another autoload operation should not kick off.  Someone else with more SAS Visual Analytics admin experience can surely embellish/correct my answer here, but basically the AUTOLOAD is designed to not "re-enter" when there is an ongoing AUTOLOAD.

Chris

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
MALIGHT
Fluorite | Level 6

Thanks Chris! Since no one else has responded, I may go ahead and open a Tech Support track for this one. 

AnnaBrown
Community Manager

It know it's been a while, MALIGHTbut maybe this video will help: Implementing Automatic Loading of Data to Memory in a Windows Environment.

 

 

 


Join us for SAS Community Trivia
SAS Bowl XXIX, The SAS Hackathon
Wednesday, March 8, 2023, at 10 AM ET | #SASBowl

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1252 views
  • 0 likes
  • 3 in conversation