OLAP Exception: Insufficient Memory

[Carlos_M]

Hello,

The following message rises when I try to open OLAP cubes in Enterprise Guide and Web Report Studio:

Web: Error Accessing the Report (Could not retrieve data)
Insufficient memory

EG: (...)Insufficient Memory(...)

Can someone help?

[Andrea_SAS]

Hi Carlos, the default memory limit for olap server (memsize) is 512 megs.
If your olap server is running on windows look for the file sasv9_OLAPServer.cfg and increase the memsize setting from 512m to 1024m (1 gig).
Example:
you find: -memsize 512m
you change in: -memsize 1024m
You must restart the olap server service (on win) to force the new value for memsize.
If this doesn't solve your problem, please contact SAS Tecnical Support.
Regards.

Andrea

[deleted_user]

Hi Andrea,

the same problem i am also facing,

But my olap server is running on unix environment.

Can someone help?

Regs
Rajha

[sbb]

Please - start a new thread and if necessary provide (PASTE into your post) a reference to the prior thread. Essentially you are not replying to this thread but you are voicing your own new thread with similarity to the prior one.

Scott Barry
SBBWorks, Inc.

[deleted_user]

thanks

i will start a new thread.

[Carlos_M]

Thanks Andrea,

The simple restart of the OLAP server solved the problem. Meanwhile I applied the 1024 mem configuration, in the hope that this problem stops occurring.

Regards