Microsoft KB Archive/937829

= FIX: Error message when you run an MDX query against a database in SQL Server 2005 Service Pack 2: “An unexpected exception occured” =

Article ID: 937829

Article Last Modified on 6/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-





SYMPTOMS
When you run a Multidimensional Expressions (MDX) query against a database in SQL Server 2005 Analysis Services Service Pack 1 (SP1), the query takes a long time to finish. This problem occurs if the query contains one of the following calculation operators:

After you install SQL Server 2005 Analysis Services Service Pack 2 (SP2), you receive the following error message when you run the same query:

An unexpected exception occured.

Note In this error message, the word &quot;occured&quot; is a misspelling for the word &quot;occurred.&quot;

Additionally, minidump files are generated in the SQL Server 2005 Analysis Services log folder.



CAUSE
This issue occurs because of a regression in SQL Server 2005 Analysis Services SP2.



Cumulative update information
To resolve this problem, obtain cumulative update package 2 for SQL Server 2005 Service Pack 2 (build 3175). For more information about how to obtain cumulative update package 2 (build 3175), click the following article number to view the article in the Microsoft Knowledge Base:

936305 Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbsql2005as kbexpertiseadvanced kbfix kbpubtypekc kbqfe kbhotfixserver KB937829

-

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

© Microsoft Corporation. All rights reserved.