Article ID: 933832
Article Last Modified on 4/24/2007
APPLIES TO
- Microsoft SQL Server 2005 Analysis Services
SYMPTOMS
When you try to run a Multidimensional Expressions (MDX) query in Microsoft SQL Server 2005 Analysis Services, an access violation may occur. Additionally, you may receive the following error message:
This problem only occurs in specific scenarios.
CAUSE
This problem occurs because of a heap corruption in Analysis Services.
RESOLUTION
To resolve this problem, obtain the latest service pack for SQL Server 2005. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
913089 How to obtain the latest service pack for SQL Server 2005
WORKAROUND
To work around this problem, set the following values in the Msmdsrv.ini file.
<MemoryHeapType>2</MemoryHeapType> <HeapTypeForObjects>0</HeapTypeForObjects>
The Msmdsrv.ini file is in the folder in which you installed Analysis Services. For example, the Msmdsrv.ini file may be in the following folder:
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Config
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in SQL Server 2005 Service Pack 2.
Keywords: kbtshoot kbsql2005as kbprb KB933832