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-23 03:06:41,408 [INFO ] RemoveMissingComputersAndAssociatedProperties 2020-09-23 03:06:47,344 [INFO ] Failed to execute Writer 'RemoveMissingComputersAndAssociatedProperties' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\RemoveMissingComputers.xml, at step line 49 Error: The DELETE statement conflicted with the REFERENCE constraint "FK_OracleFeature_ScannedInstanceID". The conflict occurred in database "FNMP", table "dbo.OracleFeature_MT", column 'ScannedInstanceID'. The statement has been terminated. Synchronized 0 row(s) of table 'ComplianceComputerPerOperator_PC' (31 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-23 03:06:47,345 [INFO ] All retries have been attempted for Writer 'RemoveMissingComputersAndAssociatedProperties' 2020-09-23 03:06:47,349 [ERROR] System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_OracleFeature_ScannedInstanceID". The conflict occurred in database "FNMP", table "dbo.OracleFeature_MT", column 'ScannedInstanceID'. The statement has been terminated.
This issue occurs when some data related to Oracle Database instance features that is held in the FlexNet Manager Suite compliance database needs to be deleted during the inventory import process (for example, because the computer the Oracle Database was installed on has been removed). The issue described here is a logic error whereby the data that should be deleted does not get deleted, leading to a database constraint violation.
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-2150913
Also known as: FNML-71833
Apr 20, 2022 02:28 PM - edited Jun 12, 2022 03:49 AM