The content you are looking for has been archived. View related content below.
After importing data from Office 365, the import “writers” process fails with logging similar to the following:
2018-08-31 00:33:35,559 [INFO ] Failed to execute Writer 'Create license allocations from ImportedSoftwareLicenseAllocations' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\LicenseCreateUpdate.xml Error: Violation of UNIQUE KEY constraint 'UQ_SoftwareLicenseAllocation'. Cannot insert duplicate key in object 'dbo.SoftwareLicenseAllocation_MT'. The duplicate key value is (293, <NULL>, 8391, <NULL>, <NULL>, <NULL>, <NULL>). The statement has been terminated. Added 0 new user allocation(s) from the source database connections.
This issue can be caused by the query logic used in the “Create license allocations from ImportedSoftwareLicenseAllocations” procedure being unable to handle a situation where a user record is linked to multiple imported user details.
<Writer xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Name="Create license allocations from ImportedSoftwareLicenseAllocations" Order="1180" Retries="1"> <![CDATA[ INSERT INTO dbo.SoftwareLicenseAllocation ( SoftwareLicenseID, ComplianceUserID, NumberAllocated, SoftwareLicenseAllocationStatusID ) SELECT DISTINCT sl.SoftwareLicenseID, cu.ComplianceUserID, 1, 3 -- Permanent FROM dbo.ImportedSoftwareLicenseAllocation isla
This particular issue has been fixed in FlexNet Manager Suite releases noted in the “Fix status” section. There may be other root causes that result in similar symptoms affecting more recent FlexNet Manager Suite releases. See the following article for details: 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)
This issue has been fixed in the following FlexNet Manager Suite releases: 2017 R2 (On Premises), 2017 R2 / Aug 2017 (Cloud)
Affected components: Inventory import (read/write/export)
Master issue ID: IOJ-1818616
Also known as: FNMS-44380
Sep 26, 2022 02:36 AM - edited Nov 20, 2023 01:31 PM