DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2738490 - Last Review: February 4, 2013 - Revision: 4.0

Symptoms

You may experience one of the following problems while using the System Center Orchestrator Orchestration Console or when accessing System Center Orchestrator data using the Web Service:

1. New Runbooks and/or Folders that have been created using the Runbook Designer are not displayed even though the user has the appropriate permissions to see them.

2. Summary pages have incorrect results for all statistics.

Cause

System Center Orchestrator uses a series of scheduled tasks executed by Microsoft SQL Server Service Broker timer conversations. One or more of these conversations is being ended without a new conversation being established.

Resolution

This problem is resolved in System Center 2012 Service Pack 1. The following workarounds are available to mitigate the problem reactively prior to application of System Center 2012 Service Pack 1:

Workaround for Symptom 1

Execute the following T-SQL query using SQL Server Management Studio to provide immediate symptom relief:

TRUNCATE TABLE [Microsoft.SystemCenter.Orchestrator.Internal].AuthorizationCache
Then execute the following T-SQL query to reestablish the task execution:
EXEC [Microsoft.SystemCenter.Orchestrator.Maintenance].EnqueueRecurrentTask 'ClearAuthorizationCache'

Workaround for Symptom 2


Execute the following T-SQL query using SQL Server Management Studio to reestablish the task execution:
EXEC [Microsoft.SystemCenter.Orchestrator.Maintenance].EnqueueRecurrentTask 'Statistics'

More information

The contents above make the assumption that SQL Server Service Broker is functioning as expected. If the workaround steps above do not mitigate the problem, further diagnostics of the SQL Server Service Broker are warranted such as whether or not the Service Broker is enabled on the Orchestrator database and whether the service and endpoints are configured correctly.

To check if Service Broker is enabled on the Orchestrator database, execute the following T-SQL query using SQL Server Management Studio:

SELECT is_broker_enabled FROM sys.databases WHERE name = '<database>'

"<database>" should be replaced with the name of your Orchestrator database. The result of this query should be "1" to reflect that the Service Broker is enabled on that database.

If the result of the query above is "0", then execute the following T-SQL query using SQL Server Management Studio to enable Service Broker:

ALTER DATABASE <database> SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE <database> SET ENABLE_BROKER
GO
ALTER DATABASE <database> SET MULTI_USER
GO

"<database>" should be replaced with the name of your Orchestrator database.

To check the configuration of the SQL Server Service Broker, the SSBDIAGNOSE utility can be used as outlined below.

If you are using Windows Authentication to your SQL Server, follow the instructions below:

Please open a Command Prompt using the "Run as administrator" functionality and execute the following command (all one line):

ssbdiagnose -LEVEL INFO -E -d <database> CONFIGURATION FROM SERVICE http://schemas.microsoft.com/SystemCenter/Orchestrator/Maintenance/MaintenanceService TO SERVICE http://schemas.microsoft.com/SystemCenter/Orchestrator/Maintenance/MaintenanceService ON CONTRACT DEFAULT

NOTE Change "<database>" to the name of your System Center Orchestrator database.

If you are using SQL Authentication to your SQL Server, follow the instructions below:

Please open a Command Prompt using the "Run as administrator" functionality and execute the following command (all one line):

ssbdiagnose -LEVEL INFO -U <user> -P <password> -d <database> CONFIGURATION FROM SERVICE http://schemas.microsoft.com/SystemCenter/Orchestrator/Maintenance/MaintenanceService TO SERVICE http://schemas.microsoft.com/SystemCenter/Orchestrator/Maintenance/MaintenanceService ON CONTRACT DEFAULT

NOTE Change "<user>" to the SQL Username, "<password>" to the password for the SQL user and "<database>" to the name of your System Center Orchestrator database.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use (http://go.microsoft.com/fwlink/?LinkId=151500) for other considerations.

Applies to
  • Microsoft System Center 2012 Orchestrator
Keywords: 
KB2738490
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support