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:
Note In this error message, the word "occured" is a misspelling for the word "occurred."
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.
RESOLUTION
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 "Applies to" section.
Keywords: kbsql2005as kbexpertiseadvanced kbfix kbpubtypekc kbqfe kbhotfixserver KB937829