We are using SAS VA 7.5 (non-distributed) and have autoload in place to load the table on Linux. Smaller tables are loading fine vs large tables having "Insufficient resources to perform the operation" + "sas system stopped processing this step because of insufficient memory" error.
SAS VA Linux machine has total of 94 gb RAM
workspaceserver_usermods.sh for SASAppVA server has
USERMODS_OPTIONS="-memsize 0 -cpucount ACTUAL"
va.AuditingEnabled is "false" for Visual Analytics 7.5 definition underneath "SAS Application Infrastructure" Advance settings.
From autoload job log,
When it complains about insufficient resource for ~4 gb table, details is as below,
real time 5.71 sec
user cpu time 1.51 sec
system cpu time .59 sec
memory 6266.09k
OS memory 20648.00k
page fault 0
page reclaims 2903
page swaps 0
Vol. context switches 1133
Invol. context switches 1
block input operations 0
block output operations 240
Is this only a problem when the table is autoloaded? In other words, can you manually load the 4GB table using Visual Analytics Administrator?
If the problem is only autoload, you might neet to set MEMSIZE 0 in the config file specifically for autoload.
https://go.documentation.sas.com/doc/en/bicdc/9.4/vaag/n0nm6qjzfz4eban1237qqrcmxz0j.htm#n1837d572wne...
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.