Summary
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.
Workaround
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.
- Take a backup of Grid_LicenseComputerConsumptionListModelByLicense located in SSMS at Compliance database > Programmability > Functions > Table-Valued Functions.
- Run one of the scripts for your affected version of FlexNet Manager Suite, located in this article.
· FNMS 2022 R2(ModifiedScript_2022R2.sql) for FlexNet Manager Suite 2022 R2
· FNMS 2023 R1(ModifiedScript_2023R1.sql) for FlexNet Manager Suite 2023 R1
Fix status
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)
Other information
Affected components: Software license management, Web UI
Master issue ID: IOK-1079122
Also known as: ITAM-3866
