dbTalk Databases Forums  

Memory Error(quota estimate) -when processing AS2005 cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Memory Error(quota estimate) -when processing AS2005 cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jason Fife
 
Posts: n/a

Default Memory Error(quota estimate) -when processing AS2005 cube - 03-07-2006 , 05:37 PM






Processing a new AS2005 cube fails with the following error:

Memory error: The operation cannot be completed because the memory quota
estimate (732MB) exceeds the available system memory (659MB).

My system has 1GB RAM, 2GB page file, and under Analysis Server Properties,
I have changed the TotalMemoryLimit and Virtual MemoryLimit to 60% instead of
the default 80%. However, processing the cube still produces the above error.

Anyone have ideas?

Thanks


Reply With Quote
  #2  
Old   
Akshai Mirchandani [MS]
 
Posts: n/a

Default Re: Memory Error(quota estimate) -when processing AS2005 cube - 03-08-2006 , 03:09 PM






Are you perhaps trying to process a parent/child dimension? There was an
issue fixed recently where the quota estimation for deep parent/child
dimensions was being incorrectly done.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jason Fife" <JasonFife (AT) discussions (DOT) microsoft.com> wrote

Quote:
Processing a new AS2005 cube fails with the following error:

Memory error: The operation cannot be completed because the memory quota
estimate (732MB) exceeds the available system memory (659MB).

My system has 1GB RAM, 2GB page file, and under Analysis Server
Properties,
I have changed the TotalMemoryLimit and Virtual MemoryLimit to 60% instead
of
the default 80%. However, processing the cube still produces the above
error.

Anyone have ideas?

Thanks




Reply With Quote
  #3  
Old   
Jason Fife
 
Posts: n/a

Default Re: Memory Error(quota estimate) -when processing AS2005 cube - 03-08-2006 , 04:06 PM



I'm attempting to process a cube that includes a multi-level time-dimension
(Quarter, Month, Day). Can you please tell me what the fix is or point me in
the right direction?

Thanks

Jason


"Akshai Mirchandani [MS]" wrote:

Quote:
Are you perhaps trying to process a parent/child dimension? There was an
issue fixed recently where the quota estimation for deep parent/child
dimensions was being incorrectly done.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jason Fife" <JasonFife (AT) discussions (DOT) microsoft.com> wrote in message
news:672CFD21-A864-4483-80EA-12D1276CCC77 (AT) microsoft (DOT) com...
Processing a new AS2005 cube fails with the following error:

Memory error: The operation cannot be completed because the memory quota
estimate (732MB) exceeds the available system memory (659MB).

My system has 1GB RAM, 2GB page file, and under Analysis Server
Properties,
I have changed the TotalMemoryLimit and Virtual MemoryLimit to 60% instead
of
the default 80%. However, processing the cube still produces the above
error.

Anyone have ideas?

Thanks





Reply With Quote
  #4  
Old   
Akshai Mirchandani [MS]
 
Posts: n/a

Default Re: Memory Error(quota estimate) -when processing AS2005 cube - 03-09-2006 , 02:56 PM



Try processing the dimensions separately. Perhaps that way they will succeed
to process. Otherwise, find out which dimension shows this error and check
if it is parent/child.

If it occurs for a regular dimension or for partitions then most likely the
server really does need more memory for the data volumes that you are trying
to process...

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jason Fife" <JasonFife (AT) discussions (DOT) microsoft.com> wrote

Quote:
I'm attempting to process a cube that includes a multi-level
time-dimension
(Quarter, Month, Day). Can you please tell me what the fix is or point me
in
the right direction?

Thanks

Jason


"Akshai Mirchandani [MS]" wrote:

Are you perhaps trying to process a parent/child dimension? There was an
issue fixed recently where the quota estimation for deep parent/child
dimensions was being incorrectly done.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no
rights
Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.

"Jason Fife" <JasonFife (AT) discussions (DOT) microsoft.com> wrote in message
news:672CFD21-A864-4483-80EA-12D1276CCC77 (AT) microsoft (DOT) com...
Processing a new AS2005 cube fails with the following error:

Memory error: The operation cannot be completed because the memory
quota
estimate (732MB) exceeds the available system memory (659MB).

My system has 1GB RAM, 2GB page file, and under Analysis Server
Properties,
I have changed the TotalMemoryLimit and Virtual MemoryLimit to 60%
instead
of
the default 80%. However, processing the cube still produces the above
error.

Anyone have ideas?

Thanks







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.