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

Known Issue: "Create license allocations from ImportedSoftwareLicenseAllocations" import step may fail with error: Violation of UNIQUE KEY constraint 'UQ_SoftwareLicenseAllocation'. Cannot insert duplicate key in object 'dbo.SoftwareLicenseAllocation_MT'. (IOK-931590)

Known Issue: "Create license allocations from ImportedSoftwareLicenseAllocations" import step may fail with error: Violation of UNIQUE KEY constraint 'UQ_SoftwareLicenseAllocation'. Cannot insert duplicate key in object 'dbo.SoftwareLicenseAllocation_MT'. (IOK-931590)

Symptoms

The inventory import process may fail with error details like the following appearing in logging:

2022-04-14 09:02:44,748 [INFO ]     Create license allocations from ImportedSoftwareLicenseAllocations
2022-04-14 09:02:49,172 [INFO ]       Failed to execute Writer 'Create license allocations from ImportedSoftwareLicenseAllocations' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\LicenseCreateUpdate.xml, at step line 28
Error: Violation of UNIQUE KEY constraint 'UQ_SoftwareLicenseAllocation'. Cannot insert duplicate key in object 'dbo.SoftwareLicenseAllocation_MT'. The duplicate key value is (1167, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>).
The statement has been terminated.
Added 0 new user allocation(s) from the source database connections.
2022-04-14 09:02:49,172 [INFO ]       All retries have been attempted for Writer 'Create license allocations from ImportedSoftwareLicenseAllocations'
2022-04-14 09:02:49,172 [ERROR]       System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ_SoftwareLicenseAllocation'. Cannot insert duplicate key in object 'dbo.SoftwareLicenseAllocation_MT'. The duplicate key value is (1167, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>).
The statement has been terminated.
Added 0 new user allocation(s) from the source database connections.

Mitigation

A possible cause of this issue is encountering a situation where user or inventory device details are updated by a user or other process while an inventory import process is running. If this occurs it is likely that the same problem will not occur on subsequent inventory import processes, so attempting to run the inventory import process again may result in a success.

Fix status

This issue is still open but not currently scheduled to be addressed.

Other information

Affected components: Inventory import (read/write/export), Software license management

Master issue ID: IOK-931590

Also known as: FNMS-76384

Labels (1)
Was this article helpful? Yes No

Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.

No ratings
Version history
Last update:
‎Sep 21, 2022 02:31 PM
Updated by: