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:
EXEC [Microsoft.SystemCenter.Orchestrator.Maintenance].EnqueueRecurrentTask ‘ClearAuthorizationCache’
This will establish a new SQL Service Broker conversation to flush the authorization cache every 10 minutes.
Hi Thomas,
Great Article.
Thanks
Thanks. This worked for me.
It worked for me. GREAT advise. thanks a lot for sharing.
worked for me too - THANK YOU!
I'll tweet this one!
Thanks!
Thx! this has been very helpful. Do you know if this issue has been resolved in SP1?
J'ai eu le problème avec le SP1.
Romain
Hi, still seeing this problem post SP1
Just clearing the authorization cache may not solve the problem. opalis.wordpress.com/.../runbooks-not-showing-up