PRIMARY KEY constraint 'PK_SoftwareLicenseProcessorPointsData'

[#1]

Summary

When running a running a reconcile, it fails with a PRIMARY KEY constraint 'PK_SoftwareLicenseProcessorPointsData' error

Symptoms

The following error is seen in the importer.log:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_SoftwareLicenseProcessorPointsData'. Cannot insert duplicate key in object 'dbo.SoftwareLicenseProcessorPointsData_MT'. The duplicate key value is (86, 69379, 558).

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_SoftwareLicenseProcessorPointsData'. Cannot insert duplicate key in object 'dbo.SoftwareLicenseProcessorPointsData_MT'. The duplicate key value is (87, 69379, 558).

Cause

This is caused by a VirtualMachine vm record belonging to a VMPool vmp where vm.HostComplianceComputerID != vmp.HostComplianceComputerID

The ImportedVirtualMachine and ImportedVMPool records appear to be correct but vm.VMPoolID is not being updated.

Resolution

1. Backup the database.
2. Run the attached SQL script ?TableReconcileVMLayer.sql? on the FNMS database.
3. Carry out a reconcile to see if the issue is resolved. If you encounter the same reconcile error again, and it's for a different key value* then please run through steps 2 and 3 again.

*The key value referred to, is contained in this part of the error message:
"The duplicate key value is (726, 14465, 32)"