[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL 2005 SP2 Cube Processing Error

Posted on 2009-12-23
3
Medium Priority
?
289 Views
Last Modified: 2016-02-13
Hey all,

We are running SQL 2005 with SP2 on a dedicated machine that handles and processes cubes. Out of nowhere, when we try to process the cubes, we get this error:

Memory error: Allocation failure : Not enough storage is available to process this command

I have looked this up and it seems this is mostly a pre-SP1 or SP1 issue that SP2 resolved (see http://support.microsoft.com/kb/917885, which is our exact issue but is for Release or SP1 versions).

Anyway, I was hoping for somw guidance. This is affecting all users as far as I can tell.

UPDATE - More details...the error happens in Excel 2007 using Pivot Tables. So we are not sure if the error is server-side or not. It happens when people try to expand down in the spreadsheet.

Thanks.
0
Comment
Question by:exadmin2006
2 Comments
 
LVL 5

Accepted Solution

by:
grzegorzs earned 2000 total points
ID: 26144775
Before processing objects SSAS tries to estimate memory needed for the operation. You get this error when there is not enough memory. Try to set higher memory limit for SSAS server or try to process fewer objects (for example one partition).

best regards

 
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question