BookmarkSubscribeRSS Feed
woo
Lapis Lazuli | Level 10 woo
Lapis Lazuli | Level 10

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

Innovate_SAS_Blue.png

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. 

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
  • 461 views
  • 0 likes
  • 2 in conversation