FIX ConfigMgr Secondary Server Upgrade Issue | SCCM

0
FIX ConfigMgr Secondary Server Issue

Let’s find out the solution for ConfigMgr Secondary Server Upgrade Issue in the production environment.

Error – ConfigMgr Secondary Server Upgrade

The Secondary server upgrade was not proceeding further due to the site GUID information missing from SC_SiteDefinition_Property table in the Primary server database.

CSiteControlSetup::ReadSiteGuidFromSCF: Site definition property for site GUID

This could have happen since I have run ‘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 hman.log

We tried to check the HMAN.log to understand the problem with Configuration Manager (a.k.a SCCM) secondary server upgrade issue. We found following issues with secondary server upgrades.

Start upgrading secondary site DK2 - SMS_HIERARCHY_MANAGER - 9/10/2016       1:43:05 PM    11360(0x3048)
CSiteControlSetup::ReadSiteGuidFromSCF: Site definition property for site GUID not found.  SMS_HIERARCHY_MANAGER      9/10/2016       2:43:06 PM   11360(0x3048)
CHierarchyManager::InitSiteControl : Failed to initialize installmap content for Secondary site [DK2]. SMS_HIERARCHY_MANAGER      9/10/2016    2:43:06 PM   11360
Cannot upgrade site control file for this secondary site. Will not upgrade this secondary site. SMS_HIERARCHY_MANAGER      9/10/2016    2:43:06 PM   11360(0x3048)
INFO: .SLG file not found - SMS_HIERARCHY_MANAGER      9/10/2016    2:43:06 PM   11360(0x3048)

SQL Query Checks

We also checked the SQL DB to understand the whether the secondary server site GUID is present in the database or not. However, there was no entry of SiteGuid in the database.

select * from SC_SiteDefinition_Property where Name = 'SiteGUID' and sitenumber in (select  ID from ServerData where  sitecode = 'DK2')
There was no result.
select  ID from ServerData where  sitecode = 'DK2' ID= 292145
Altaro Office 365 Backup
Advertisement Altaro Office 365 Backup

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

HierarchyManager::ProcessSiteModeSettings: secondary site DK2 has the same sitemode settings as the current site SMS_HIERARCHY_MANAGER      9/10/2016    3:33:41 PM   11360(0x3048)
Created site control notification for site DK2 SMS_HIERARCHY_MANAGER      9/10/2016       3:33:41 PM         11360(0x3048)
INFO: DEEPAK.MECM.DK.com is a valid FQDN. SMS_HIERARCHY_MANAGER      9/10/2016    3:33:41 PM         11360(0x3048)
STATMSG: ID=3306 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_HIERARCHY_MANAGER" SYS=DEEPAK.MECM.DK.com SITE=DK1 PID=13944 TID=11360GMTDATE=Thu Sep 10 06:33:41.307 2016ISTR0="G:\SCCM\inboxes\hman.box\DK2.SCU" ISTR1="DK Secondary Site" ISTR2="DK2" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0                SMS_HIERARCHY_MANAGER      9/10/2016    3:33:41 PM   11360(0x3048)

ConfigmgrSetup.log

Looked at the ConfigmgrSetup.log from Secondary and found the logs are getting updated and the upgrade completed successfully. Try tofix 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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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