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