SAS VA Autoload insufficient memory error for large tables

woo — Wed, 24 Nov 2021 19:13:35 GMT

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

Re: SAS VA Autoload insufficient memory error for large tables

Madelyn_SAS — Tue, 01 Feb 2022 18:42:54 GMT

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#n1837d572wne1xn1rha88n17apiw

topic Re: SAS VA Autoload insufficient memory error for large tables in SAS Visual Analytics

SAS VA Autoload insufficient memory error for large tables

Re: SAS VA Autoload insufficient memory error for large tables