Microsoft KB Archive/295605

{|
 * width="100%"|

FIX: Internal Error on Writeback to a Virtual Cube That Has More Dimensions Than the Component Cubes

 * }

Q295605

-

The information in this article applies to:


 * Microsoft SQL Server 2000 Analysis Services, version 8.0

-

BUG #: 11088 (Plato7.x)

SYMPTOMS
When you attempt to write back to a virtual cube using the Update Cube Multidimensional Expression (MDX) statement and the virtual cube has more dimensions than the component cube that is write-enabled, you may receive the following error message:

Run-time Error '-2147467259 (800004005)': An unexpected internal error has occurred.

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, please see the following article in the Microsoft Knowledge Base:

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

STATUS
Microsoft has confirmed this to be 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.

Steps to Reproduce
To reproduce the error, add the &quot;Store Size in SQFT&quot; and &quot;Store Type&quot; virtual dimensions to the &quot;Warehouse and Sales&quot; cube, reprocess and run the following MDX statement against the Foodmart 2000 database:

UPDATE CUBE [Warehouse and Sales] SET ([Store].[All Stores].[USA].[WA].[Seattle],[Warehouse].[All Warehouses].[USA].[WA].[Seattle],[Time].[1997].[Q1], [Warehouse Cost]) = 10 Additional query words: An unexpected internal error has occurred Run-time '-2147467259 (800004005)' OLAP writeback

Keywords : _IK kbGrpDSOLAP kbSSAS800bug kbssas800sp1fix

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ2000Search kbSQLServ2000Anal800