Friday, December 20, 2013

SCSM: ETL jobs stuck after upgrade to R2

If you have upgraded your SCSM environment to System Center 2012 R2, you may run into a situation where the data warehouse ETL jobs get stuck.


  • The ETL jobs status shows running, but the jobs are disabled. The MPSyncJob does not complete.


  • Some management packs have a Failed deployment status, and if you try to redeploy them, they fail immediately.
  • Event 33519 in the OperationsManager event log on the DW management server:


3. You have attempted to repair the ETL jobs using this brilliant post by Doug Sigmon, with no luck.



Run the SQL queries as described in this article against the DW Repository, CM DataMart, DW Datamart and OM Datamart databases. Once complete, click on each failed management pack and select Restart Deployment. Within a couple of minutes the management packs should have a completed state (including those that were in a waiting state waiting for the failed MPs to complete) and your ETL jobs should complete as normal.

Sunday, September 22, 2013

First glance: Nokia Lumia 925

Towards the end of last year, I did something very uncharacteristic and bought a mobile phone off the shelf, but in my defense it was a Nokia Lumia 920, my much lived Sony phone had died and I was just about a year away from my next upgrade. Over the last 9 months the 920 stole my heart and loyalty, and I said I would never want another phone again.
After a comedy of stupid mistakes, we managed to lose one of our Nokias to the evil pits of hell where sad mobile phones go to die, leaving a gaping chasm in my life.
And then my contract renewal came round. And the Nokia Lumia 925 became available. And the chasm was bridged, filled, closed.

The first noticeable difference between the 920 and the 926 is the weight. While I loved the feeling of the 920 in my hand, it was a weighty phone. The 925 is much, much lighter, while still maintaining that nice in hand feeling. I also quite like the new candy shell cover, and i hope it is better at protecting the apparently not so unbreakable gorilla glass.

So far, the phone also feels snappier than the 920, and the screen appears to be a little crispier, while the touch screen feels a bit more responsive. So far, i am happy with the upgrade.

Sunday, July 21, 2013

First Glance: Surface RT

After months and months of drooling to myself over the Microsoft Surface, and waiting patiently for them to come to South Africa, I finally got my hands on one whilst on holiday in London. And all is good with the world.

So far, I am really impressed with how quick it was to set up, and how responsive it is. I had high expectations, considering how much I love my Nokia Lumia 920, and it has, so far, exceeded expectations.

This post really is just to test it out, especially as I will be on holiday for another two weeks. I will put this baby through some tests while on holiday, and do a bit of a write-up when I get back home.

Friday, July 5, 2013

User provisioning and management using #scsm and #scorch

I’ve been working on replacing our very manual user provisioning and management system for the last couple of months, and finally took it all to production in the last week. Before, we had a simple form in Sharepoint with some workflows in the backend to send emails, but users were provisioned manually by our server team. With all the admin that goes along with this process, it took around an hour per account – obviously not the best way to spend our server team’s time.

capture-20130621-132808In comes Service Manager, and Orchestrator in the backend, and changed the picture completely. We created the request offerings for user creations, as well as offerings around when users move in the organisation and when they leave the organisation. While this is by no means a full-fledged identity management solution or even a perfect solution, it has saved our server guys masses amounts of time already and works for our environment. I thought I would share some of my experiences and learnings from building ours.

Before you start building such a solution, it is very important that you draw the entire process out in Visio or similar. You need to identify every touch point and review point as early in your defining process as possible, because you will need to cater for each of these, either via an activity in the template or with an Orchestrator activity. You will want to identify the following, for example:

  • Who should review new user requests? Just the line manager, or do you have a HR or possibly security/compliance requirement too?
  • What kind of notifications should be sent, and at which intervals? What kind of information do you need to supply in the notifications?
  • What activities, other than creating the user account, can be automated or should form part of a new user take-on?

In our case, we have a couple of review activities (line manager, security, etc) and each department was very specific about the kind of information they need to see in order to approve a request. This information was required not only in the notification sent to them for new requests, but also in the review activity visible on the SSP.

For this reason, each kind of request uses at least 2 runbooks. The first runbook is triggered when a request is logged, and all it does is update the SR and review activities with this information and populate the Line Manager indicated in the request to the Line Manager review activity. The runbook looks a little like this:


I wrote here and here about creating the dynamic approval steps.

The request offering allows for the Line Manager of the affected user (new start/moving user) to be selected from a Query, and the Line Manager CI is then added to the Service Request as a Related item:


In the runbook, the link between Get Related User and Get User from CMDB is then configured like this:


Unfortunately, it is quite tricky to use just a Request Offering and a Service Request template to get the right information to display in the right way. This has been one of the biggest challenges I faced in building this solution, and figured that the best way to make things look the way we want them to is to manipulate the data a little with Orchestrator.

When we designed our forms, we were very aware of the kind of information required in the notifications, so we ensured that we collect all this information into the Service Request. We extended the SR class to include some custom fields so we can make sure we write that information somewhere safe. The runbook then retrieves this information, and updates the Service Request subject line and description with this information:


I also wanted to make sure I can configure the notifications as generic as possible using only the information that is easily accessible from the SR, and so wrote everything I could possibly want to translate into the notification into the SR in a way that will easily translate to a HTML email message. The end result is then a Service Request that looks like this:


And the resulting notification then looks like this:


If you are lucky enough (as I am) to have a separate development environment from your production environment and you build the entire solution in the dev environment, and then import the management packs from the dev environment into prod, you may run into some issues with the runbook activities in the SR templates. This is because the runbooks sync into each environment with different IDs and you will get an error like this:



You don’t need to recreate the runbook activity though, you can simply select the runbook from the catalogue (click on the Select button), update any mappings you may have and save.

bart-simpson-chalkboard-automationLastly, no solution is ever final, because as people discover the power of what you can do with the System Center suite, they will find new things for you to all the time. Just build in as much error checking as possible to make your own life easier and remember to look at things from different angles to find the best solution for your situation.

Tuesday, June 25, 2013

System Center 2012 R2 preview available now

systemcenter_2_2d9647a3Just a quicky post this morning. If you are a MSDN subscriber, you can find the previews for download here. Alternatively, you can download the evals here.

Be sure to catch the MVA What’s New Jump Start on the 15th of July to work through all the new features.

I will be upgrading my labs in the next week and do some writeups about the upgrade process.

Related Posts with Thumbnails