During an in-place Current Branch upgrade the installer failed on the CAS and multiple child sites and said to Contact your SQL admin.  After cracking open the ConfigMgrSetup.log there were “duplicate key” errors.  After confirming with Microsoft on deleteing these entries I was able to successfully upgrade the Hierarchy.

ConfigMgrSetup.log

ERROR: SQL Server error: [23000][1505][Microsoft][SQL Server Native Client 11.0][SQL Server]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name ‘dbo.CI_CurrentComplianceStatus‘ and the index name ‘CI_CurrentComplianceStatus_AK_AS_idx’. The duplicate key value is (261161, 9, 67150446, 0).

 

During a Current Branch in-place upgrade this paricular CAS and Child Sites had multiple duplicate key values for object “dbo.currentcompliance.status”.  The resolution was to run the follow query against the CAS and Child Sites that failed during the Upgrade.

Disable Triggers-

triggers

Query-

DELETE FROM CI_CurrentComplianceStatus WHERE CI_CurrentComplianceStatusID = 261161
DELETE FROM CI_CurrentComplianceStatus WHERE iTEMkEY = 67150446

Validate-

SELECT COUNT(*), ModelID, CIversion, ItemKey, UserID
FROM CI_CurrentComplianceStatus
GROUP BY ModelID, CIVersion, ItemKey, UserID
Having COUNT(*)>1

 

This is “AS-IS” no guarentees 🙂

LLP