Showing results for 
Show  only  | Search instead for 
Did you mean: 

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.

  1. Create a backup of Grid_LicenseComputerConsumptionListModelByLicense located in SSMS at Compliance database > Programmability > Functions > Table-Valued Functions.
  2. 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
Was this article helpful? Yes No
100% helpful (1/1)
Level 7

Super simple to implement the fix and worked.   

By Level 2 Flexeran
Level 2 Flexeran

Thank you for the feedback @kevin_christens  I am glad my Knowledge base article helped resolve your issue.  

Version history
Last update:
‎Feb 07, 2024 09:33 AM
Updated by: