Let’s find out the solution for ConfigMgr Secondary Server Upgrade Issue in the production environment. You need to have SQL permissions to try this solution. We always recommend testing this solution in an isolated environment first.
You can start the installation of the secondary server once the parent primary server is upgraded to the latest version of ConfigMgr. Let’s start the upgrade of the SCCM Secondary Site Server Upgrade.
Error – ConfigMgr Secondary Server Upgrade
The Secondary server upgrade was not proceeding further due to the site GUID information missing from the SC_SiteDefinition_Property table in the Primary server database.
CSiteControlSetup::ReadSiteGuidFromSCF: Site definition property for site GUID
This could have happened since I have run the ‘Retry secondary site’ option.
- Found there was no update on the Configmgrsetup.log on the secondary.
- Looked at the Primary hman.log and found the below entry.
Troubleshoot Secondary Server Upgrade Issue using hman.log
We tried to check the HMAN.log to understand the problem with the Configuration Manager (a.k.a SCCM) secondary server upgrade issue. We found the following issues with secondary server upgrades.
Start upgrading secondary site DK2 – SMS_HIERARCHY_MANAGER –
CSiteControlSetup::ReadSiteGuidFromSCF: Site definition property for site GUID not found.
CHierarchyManager::InitSiteControl : Failed to initialize installmap content for Secondary site [DK2].
Cannot upgrade site control file for this secondary site. Will not upgrade this secondary site.
INFO: .SLG file not found – SMS_HIERARCHY_MANAGER 9/10/2016 2:43:06 PM 11360(0x3048)
SQL Query Checks to confirm Secondary Server Upgrade Issue
We also checked the SQL DB to understand whether the secondary server site GUID is present in the database or not. However, there was no entry of SiteGuid in the database. You can copy the SQL query from the GitHub repository.
There was no result.
select ID from ServerData where sitecode = 'DK2' ID= 292145
Solution – ConfigMgr Secondary Server Upgrade Issue
- Take a backup of the Primary database.
- Run the below query and updated the SC_SiteDefinition_Property table with the secondary details.
INSERT INTO SC_SiteDefinition_Property VALUES(292145 , ‘SiteGUID’, ”, ”, 0)
- Also updated the Build number and the version in the site table for the DK2 site with SCCM 2012 R2 version as it was showing R2 SP1 version due to the previous attempt failed.
update sites set BuildNumber=’7958′ where sitecode=’DK2′
update sites set version=’5.00.7958.1000′ where sitecode=’DK2′
- Also updated the status to 7 to bring it to the Upgrade failed status.
update sites set status=7 where sitecode=’DK2′
- Reinitiated the upgrade process again and monitored the log flow
From the Hman.log we found the upgrade notification has been sent to the Secondary.
Check HMAN.log to understand the process of ConfigMgr Secondary server upgrades.
HierarchyManager::ProcessSiteModeSettings: secondary site DK2 has the same site mode settings as the current site SMS_HIERARCHY_MANAGER
Created site control notification for site DK2 SMS_HIERARCHY_MANAGER
INFO: DEEPAK.MECM.DK.com is a valid FQDN. SMS_HIERARCHY_MANAGER
Confirmation of Issue is Fixed ConfigmgrSetup.log
Looked at the ConfigmgrSetup.log from Secondary and found the logs are getting updated and the upgrade was completed successfully. Try to fix ConfigMgr Secondary Server Upgrade Issue.
INFO: Configuration Manager Setup full version is 5.00.8239.1000 Configuration Manager Setup 9/10/2016 3:46:53 PM 10792 (0x2A28) INFO: Deleting Inbox Rules registry key. Configuration Manager Setup 9/10/2016 3:46:53 PM 10792 (0x2A28) INFO: Creating Inbox Source registry key … Configuration Manager Setup 9/10/2016 3:46:53 PM 10792 (0x2A28) INFO: Verifying inbox folder permissions … Configuration Manager Setup 9/10/2016 3:46:53 PM 10792 (0x2A28) INFO: SQL Connection succeeded. Connection: SMS ACCESS, Type: Secure Configuration Manager Setup 9/10/2016 3:46:54 PM 10792 (0x2A28) INFO: send message 0x00050051 to parent Configuration Manager Setup 9/10/2016 3:46:54 PM 10792 (0x2A28) INFO: Automatic Updates detection task was called – IAutomaticUpdates->DetectNow returned 8024a000 Configuration Manager Setup 9/10/2016 3:46:54 PM 10792 (0x2A28) INFO: Configuration Manager Setup – secondary site upgrade completed. Configuration Manager Setup 9/10/2016 3:46:54 PM 10792 (0x2A28) INFO: send message 0x00050002 to parent Configuration Manager Setup 9/10/2016 3:46:54 PM 10792 (0x2A28) **************************************************** ***** Exiting ConfigMgr 2012 Setup Bootstrapper ***** *****************************************************
Disclaimer – We don’t take responsibility if any issue occurred by following these SQL Queries. MS Doesn’t support SQL DB Modification. Execute at your own risk.
- SCCM Secondary Site Upgrade Issue FIX by Kannan – https://www.anoopcnair.com/sccm-secondary-site-upgrade-issue/
- To find the site value indicating a request for secondary site status – https://docs.microsoft.com/en-us/sccm/develop/reference/core/servers/configure/sms_site-server-wmi-class
My name is Deepak Rai, and I am a Technical Lead on SCCM and Intune with more than 14 years of experience in IT. My main domain is SCCM (AKA ConfigMgr, CB, MECM, etc.), Intune, and Azure (Runbooks). I have worked on several platforms (Active Directory, Exchange, Veritas NETBACKUP, Symantec Backup Exec, NDMP devices Like Netapp, EMC Data Domain, Quantum using Backup Exec 2010 and 2012, HP storage works 4048 MSL G3, Data Deduplication related troubleshooting.) in these 13 years but at last ended up to the technology from which I started as IT Engineer (SCCM).