topic Re: OLAP Exception: Insufficient Memory in SAS Enterprise Guide

OLAP Exception: Insufficient Memory

Carlos_M — Tue, 19 Aug 2008 08:44:02 GMT

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?

Re: OLAP Exception: Insufficient Memory

Andrea_SAS — Tue, 19 Aug 2008 16:18:09 GMT

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

Re: OLAP Exception: Insufficient Memory

Carlos_M — Wed, 20 Aug 2008 11:07:13 GMT

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

Re: OLAP Exception: Insufficient Memory

deleted_user — Thu, 20 Aug 2009 06:49:39 GMT

Hi Andrea,

the same problem i am also facing,

But my olap server is running on unix environment.

Can someone help?

Regs
Rajha

Re: OLAP Exception: Insufficient Memory

sbb — Thu, 20 Aug 2009 14:36:59 GMT

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.

Re: OLAP Exception: Insufficient Memory

deleted_user — Fri, 21 Aug 2009 11:29:33 GMT

thanks

i will start a new thread.