Orchestrator Runbooks not appearing on the web console

I was creating new runbooks in System Center Orchestrator 2012 and wanted to synchronize them to Service Manager 2012, but after running the connector the runbooks still didn't appear.

Browsing to the Orchestrator web console I could see the runbooks wasn't even available here.

Solution:

1. Open SQL Management studio and connect to the SQL Server and instance hosting the Orchestrator Database

2.Type in the following SQL Query:

TRUNCATE TABLE
[Microsoft.SystemCenter.Orchestrator.Internal].AuthorizationCache

3. Refresh the Orchestrator web console and the runbooks are there.

4. Start the SCO -> SCSM connector and the runbooks will be available as well.

 

If the problem reoccurs, you can do the following to run a scheduled cleanup of the Authorization table:

1. Open SQL Management studio and connect to the SQL Server and instance hosting the Orchestrator Database

2.Type in the following SQL Query:

EXEC [Microsoft.SystemCenter.Orchestrator.Maintenance].EnqueueRecurrentTask ‘ClearAuthorizationCache’

 

This will establish a new SQL Service Broker conversation to flush the authorization cache every 10 minutes.