Microsoft KB Archive/291374

= FIX: Creation of Local Cube with More Than 202 Measures May Fail =

Article ID: 291374

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q291374



BUG #: 12056 (plato7x)



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 &quot;Invalid Pointer&quot; 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.



WORKAROUND
Creating a cube with 202 measures or less does not produce this error.



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.

Additional query words: PTS, Pivot Table Service, Local Cube

Keywords: kbbug kbfix kbqfe kbsqlserv2000sp1fix KB291374

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.