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.

Comments

• Anonymous
  January 01, 2003
  worked for me too - THANK YOU! I'll tweet this one!

• Anonymous
  January 01, 2003
  Thanks!

• Anonymous
  January 01, 2003
  Hi Thomas, Great Article. Thanks

• Anonymous
  October 03, 2012
  Thanks.  This worked for me.

• Anonymous
  October 10, 2012
  It worked for me. GREAT advise. thanks a lot for sharing.

• Anonymous
  February 14, 2013
  Thx! this has been very helpful.  Do you know if this issue has been resolved in SP1?

• Anonymous
  March 01, 2013
  J'ai eu le problème avec le SP1. Romain

• Anonymous
  April 02, 2013
  Hi, still seeing this problem post SP1

• Anonymous
  April 11, 2013
  Just clearing the authorization cache may not solve the problem. opalis.wordpress.com/.../runbooks-not-showing-up

• Anonymous
  June 20, 2013
  Great Thanks You,.

• Anonymous
  January 20, 2014
  Si votre console web vous affiche ceci : Executez la requète SQL suivante : TRUNCATE TABLE [Microsoft

• Anonymous
  February 24, 2014
  Hy, Same Problem in R2 still Standing?

• Anonymous
  January 13, 2015
  I have experienced it in the newest R2 UR today.

• Anonymous
  September 01, 2015
  Thanks for the help...

• Anonymous
  November 27, 2015
  Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
  For more info on showbox please refer below sites:
  http://showboxandroids.com/showbox-apk/
  http://showboxappandroid.com/
  Latest version of Showbox App download for all android smart phones and tablets. http://movieboxappdownloads.com/ - It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
  For showbox on iOS (iPhone/iPad), please read below articles:
  http://showboxappk.com/showbox-for-ipad-download/
  http://showboxappk.com/showbox-for-iphone/
  Showbox for PC articles:
  http://showboxandroids.com/showbox-for-pc/
  http://showboxappandroid.com/showbox-for-pc-download/
  http://showboxforpcs.com/
  There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment it doesn't charge cash for watching films and recordings. Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on 'Obscure sources'.