Getting Error “Another machine with the same SMBIOSGUID is found” while Adding a Host in SCVMM

 

So I am back to share some more interesting issues with you all.

In this particular case we were trying to add a Host machine to SCVMM 2012 R2. And although the Server was getting added in VMM, we were seeing the Error below in the Jobs:

 

Error (21201)

Another machine with the same SMBIOSGUID is found.

Recommended Action

An SMBIOS GUID should uniquely identify the machine. Please provide the correct value or contact the machine manufacturer to help update the hardware with correct information.”

 

So we removed the Host from VMM and we gathered the VMM traces while trying to add the Host back. And here is what we saw in the Logs:

 

649597 [1]1384.199C::‎2015‎-‎06‎-‎09 16:43:13.243 [Microsoft-VirtualMachineManager-Debug]4,4,SqlContext.cs,727,Disposing (SqlContext#264d9) {[rw] AddHostSubtask.RunSubtasktx = (SqlTransaction#7af68b) System.Data.SqlClient.SqlTransaction, currentTxRecord = (SqlTransactionRecord#22e) commandList: { n=1 { tx:(SqlTransactionRecord#22e) NQ:"dbo.prc_PMM_PhysicalMachine_Update(@Id=52f61feb-cf0e-4b91-b44f-cfb70683590c, @BMCType=0, @BMCModule=, @BMCAddress=, @BMCPort=, @SMBiosGuid=xxxxxxxxxxxxxxxxxx)", @6/9/2015 4:43:13 PM [+00:00:00.0468823] } } txRecordList: { n=1  { tx#558 AddHostSubtask.RunSubtask() +00:00:00.1103098 ReadCommitted canRetry: false commands: { n=1 { tx:(SqlTransactionRecord#22e) NQ:"dbo.prc_PMM_PhysicalMachine_Update(@Id=52f61feb-cf0e-4b91-b44f-cfb70683590c, @BMCType=0, @BMCModule=, @BMCAddress=, @BMCPort=, @SMBiosGuid=375d451b-9a1f-4b15-a4f0-9c70b1a7566b)", @6/9/2015 4:43:13 PM [+00:00:00.0468823] } } } } , conn = (SqlConnection#1a31af) { State: Open Database: VirtualManagerDB DataSource: Server.contoso.com\SCVMM,1433 PacketSize: 8000 ServerVersion: 11.00.3153 StatisticsEnabled: False WorkstationId: USATRAME0914 } },{00000000-0000-0000-0000-000000000000}
649630 [2]1384.199C::‎2015‎-‎06‎-‎09 16:43:13.328 [Microsoft-VirtualMachineManager-Debug]4,2,Task.cs,287,CarmineException [ex#36e] caught by SubtaskRun (catch CarmineException) [[(CarmineException#3368) { Microsoft.VirtualManager.Utils.CarmineException: Another machine with the same SMBIOSGUID is found.  An SMBIOS GUID should uniquely identify the machine. Please provide the correct value or contact the machine manufacturer to help update the hardware with correct information. --->

 

Looks like VMM Is trying to Update the Stored Procedure "dbo.prc_PMM_PhysicalMachine_Update" in SQL Database with the Object ID 52f61feb-cf0e-4b91-b44f-cfb70683590c and the SMBIOSGUID and that's where it fails.

 

So we followed the action plan below to first find the UUID of the Cluster node and then removed the existing entry of that Host from the DB:

 

1. Open an elevated command prompt and run wmic csproduct get uuid on the Cluster node with which we have the issue

2. That will give us the SMBIOS ID for that server

3. Check that the UUID exists in the SCVMM DB under the tbl_PPM_Physicalmachine  table.

4. Once you verify that the above UUID exists, take a VMM DB backup and then delete the UUIDs from the VMM db.

 

And after following the action plan, we were able to add the Host back to VMM, without any issues and Errors.

 

Author:

Nitin Singh

Support Escalation Engineer

Microsoft Security and Manageability Division