Article ID: 932687
Article Last Modified on 3/22/2007
APPLIES TO
- Microsoft SQL Server 2005 Analysis Services
SYMPTOMS
When you process a Microsoft SQL Server 2005 Analysis Services database on a server that has a single processor, the processing operation may stop responding. Additionally, you cannot cancel the processing operation. This problem is likely to occur when the database contains a complex cube or a mining model that has multiple nested tables.
CAUSE
This problem occurs because the maximum number of parallel operations is insufficient when the database contains a complex cube or a mining model that has multiple nested tables.
RESOLUTION
To resolve this problem, adjust the CoordinatorExecutionMode configuration value for the server to allow more parallel operations.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
MORE INFORMATION
By default, the maximum number of parallel operations on a server that is running Analysis Services is four operations per processor. This number may be insufficient in some instances. You can adjust the CoordinatorExecutionMode configuration value for the server to allow more parallel operations. For more information, visit the following Microsoft Web site:
Keywords: kbtshoot kbexpertiseadvanced kbsql2005as kbprb KB932687