Some users may experience issues accessing the case portal. For more information, please click here.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Known Issue: RemoveMissingComputersAndAssociatedProperties writer step may fail with error if removed Oracle instance was managed by Oracle Enterprise Manager: 'The DELETE statement conflicted with the REFERENCE constraint "FK_Instance_ScannedInstanceID"' (IOJ-2150912)

Known Issue: RemoveMissingComputersAndAssociatedProperties writer step may fail with error if removed Oracle instance was managed by Oracle Enterprise Manager: 'The DELETE statement conflicted with the REFERENCE constraint "FK_Instance_ScannedInstanceID"' (IOJ-2150912)

Description

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.

Resolution

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.

Fix status

This issue has been fixed in the following FlexNet Manager Suite releases: 2020 R2 (On Premises), 2020 R2 / Nov 2020 (Cloud)

Other information

Affected components: Inventory import (read/write/export), SAM for Oracle

Master issue ID: IOJ-2150912

Also known as: FNML-71834

Labels (1)
Was this article helpful? Yes No

Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.

No ratings
Version history
Last update:
‎Jun 12, 2022 03:49 AM
Updated by: