FIX ConfigMgr Secondary Server Upgrade Issue | SCCM

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.

Read More – How to Install Secondary server & How to FIX SCCM secondary server installation failure.

Patch My PC

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.

ConfigMgr Secondary Server Upgrade Issue
ConfigMgr Secondary Server Upgrade Issue – Credits to Kannan- More details https://www.anoopcnair.com/sccm-secondary-site-upgrade-issue/

Hman.log

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 completed successfully. Try to fix ConfigMgr Secondary Server Upgrade Issue.

                                ConfigmgrSetup.log

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 *****  ***************************************************** 

DisclaimerWe 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.

Resources

Author

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).

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.