ConfigMgr 2012: DRS and SQL service broker certificate issues

Hi Folks, Today's post is about the much talked about feature on ConfigMgr 2012- Data Replication Service (DRS). The replication mechanism internally uses SQL Service broker and I am discussing the three common issues with SSB that can stop the replication.   Issue 1: In the SQL error log we see the following: 'Connection handshake…


The ConfigMgr 2012 R2 upgrade from ConfigMgr 2012 SP1 CU3 will fail if you have Pull DPs in your environment.

Hi Folks, Just sharing one of the upgrade issues that we have when we upgrade to R2 from ConfigMgr 2012 CU3 when pull dps are there in the environment.   Note: We have fixed the issue in our latest R2 bits. For more information:   Issue: ===== CAS and primaries went to the Maintenance…


The Distributed Views do not get created in ConfigMgr 2012 SP1 because of the login issue.

Hi Folks, The below post in of the new feature (Distributed views) in the DRS that was introduced in the ConfigMgr 2012 SP1 release. Distributed view in simple terms avoid the flow of the site data across the hierarchy as the views directly can fetch the data from the primary database. The views get created…


ConfigMgr 2012: SMSExec shuts down when we add the SUP role

Hi Folks, I had an interesting issue where when we try to add the SUP role, the SMSExec used to shut down. It was initially a bit difficult to understand that it is the SUP role that is making the SMSExec to shut. The final issue came out to be that when we try to…


ConfigMgr 2012: Upgrade to SP1 fails with "Arithmetic overflow error converting expression to data type int"

  Hi Folks, This post discusses about one of the upgrade issues that I worked on while Upgrading the ConfigMgr 2012 RTM to ConfigMgr 2012 SP1. Upgrading to SP1 fails with the error below in the ConfigMgrSetup.log: Arithmetic overflow error converting expression to data type int. : MDM_ExtractAppCIData Configuration Manager Setup 3/8/2013 8:00:25 PM 3532…


A look at transaction based replication in Configuration Manager 2007

Hi Folks, Here is a detailed post on the Transaction Based Replication in ConfigMgr 2007 that I have written some time back. You can go through the same below:     Hope that helps !!   Umair Khan Support Escalation Engineer | Microsoft System Center ConfigMgr  


Case Study: The updates returned from the Windows update are less than what is returned from the Reports they are using in ConfigMgr.

Hi Folks, This post is about a case study that illustrates the troubleshooting steps taken to modify an existing custom ConfigMgr report to return the correct results when compared to Windows update when checked on Internet. I have included the details and the path taken to achieve the same.  Issue: The updates returned from the…


WSUS: Using change.log to track updates that were declined (with scenarios)

  Hello Folks, Many a times we do get some issues where we need to find why an update was installed, or Update that were declined soon after an incorrect deployment. The below blog post illustrates the different scenarios recorded in the change.log when an update is declined. The good thing to notice here is it…


ConfigMgr: Troubleshooting High CPU utilization on the SQL server and Parallelism

  Hello Folks, This post is about troubleshooting CPU utilization of SQL Server hosting the ConfigMgr database. It talks about the general queries to find out the causes and talks specifically about parallelism.   To check which query is taking the Max CPU time run the following query     SELECT TOP 50 ObjectName =…