FIX: OLAP Server Out of Memory Error Occurs When You Perform Incremental Processing of Dimensions

Article translations Article translations
Article ID: 256129 - View products that this article applies to.
This article was previously published under Q256129
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 3792 (Plato7x)
Expand all | Collapse all

SYMPTOMS

When you perform incremental processing of one or more dimensions, OLAP Server consumes all the memory available on a system before an out of memory error occurs. However, full dimension processing (a rebuild of the dimension structure) completes successfully.

When you perform an incremental update of one or more dimensions from a Data Transformation Services (DTS) package, the following error message typically appears:
Package Error
DimensionName
Memory error [Failed to reallocate space] ‘Not enough storage is available to process this command.’
When you perform an incremental update of one or more dimensions from OLAP Manager, the following error message typically appears:
OLAP Server Error: Memory error [Failed to reallocate space] 'Not enough storage is available to process this command. ' ; Time:2/7/2000 5:26:48 PM
You may also see the following error message in a Windows NT Application Event Log that comes from SQL Server OLAP Services:
5:24 PM The server is out of memory.

STATUS

Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server OLAP Services version 7.0. For information about how to download and install the latest SQL Server OLAP Services Service Pack, see the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=F62F45E9-24ED-4FA6-BD74-8A26606F96D8
For more information, contact your primary support provider.

Properties

Article ID: 256129 - Last Review: February 28, 2014 - Revision: 5.1
APPLIES TO
  • Microsoft SQL Server OLAP Services
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB256129

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com