In FlexNet Manager Suite versions 2022 R2, 2023 R1, and 2023 R2, a problem can occur that produces the following error in the WebUI log:
[ERROR 2023-08-18 10:39:10,647 39157783ms b.Core.UnhandledErrors] An unexpected error occurred (36e7a994-a336-4218-96aa-39a9c702e8b4)
System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_#BC531FF_3214EC2776DBAAEC'. Cannot insert duplicate key in object 'dbo.@InstallsAllocations'. The duplicate key value is (xxxxxx).
An issue in the function Grid_LicenseComputerConsumptionListModelByLicense causes this error. It occurs due to a duplication of the ComplianceComputerID field within the dbo.ReconcileVirtualMachineLayer table.
As a result, there is an effect on the device labeled "VMhost" in the ComplianceComputer table and the virtual machine in the IM table. The virtual machine or "VM" is being erroneously converted into "VM host," leading to it possessing attributes of both a virtual machine and a host.
This issue will be resolved in the next FlexNet Manager Suite release, 2024 R1. Before the new release, follow the steps below to run the attached scripts and resolve the issue.
on Dec 15, 2023 03:27 PM - edited on Feb 07, 2024 09:33 AM by HollyM
Super simple to implement the fix and worked.
Thank you for the feedback @kevin_christens I am glad my Knowledge base article helped resolve your issue.