Upgraded SCCM to 1702. Now I can not import computers into All Systems (or any collection)
Before 1702 upgrade (my SCCM was 1610) I was able to import new computers to build associations for side by side Win10 deployments. Now, after a 1702 console upgrade, I am getting the following error:
Description = "Unexpected error when merging and updating discovery information";
ErrorCode = 2152205056;
File = "e:\\nts_sccm_release\\sms\\siteserver\\sdk_provider\\smsprov\\sspsite.cpp";
Line = 1333;
Operation = "ExecMethod";
ParameterInfo = "SMS_Site";
ProviderName = "WinMgmt";
SQLMessage = "[23000][2627][Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of UNIQUE KEY constraint 'MachineIdGroupXRef_AK'. Cannot insert duplicate key in object 'dbo.MachineIdGroupXRef'. The duplicate key value is (GUID:<myguid>,
5).";
SQLSeverity = 14;
SQLStatus = 2627;
StatusCode = 2147749889;
Blogs are pointing to a bug in 1702. Anyone know any additional information on MS fixes? A work around until a fix is provided by MS?
Error: Following computers have not been imported:
· Name: xxx
· MAC Address: xxx
· SMBIOS GUID:
· Source Computer:
· Choose Target Collection: c_xxx
Errors
1 The SMS Provider reported an error.ConfigMgr Error Object:instance of SMS_ExtendedStatus{ Description = "Unexpected error when merging and updating discovery information"; ErrorCode = 2152205056; File = "e:\\cm1702_rtm\\sms\\siteserver\\sdk_provider\\smsprov\\sspsite.cpp"; Line = 1333; Operation = "ExecMethod"; ParameterInfo = "SMS_Site"; ProviderName = "WinMgmt"; SQLMessage = "[23000][2627][Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of UNIQUE KEY constraint 'MachineIdGroupXRef_AK'. Cannot insert duplicate key in object 'dbo.MachineIdGroupXRef'. The duplicate key value is (<myguid>, 5)."; SQLSeverity = 14; SQLStatus = 2627; StatusCode = 2147749889;}; - kacsaba 7 years ago
https://social.technet.microsoft.com/Forums/en-US/fadf5381-793f-4a9b-865d-17c6b9cddbe4/cm-1702-importcmcomputerinformation?forum=ConfigMgrPowerShell - _nilsson_ 7 years ago