Desktop productivity for business analysts and programmers

OLAP Exception: Insufficient Memory

Reply
New Contributor
Posts: 2

OLAP Exception: Insufficient Memory

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?
SAS Employee
Posts: 9

Re: OLAP Exception: Insufficient Memory

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
N/A
Posts: 0

Re: OLAP Exception: Insufficient Memory

Hi Andrea,

the same problem i am also facing,

But my olap server is running on unix environment.

Can someone help?

Regs
Rajha
Super Contributor
Super Contributor
Posts: 3,174

Re: OLAP Exception: Insufficient Memory

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.
N/A
Posts: 0

Re: OLAP Exception: Insufficient Memory

thanks

i will start a new thread.
New Contributor
Posts: 2

Re: OLAP Exception: Insufficient Memory

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
Ask a Question
Discussion stats
  • 5 replies
  • 512 views
  • 0 likes
  • 4 in conversation