Article ID: 294993 - View products that this article applies to.
This article was previously published under Q294993
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 12092 (Plato7.x)
BUG #: 12178 (Plato7.x)
Attempting to use the CrossJoin function in combination with the Order function in a Multidimension Expression (MDX) statement may cause the following error message to occur:
Unable to open cellset.
An unexpected internal error has occurred.
To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
HotfixNOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 1.
The English version of this fix should have the following file attributes or later:
NOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.
Date Time Version Size File name ------------------------------------------------------- 4/5/2001 2:31p 184.108.40.206 1,733,180 Msmdsrv.exe 4/5/2001 2:31p 220.127.116.11 209,472 Msmdcb80.dll 4/5/2001 2:31p 18.104.22.168 1,360,448 Mdmdgd80.dll 4/5/2001 2:31p 22.214.171.124 1,983,056 Msolap80.dll 4/5/2001 2:31p 126.96.36.199 213,067 Msolap80.rll
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.
This error message shown in the "Symptoms" section does not occur if the MDX statment is run under Microsoft OLAP version 7.0. This problem is specific to Microsoft Analysis Services 2000, version 8.0.
Steps to Reproduce Behavior
Article ID: 294993 - Last Review: October 23, 2013 - Revision: 1.2
Contact us for more help
Connect with Answer Desk for expert help.