Summary

Symptoms

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

Resolution

Workaround