SAS Tips

This error message occurs mainly when available resources on the SAS server are not enough to handle the specific request.

Errors in the EG log look like this:

ERROR SAS.Shared.Exceptions.ServerExceptionHelper [(null)] – MapException() – Mapping error for:

System.OutOfMemoryException: <?xml version=”1.0″ ?><Exceptions><Exception><SASMessage severity=”Error”>Request failed due to an exception.</SASMessage></Exception></Exceptions>

Or

WARN  SAS.EG.JobManagement.WorkspaceJob [(null)] – OnExecuting() – Recoverable SAS error has been caught

SAS.Shared.Exceptions.ServerOperationException: Integration technologies failed to retrieve the log. [Error] Invalid memory handle —> System.Runtime.InteropServices.COMException: <?xml version=”1.0″ ?><Exceptions><Exception><SASMessage severity=”Error”>Invalid memory handle</SASMessage></Exception></Exceptions>

Resolution:

To resolve that specific issue, you need to do the following things:

1. Increase MEMSIZE to 8G & SORTSIZE to 2G in SAS configuration files.

   a) Before you do any modification, please ensure to take proper backup of that specific file <SASHome>\SASFoundation\9.4\nls\en\sasv9.cfg
   i.e.
   locate MEMSIZE and SORTSIZE options, the default value of MEMSIZE is 2G and SORTSIZE is 1G

   b) Second, configuration file is present under <SAS-Config>\Lev1\SASApp\sasv9_usermods.cfg before you do any modification, please take proper backup of this file, and add these options there.
   i.e.
   MEMSIZE 8G
   SORTSIZE 2G

   Please launch SAS EG and try to run same SAS program again this time you will not get this sort of error if you get this error msg again then please try to use these options MEMSIZE 16G and SORTSIZE 2G in both configuration files those mentioned above. Basically, you’re doing benchmarking if any of this value option or custom option will work, please try to use those options for future SAS programs.