Thomas Ellermanns view on System Center

This blog will discuss features, functions and views on Operations Manager and Service Manager

Orchestrator Runbooks not appearing on the web console

Orchestrator Runbooks not appearing on the web console

  • Comments 12
  • Likes

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.

Comments
  • 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

  • Great

    Thanks You,.

  • Hy, Same Problem in R2 still Standing?

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment