FIX: Full Process of a Remote Partition Unprocesses Other Remote Partitions in Same Server (297933)
The information in this article applies to:
- Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q297933
BUG #: 11264 (Plato7.x)
SYMPTOMS
When you execute a ProcessFull from Decision Support Object (DSO) on a cube that has two or more remote partitions, when the partitions reside on the same server the process causes some of the remote partitions to become "unprocessed" or to have the State property of the partition set to olapStateNeverProcessed.
RESOLUTIONTo 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
WORKAROUND
If you change the process type in the DSO Process method from ProcessFull to ProcessDefault, the State property of the partition is set correctly to olapStateCurrent or four.
STATUSMicrosoft 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.
Modification Type: | Minor | Last Reviewed: | 4/24/2003 |
---|
Keywords: | kbBug kbfix kbssas800sp1fix KB297933 kbAudDeveloper |
---|
|