A new Flexera Community experience is coming on November 25th, click here for more information.

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

Summary

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SoftwareLicenseAllocation_ComplianceUser

Synopsis

Compliance import fails with following error

Failed to import inventory devices with error message 'The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SoftwareLicenseAllocation_ComplianceUser". The conflict occurred in database "FNMSCompliance", table "dbo.ComplianceUser_MT", column 'ComplianceUserID'.
The statement has been terminated.
Added 0 new user allocation(s) from the source database connections.'

Discussion

Updated writer LicenseCreateUpdate.xml

Workaround

1. Take a back up of the original LicenseCreateUpdate.xml located here - C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\

2. Copy the attached LicenseCreateUpdatel to the above location

3. Run a reconcile
Was this article helpful? Yes No
0% helpful (0/2)
Comments
nagaeendra
By
Level 6

Hi,

I suppose this is for FNMS 2018 R2, and i don't see any attached file.

jiten_patel
By
Level 2

I'm getting this same error,  is there a way to get the LicenseCreateUpdate.xml file referenced in the workaround above?

mge
By
Flexera Alumni
The modified LicenseCreateUpdate.xml has been attached to this article as LicenseCreateUpdate_new.xml Hope it helps.
Version history
Last update:
‎Jul 25, 2019 09:06 PM
Updated by: