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.
Workaround
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.
- Create a backup of Grid_LicenseComputerConsumptionListModelByLicense located in SSMS at Compliance database > Programmability > Functions > Table-Valued Functions.
- Run one of the three attached scripts for your affected version of FlexNet Manager Suite.
- FNMS 2022 R2(ModifiedScript_2022R2.sql) for FlexNet Manager Suite 2022 R2
- FNMS 2023 R1(ModifiedScript_2023R1.sql) for FlexNet Manager Suite 2023 R1
- FNMS 2023 R2(ModifiedSpript_2023R2.sqp) for FlexNet Manager Suite 2023 R2
