Reconciliation not working

Reconciliation not working

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
Labels (1)
Was this article helpful? Yes No
0% helpful (0/2)
Comments

Hi,

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

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

The modified LicenseCreateUpdate.xml has been attached to this article as LicenseCreateUpdate_new.xml Hope it helps.
Version history
Revision #:
2 of 2
Last update:
‎Jul 25, 2019 09:06 PM
Updated by:
 
Contributors