Orchestrator 2012 : Statistics not updated in Web Console

Hello All,

You may be already experimented this issue with System Center Orchestrator 2012 RC, the statistics available in the web console are never updated and always stay at zero. The two print screens below represent the problem that I had in my lab environment :

clip_image002

clip_image002[5]

This problem is due to a SQL Store procedure that doesn’t start and doesn’t update the statistics in the web console.

To solve that, the very first step is to ensure that the SQL Broker in enable on your SQL Server. Go to you SQL Server and run the following Query :

select is_broker_enabled from sys.databases where name= ‘Orchestrator’

If it is not (you get a return value of 0) then you need to enable it by doing the following:

alter database Orchestrator set enable_broker WITH ROLLBACK IMMEDIATE

Now, we’ll check the last execution time of the procedure that is taking care of the statistic update. Execute the follow query :

SELECT
      [m].[Name],
      [m].[IsEnabled],
      [m].[IntervalInSeconds],
      [m].[LastExecutionTime]
FROM [Orchestrator].[Microsoft.SystemCenter.Orchestrator.Maintenance].[MaintenanceTasks] [m]

This will return the following table :
clip_image002[7]

We could see that the LastExcutionTime of the Statistics store procedure is MARCH 15, or this normally procedure has to run every 10 minutes (600 seconds). It’s clear that something is going wrong there.

To start manually this procedure, we have to run the follow query :

EXEC [Microsoft.SystemCenter.Orchestrator.Maintenance].[EnqueueRecurrentTask] @taskName = ‘Statistics’

After a few seconds, we must find some data in the following table :

SELECT *
FROM [Orchestrator].[Microsoft.SystemCenter.Orchestrator.Statistics.Internal].[Statistics]
 

Running manually the procedure must solve the issue in the majority of the case, but if you still have any statistic  data after running all the SQL queries above, it’s certainly due to your SQL Server that is not working properly.

In fact, it was my case, still no updated statistics. if like me, you are running  your lab SQL server in  a VM on your laptop, VM that you never shutdown /reboot, but always use the PAUSE feature. This could cause some problem with the SQL Store procedures.

How to solve that ? Simply reboot your SQL Server. After the reboot, my statistic updated automatically.

clip_image001

I hope this help you Winking smile

Thanks to Travis Wright and Chris Sanders for their help on this topic.

Christopher KEYAERT

clip_image001 clip_image002 clip_image004 clip_image005 clip_image007 clip_image008

Tweet about this on TwitterShare on FacebookShare on LinkedInShare on Google+Email this to someoneShare on TumblrPin on PinterestDigg thisShare on RedditFlattr the authorBuffer this pageShare on StumbleUpon

About Christopher Keyaert

Christopher Keyaert is a Consultant, focused on helping partners to leverage the System Center and Microsoft Azure cloud platform. He is also a Microsoft Most Valuable Professional (MVP) for Cloud and Data Center Management and a Microsoft Certified Trainer (MCT).
This entry was posted in Uncategorized. Bookmark the permalink.

0 Responses to Orchestrator 2012 : Statistics not updated in Web Console

  1. Doug says:

    Excellent post. Worked just as advertised. Thank you!

  2. Hi Christopher,

    I followed the steps you described, and the task returns the message “Command(s) completed successfully” but when I use SELECT * FROM [Orchestrator].[Microsoft.SystemCenter.Orchestrator.Statistics.Internal].[Statistics] I get the result: (0 row(s) affected).

    Do you know what could be wrong with my setup?

    • Excepting the statistics everything is working well in your environment ?
      Runbooks are running correctly ? The status are well retrieved in the Runbook designer ?

      • Yes, everything is working well: runbooks are running good, I can view the status correctly in the details pane and also the logging in the Jobs/Instances panes. Also in the Runbook Designer I can see the correct status.

        Any idea?

      • Hi Christopher,

        Do you have any idea where to look for this problem? The table with maintenance tasks gives the following result:

        Name IsEnabled IntervalInSeconds LastExecutionTime
        Authorization 1 1800 2013-02-11 14:25:16.397
        Statistics 1 600 2012-03-16 00:08:49.027
        ClearAuthorizationCache 1 600 2012-08-04 09:43:00.387

        They all do not run frequently. Something else wrong?

        Johan

        • Hello Johan,

          Did you try to run the following SQL Query ?
          EXEC [Microsoft.SystemCenter.Orchestrator.Maintenance].[EnqueueRecurrentTask] @taskName = ‘Statistics’

          Did you try to restart your SQL instance ?

          • I’ve run that query several times, and it allway returns “Command(s) completed successfully.” The SQL Instance has been rebooted also a couple of times. I’ve been running Orchestrator since march last year, started with a Release Candidate. Can that be a problem?

Leave a Reply

Your email address will not be published. Required fields are marked *