Error: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_AccessedSoftwareOccurrence_AccessedSoftware"

[#1]

Summary

This article describes a problem that may occur in Writer 'WriteAccessedSoftwareOccurrence' during Reconcile

Symptoms

Reconcile fails and like the following error is logged in importer.log on FlexNet Manager Suite 2016.

2016-09-09 11:51:55,103 [INFO ]       All retries have been attempted for Writer 'WriteAccessedSoftwareOccurrence'
2016-09-09 11:51:55,149 [ERROR]       System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_AccessedSoftwareOccurrence_AccessedSoftware". The conflict occurred in database "FNMP", table "dbo.AccessedSoftware_MT".
Deleted 10 accessed software occurrence which does not exist in source
Deleted 4 accessed software records which has all the occurrences removed
Updated 11111 AccessCount of accessed software occurrence records for existing accessed softwares
The statement has been terminated.
Inserted 0 new accessed software occurrence records
   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 asyncWrite)
   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:d14b0e70-b836-4f75-807f-3e5939667b71
Error Number:547,State:0,Class:16

Cause

This issue had been idendified as Bug # IOJ-1776872 (FNMS-35999).

Resolution

The bug had been fixed in FlexNet Manager Suite 2016 R1 SP1.

Workaround

The patch is available under attachment file 'FNMS-35967.zip'.
Please follow the 'readme.txt' instructions to apply the patch on your system. Carefully backup before apply the patch is always recommended.

** Note !! The 2016 R1 Cumulative update 1 doesn't include the fix. Therefore be aware if you applied the patch before CU migrate , CU will revert back to default defect status.