Microsoft KB Archive/870620

= DTS packages may fail if you run multiple DTS packages that contain Analysis Services Processing tasks at the same time =

Article ID: 870620

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services
 * Microsoft SQL Server 2000 Analysis Services

-



Bug#: 22777 (Content Maintenance)



SYMPTOMS
In Microsoft SQL Server 2000, you receive one of the following error messages:

Error message 1

Error = -2146828197 (800A005B) Error string: Object variable or With block variable not set Error source: DSO

Error message 2

Error = -2147417848 (80010108) Error string: Object Invoked has disconnected from its clients. (DSO (80004005): Method '~' of object '~' failed) Error source: Microsoft Data Transformation Services (DTS) Package



CAUSE
This problem occurs when you try to run multiple Data Transformation Services (DTS) packages at the same time, and each DTS package contains an Analysis Services Processing task. The Analysis Services Processing task cannot process SQL Server 2000 Analysis Services objects, including dimensions, partitions, or cubes, at the same time.



WORKAROUND
To work around this problem, use one of the following methods:

Method 1
Run each DTS package serially. To do this, you can either create a workflow dependency between the tasks in a DTS package or you can schedule the DTS package to run as a dependent step in a SQL Server Agent job.

Method 2
Use the Analysis Services Parallel Processing utility to process the Analysis Services objects. This utility manages and controls the processing of Analysis Services cubes and partitions. The Analysis Services Parallel Processing utility is a sample Decision Support Objects (DSO) program. You can use the Analysis Services Parallel Processing utility to process Analysis Services objects at the same time. The Analysis Services Parallel Processing utility does this by implementing code to exclusively access the Analysis Services objects. You can run the Analysis Services Parallel utility program at a command prompt or from an operating system command step in a SQL Server Agent job. To download the Analysis Services Parallel Processing utility, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyId=A2EEF773-6DF7-4688-8211-E02CF13CBDB4&displaylang=en

Method 3
Create a custom Decision Support Objects (DSO) program to process the Analysis Services objects. The Analysis Services Parallel Processing utility contains Microsoft Visual Basic source code. You can create a custom program that is based on the source code in the ProcessPartion.exe program. The ProcessPartion.exe program does the actual processing of the cube or the partition. For more information about the Analysis Services Parallel Processing utility, see the Readme.doc file in the installation folder.

Note You must have Microsoft Visual Studio 6.0 to compile the source code.



STATUS
This behavior is by design.



MORE INFORMATION
Analysis Services Processing tasks use the DSO Library to process Analysis Services objects. DSO is not designed for parallel processing. To perform the parallel processing, you must implement exclusive access for part of the DSO code.

Keywords: kbprb KB870620

-

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

© Microsoft Corporation. All rights reserved.