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>
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>
To resolve that specific issue, you need to do the following things:
a) Before you do any modification, please ensure to take proper backup of that specific file <SASHome>\SASFoundation\9.4\nls\en\sasv9.cfg
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.
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.
Analytiks International Inc
4826 Chicago Ave S, Suite 102
Minneapolis, MN 55417