Microsoft KB Archive/295442

= FIX: Processing OLAP 7.0 Objects from Analysis Services DTS Task Fails =

Article ID: 295442

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q295442



BUG #: 11113 (Plato7.x)



SYMPTOMS
When attempting to process an OLAP 7.0 cube, partition, or dimension from the OLAP processing task in Data Transformation Services (DTS) on SQL Server 2000, the OLAP processing task may fail. If the package is run interactively in the DTS Designer, when you double-click the failed task in the processing dialog box, the following error message is received:

Object doesn't support this action.

The DTS package log shows the following error:

Step Error Source: DSO

Step Error Description:Object doesn't support this action

Step Error code: 800A01BD

Step Error Help File:

Step Error Help Context ID:1000445

If the package is executed from the SQL Server 2000 Enterprise Manager, the following error message is seen and the Enterprise Manager shuts down.

---

mmc.exe - Application Error

---

The instruction at &quot;0x415ceda8&quot; referenced memory at &quot;0xa8c9480c&quot;. The memory could not be &quot;written&quot;.



CAUSE
The DTS task attempts to use the ProcessingLogFileName property of the OLAP/Analysis Server for DTS logging. Because this property was added in Analysis Services and does not exist in OLAP 7.0, the OLAP server returns an error, causing the DTS OLAP task to fail.



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



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: DTS OLAP

Keywords: kbbug kbfix kbssas800sp1fix KB295442

-

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

© Microsoft Corporation. All rights reserved.