Service Manager 2012 services won’t start after applying KB2677070

After applying the recently released security update KB2677070 the System Center Data Access Service and the System Center Management Configuration Service wont start. Both services will log a “Error 1053: The service did not respond to the start or control request in a timely fashion”    The following error is shown:   When applying KB2677070, the…


SCSM 2012 Data Warehouse jobs keep failing

I often run into the same problem with the SCSM 2012 Data Warehouse, that the cubes jobs all fail. When resuming one of the jobs the following errors appear in the log: Message : An Exception was encountered while trying during cube processing.  Message=  Processing warning encountered – Location: , Source: Microsoft SQL Server 2008…


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…


Force language on SCSM 2012 Console

Several customers would like to use the console with the US language setting, even though the client OS is of a different language. In both SCSM2010 and SCSM2012 the console will start up the same language as the client, but for SCSM2012 the users now have the option to change that::   But still, the console will initially…


Incident reports failing with – Query execution failed for dataset ‘RelatedCIs’.

I ran into a funny problem the other day when working with the SCSM Incident reports. The reports all ran fine, but when we wanted to drill furter down we got the following error: Query execution failed for dataset ‘RelatedCIs’. (rsErrorExecutingCommand) I tried to run the report directly on the SSRS server and got little…


Automatically close incidents after x number of days

I had a request from a customer that the would like a workflow to close all resolved incidents, 7 days after they were resolved. Several solutions exists on the internet, but I think this one is the most simple. First you need to install the SCSM Powershell Cmdlets, as it includes a cmdlet called Get-SCSMIncident…


Blank User Role name and description in the SCSM console

If you have a SCSM 2010 environment where you are using localised consoles and not only the English one, you will most likely come across this little problem: US Console Danish Console If you run a SQL Query against the Userrole and LocalizedText tables you get the following output: So why are the User roles not…