Microsoft KB Archive/932687

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


The processing operation may stop responding when you process a SQL Server 2005 Analysis Services database on a server that has a single processor

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