Summary

Symptoms

When performing an import for SCCM from an Inventory Beacon this will fail with the following error message:

"The MERGE statement conflicted with the FOREIGN KEY constraint "FK_ComplianceComputer_ComplianceDomain". The conflict occurred in database "<DatabaseName>", table "dbo.ComplianceDomain_MT", column 'ComplianceDomainID'. The statement has been terminated. Added 0 Computers from the source database connections. Computer: Added 0 Computers from the source database connections.".

Cause

The error message is caused by a known issue when importing multiple SCCM datasources using an Inventory Beacon.

Resolution

The issue reference number for this is "FNMS-26880" and this is currently scheduled to be permanently resolved in FlexNet Manager Suite 2015 R2 SP1.

Workaround

Attached to the KB is the current workaround for this issue, the steps below can be used to apply the fix.

-Download the updated Domain.xml in the attached zip "DomainUpdated-FNMS-26880.zip".

-Backup the current Domain.xml from the default location "C:\programdata\flexera software\compliance\importprocedures\writers\Domain.xml" .

-Replace the Domain.xml with the file extracted from the zip.

-Re-run the failed imports.