SQL 2005 SP2 Cube Processing Error

Posted on 2009-12-23
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, 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.

Question by:exadmin2006
    LVL 3

    Expert Comment

    LVL 5

    Accepted Solution

    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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now