BookmarkSubscribeRSS Feed
woo
Barite | Level 11 woo
Barite | Level 11

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

 

1 REPLY 1
Madelyn_SAS
SAS Super FREQ

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...


 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 1 reply
  • 578 views
  • 0 likes
  • 2 in conversation