Microsoft KB Archive/933832

= Error message when you try to run a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services: &quot;An unexpected exception occurred&quot; =

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:

Internal error - An unexpected exception occurred

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. 2 0 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 &quot;Applies to&quot; section. This problem was first corrected in SQL Server 2005 Service Pack 2.

Keywords: kbtshoot kbsql2005as kbprb KB933832

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.