Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
FIX: Creation of Local Cube with More Than 202 Measures May Fail
Article ID: 291374 - View products that this article applies to.
This article was previously published under Q291374
BUG #: 12056 (plato7x)
When you attempt to create a local cube with more than 202 measures, the local cube creation may fail.
When you do this from a custom Microsoft Visual Basic (VB) application using a CREATE CUBE statement in the connection string, the Open method on the connection may fail with an "Invalid Pointer" error message.
When you attempt to create a local cube from the Microsoft Excel Pivot Table menu, you may see the following error message:
Microsoft OLE DB Provider for Analysis Services :
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 above files may also contain additional files.
Date Time Version Size File name ---------------------------------------------------- 3/1/2001 12:20p 18.104.22.168 208,959 Msmdcb80.dll 3/1/2001 12:20p 22.214.171.124 1,359,933 Msmdgd80.dll 3/1/2001 12:20p 126.96.36.199 1,982,541 Msolap80.dll 3/1/2001 12:20p 188.8.131.52 213,067 Msolap80.rll
Creating a cube with 202 measures or less does not produce this error.
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.
Article ID: 291374 - Last Review: November 21, 2006 - Revision: 1.1