FNMS License Reconcile failure at Writer - RemoveMissingComputersAndAssociatedProperties: The DELETE statement conflicted with the REFERENCE constraint "FK_OracleFeature_ScannedInstanceID". The conflict occurred in database "FNMSCompliance", table "dbo.OracleFeature_MT", column 'ScannedInstanceID'.

FNMS License Reconcile failure at Writer - RemoveMissingComputersAndAssociatedProperties: The DELETE statement conflicted with the REFERENCE constraint "FK_OracleFeature_ScannedInstanceID". The conflict occurred in database "FNMSCompliance", table "dbo.OracleFeature_MT", column 'ScannedInstanceID'.

Description

A FNMS product defect ID (IOJ-2150913) has been identified which will cause the FNMS License Reconcile failed in the Writer 'RemoveMissingComputersAndAssociatedProperties' steps.

The failure message can be found in either import.log with the following wordings:

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.

 

Resolution

This problem under consideration to be addressed in a future release.


** Please be advised 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.

Was this article helpful? Yes No
No ratings
Version history
Revision #:
4 of 4
Last update:
‎Sep 24, 2020 08:19 PM
Updated by:
 
Contributors