TAG | opalis
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 :
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 :
FROM [Orchestrator].[Microsoft.SystemCenter.Orchestrator.Maintenance].[MaintenanceTasks] [m]
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 :
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.
I hope this help you
Thanks to Travis Wright and Chris Sanders for their help on this topic.
The recording of my last week session about “Orchestrator 2012 – How to build your first runbook” is available on TechNet Edge :http://technet.microsoft.com/en-us/edge/hh916316
The slide deck is available on Slide Share :
You could also download the Runbooks that I created during the session : DOWNLOAD
Kelverion company closely worked with Microsoft for releasing a new set of Orchestrator 2012 Integration packs for the following BMC Products:
- BMC Bladelogic v8.1, 8.2
- BMC Remedy ARS v7.5, 7.6
- BMC Enterprise Event Manager (BEM) v7.4
- BMC Atrium CMDB v7.6.04
The license is free of charge for the current BMC IPs on completion of an end user license form, detailing the number of Orchestrator databases and which BMC products are to be licensed.
The licensing of the Integration Packs is per Orchestrator database i.e. so normally a customer would have at least one license for production and one for development as a minimum.
These free IPs are supplied without warranty or support and you could download it here: http://www.kelverion.com/bmc-download
Downloads are supplied with a 14 day evaluation license but you simply have to send an email to email@example.com to obtain permanent license keys.
More details about the activities available below :
Integration Pack for BMC Atrium CMDB
- BMC Atrium CMDB 7.6.04 is supported. Future compatibility is dependent on BMC Atrium Core Web Services. Prior versions to 7.6.04 are not supported.
The Integration Pack supports the following activities for both CIs and relationships:
- Create Instance
- Delete Instance
- Get Instance
- Monitor Instance
- Update Instance
- Start Reconciliation Engine Job
Integration Pack for BMC Enterprise Event Manager (BEM)
Starting with BMC Enterprise Event Manager 7.4 with Impact Integration Web Server 7.4 (developed with 7.4.01). Future compatibility is dependent on changes to Impact Integration Web Server.
- Create Event
- Update Event
- Set Event Status
- Get Event
- Monitor Events
Integration Pack for BMC Remedy AR System
Starting with BMC Remdey AR System 7.5 and 7.6. (developed with Remedy 7.5). Future compatibility is dependent on Remedy Web Service. Version 7.1 or below is not supported.
The Integration Pack supports the following activities:
- Create Request
- Update Request
- Get Request
- Monitor Request
Integration Pack for BMC BladeLogic
Starting with BMC BladeLogic Server Automation 8.1
- Create BLPackage from Audit
- Create Deploy Job (BLPackage Deploy Job or Software Deploy Job)
- Run Job (Audit Job, ACL Push Job, Batch Job, BLPackage Job, Compliance Job, Component Discover Job, File Deploy Job, Software Deploy Job, NSH Script Job, Snapshot Job, Virtual Infrastructure Discovery Job)
- Export Audit Results
- Set Server Property
- Run BLCLI Command
More information on this website : http://www.kelverion.com/
You just installed System Center Orchestrator, Great, but what’s next?
On Tuesday, March 20, 2012 2:00 PM (GMT+01:00), I will do a live meeting to present the System Center Orchestrator basics for runbook creation. We will speak about bests practices, how to use out of the box activities, configuring Orchestrator Integration Packs, runbook creation and a lot more.
We will show you how to build your first System Center Orchestrator runbook from scratch.
This is a live meeting and it’s free, to register follow this link : https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032506833&Culture=en-US
Last week, with my friend Kurt Van Hoecke (SCSM Expert), we delivered two sessions at Microsoft Belgium on System Center Orchestrator 2012. These sessions have been recorded and are now available online on Technet.
System Center Orchestrator 2012: An Overview by Kurt Van Hoecke.
System Center Orchestrator 2012: Migration Plan by Christopher Keyaert.
Microsoft System Center Orchestrator 2012 Resources :
Microsoft System Center Orchestrator 2012 beta is available as public beta at the Microsoft Download Center : http://www.microsoft.com/download/en/details.aspx?id=26503
Microsoft System Center Orchestrator 2012 Team Blog : http://blogs.technet.com/b/scorch/
TechNet Forums for System Center Cross Platform and Interoperability :http://social.technet.microsoft.com/Forums/en-US/category/scinterop