If a memory-related error is returned during the execution of PROC OLAP, you should first determine whether an appropriate amount of memory has been allocated to the SAS process that is executing the step. If you are building your cube from within SAS^® OLAP Cube Studio, then you are using one of the workspace server instances defined to your SAS BI environment. To increase the memory for this server, modify your SAS command line, which is specified in the Options tab of your workspace server within SAS^® Management Console:

1. Expand Server Manager and then navigate down to your logical workspace server.
2. Right-click on the logical workspace server name and select Properties.
3. Select the Options tab and then specify the necessary memory options, which are -MEMSIZE, -REALMEMSIZE and -SUMSIZE.
4. It may be necessary to restart your SAS Object Spawner in order to create new workspace server sessions with these settings.

• -MEMSIZE describes how much memory the SAS process can acquire during its execution. This includes both the physical RAM as well as any virtual memory available on the machine.
• -REALMEMSIZE and -SUMSIZE should be used to limit how much physical RAM is used by the process. This is especially important on 32-bit machines when the -MEMSIZE option is set to 2 gigabytes. In those cases, -REALMEMSIZE and -SUMSIZE should not be set higher than 1.3 gigabytes in order to restrain the process from trying to acquire more memory than it can successfully read.

Here are examples of the possible error messages:

Critical memory shortage occurred while extending a crossing table

No memory can be allocated

The requested function cannot be performed. Memory is exhausted.

Operating System and Release Information