In FlexNet Manager Suite versions 2022 R2 and 2023 R1, 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 corrected 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.
· FNMS 2022 R2(ModifiedScript_2022R2.sql) for FlexNet Manager Suite 2022 R2
· FNMS 2023 R1(ModifiedScript_2023R1.sql) for FlexNet Manager Suite 2023 R1
This issue has been fixed in the following FlexNet Manager Suite release: 2023 R2.1 / Jan 2024 (Cloud)
This issue is planned to be addressed in the following future FlexNet Manager Suite release: 2024 R1 (On Premises)
Affected components: Software license management, Web UI
Master issue ID: IOK-1079122
Also known as: ITAM-3866
Dec 18, 2023 01:27 AM - edited Feb 07, 2024 01:27 AM