You are currently offline, waiting for your internet to reconnect

FIX: You experience query failure when you run MDX queries in SSAS 2008

Symptoms
When you run some Multidimensional Expressions (MDX) queries that contain one or more named sets and use a Crossjoin function in Microsoft SQL Server 2008 Analysis Services (SSAS 2008), you may experience query failure. If you check the Msmdsrv.log, an entry that resembles the following may be present: 
Message:  (Source: \\?\\msmdsrv.log, Type: 3, Category: 256, Event ID: 0xC1000016)

Corresponding error in the NT App Event Log: 

Error <Time> MSOLAP 22 (256) "The description for Event ID 22 from source <AnalysisServerName> cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Internal error: An unexpected exception occurred.

Resolution
The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 14 for SQL Server 2008 SP3

About cumulative updates for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2901479 - Last Review: 11/18/2013 16:51:00 - Revision: 1.0

Microsoft SQL Server 2008 Service Pack 3, Microsoft SQL Server 2008 Analysis Services

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2901479
Feedback