The writers phase of the inventory import may fail while executing the step RemoveMissingComputersAndAssociatedProperties.
When this issue occurs, logging similar to the following will be found in the import log:
2020-09-22 12:17:00,636 [INFO ] RemoveMissingComputersAndAssociatedProperties 2020-09-22 12:17:06,424 [INFO ] Failed to execute Writer 'RemoveMissingComputersAndAssociatedProperties' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\RemoveMissingComputers.xml, at step line 40 Error: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_Instance_EnterpriseManagerInstance". The conflict occurred in database "FNMSCompliance", table "dbo.Instance_MT", column 'EnterpriseManagerInstanceID'. The statement has been terminated. Synchronized 0 row(s) of table 'ComplianceComputerPerOperator_PC' (57 ms) Retained 0 computers as virtual machines Removed 0 Computers that no longer exist in source database connections. Computer: Removed 0 Computers that no longer exist in source database connections. Removed 0 ContainerImage records as the host or image computer no longer exists. Removed 0 ComplianceComputer records for container images which are no longer installed. 2020-09-22 12:17:06,425 [INFO ] All retries have been attempted for Writer 'RemoveMissingComputersAndAssociatedProperties' 2020-09-22 12:17:06,429 [ERROR] System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_Instance_EnterpriseManagerInstance". The conflict occurred in database "FNMSCompliance", table "dbo.Instance_MT", column 'EnterpriseManagerInstanceID'. The statement has been terminated.
If you believe that this problem may be affecting you, contact Flexera Support to discuss whether a hotfix or workaround may be available that is applicable to your situation.
This issue has been fixed in the following FlexNet Manager Suite releases: 2020 R2 (On Premises), 2020 R2 / Nov 2020 (Cloud)
Affected components: Inventory import (read/write/export), SAM for Oracle
Master issue ID: IOJ-2150912
Also known as: FNML-71834
Apr 20, 2022 02:28 PM - edited Jun 12, 2022 03:49 AM