FIX: Creation of Local Cube with More Than 202 Measures May Fail (291374)

SYMPTOMS

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:

Error
Microsoft OLE DB Provider for Analysis Services :
Invalid pointer

RESOLUTION

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:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

Hotfix

NOTE: 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:

   Date      Time    Version    Size        File name   
   ----------------------------------------------------

   3/1/2001  12:20p  8.0.2.60    208,959    Msmdcb80.dll
   3/1/2001  12:20p  8.0.2.60   1,359,933   Msmdgd80.dll
   3/1/2001  12:20p  8.0.2.60   1,982,541   Msolap80.dll
   3/1/2001  12:20p  8.0.2.60     213,067   Msolap80.rll

NOTE: Due to file dependencies, the most recent hotfix or feature that contains the above files may also contain additional files.

STATUS

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.