FNMS License Reconcile failure at Writer - RemoveMissingComputersAndAssociatedProperties: 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'.

FNMS License Reconcile failure at Writer - RemoveMissingComputersAndAssociatedProperties: 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'.

Description

A FNMS product defect ID(IOJ-2150912) 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-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 "FNMP", 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 "FNMP", 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.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at ManageSoft.Compliance.Importer.Logic.XML.Writer.Execute(IExecutionContext context)
   at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ExecuteWriters(ComplianceReader p_ComplianceReader, IExecutionContext context, String singleConnectionIdentifier)
ClientConnectionId:9cb83245-2d04-48a3-adb0-29f691f6a16e
Error Number:547,State:0,Class:16
2020-09-22 12:17:07,200 [INFO ]       Completed with error in 6 seconds
2020-09-22 12:17:07,201 [INFO ]     Released application lock Writer_Source_RemoveMissingComputers_ALL

 

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 #:
3 of 3
Last update:
‎Sep 24, 2020 08:20 PM
Updated by:
 
Contributors