(Hopefully) Useful Information on Microsoft System Center, Hyper-V and Cloud

SCOM – Monitor SCSM Data Warehouse Jobs

DW

The data warehouse jobs in SCSM are very important as they are responsible for maintaining the DW databases, synchronising the management packs between the operational and DW management groups, extracting, transforming and loading data, and processing cubes. These are all the jobs that should be enabled and should be running on their defined schedule. If any of these jobs don’t run successfully, data cannot be loaded into the DW, could.. Read More

SCSM – Data Warehouse Installation Error “_PopulateUserRoles”

Install Information

When installing the SCSM Data Warehouse Management Server, it is really annoying when the installer reaches almost the end, and then fails and rolls back… Then, to make things worse, no useful error is returned and nothing useful in the installation log. One such example is where is fails with the message that _PopulateUserRoles failed.  I received this recently so went diving into the setup log to find a bit.. Read More

SCSM – Changing the Workflow Management Server

CMDB Source

Recently, I had to upgrade the infrastructure for a Service Manager management group, and as part of this upgrade I had to change the workflow management server to a newly built management server.  At first, this looked like a straight forward process as defined on Microsoft TechNet. https://technet.microsoft.com/en-us/library/hh524221.aspx I prepared the new management server, run the SQL query, and restarted the System Center services, and everything was completed successfully.  After.. Read More

SCSM – Preventing MPSync Issues

DW MP's

Within a Service Manager environment, there are two management groups, one operational management group and one data warehouse management group.  In order for data to be committed to the data warehouse correctly, management packs (sealed only) that are in the operational management group need to be sync’d over to the data warehouse management group, and the versions of the management packs needs to be the same in both.  This sync.. Read More

System Center 2012 R2 Service Manager – Moving the Data Warehouse Management Server and Reporting

Microsoft System Center

Evening All, As it’s a nice quiet bank holiday weekend, I thought I would take the opportunity to write up my experience this week with attempting to move the Data Warehouse Management Server and the Reporting Server in my Service Manager management group. The reason for wanting to move these components was to move all onto a newly implemented Hyper-V platform, as well as to reclaim Enterprise SQL licenses that.. Read More