Microsoft KB Archive/942515

= After you submit an assignment in PerformancePoint Planning Server, the status of the assignment remains as pending =

Article ID: 942515

Article Last Modified on 10/25/2007

-

APPLIES TO


 * Microsoft Office PerformancePoint Server 2007, 32 Bit Edition
 * Microsoft Office PerformancePoint Server 2007, 64 Bit Edition

-



SYMPTOMS
After you submit an assignment in Microsoft Office PerformancePoint 2007 Planning Server, the status of the assignment changes to pending. However, the assignment never changes from that status. The Planning Process service stops, and you receive the following error message when you try to start the service:

SQL service broker is disabled and the service will stop itself.



CAUSE
The Microsoft SQL Server Service Broker is disabled for one of the databases that are used by PerformancePoint Planning Server.



RESOLUTION
To resolve this issue, follow these steps:  Start SQL Server Management Studio. Click New Query. Expand Databases, and then click PPSPlanningService. In the details pane, type the following command, and then click Execute:

ALTER DATABASE PPSPlanningService SET ENABLE_BROKER

 Repeat steps 2 through 4 for PPSPlanningSystem and for each application database.

Keywords: kberrmsg kbtshoot kbprb kbexpertiseadvanced KB942515

-

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

© Microsoft Corporation. All rights reserved.