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
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.