Summary
This article describes a problem that may occur in Writer 'WriteAccessedSoftwareOccurrence' during ReconcileSymptoms
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:16Cause
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.
Was this helpful?
Related Articles
Import writers step "Syncs the reconcile staging tables to main tables" step may fail with error: 'The INSERT statement co… 10Number of Views CreateVDIUserConnections writer step may fail with error: The INSERT statement conflicted with the FOREIGN KEY constraint … 5Number of Views License reconciliation failure: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SoftwareLicenseGroupPo… 5Number of Views Business adapter creating/updating SAPSystem records with a NULL SAPSystemLandscapeID fails with error: "The INSERT statem… 3Number of Views Writer step WriteContainerPods may fail with error if writers are run individually and a device has been deleted since the… 5Number of Views
Revenera Assistant
Online
Hi, I am Reva - Ask me anything.
Updates
No new updates
Chat
Home
Updates
/**/
Thanks for the feedback!
Your feedback has been saved.Rate this response:
1
2
3
4
5
Add Additional feedback ( Optional )
0/240
English
English
Language changed successfully
Something went wrong
Email sent successfully
Something went wrong
Case create successfully
Are you sure you want to cancel
the case creation?
Please select a product to submit the case.
Please select a product version to submit the case.
0/255
Upload Attachment
File Upload
Maximum file
size allowed is 3 MB.
File type
not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to cancel the case creation?
Case closed successfully
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
File Upload
Maximum file
size allowed is 3 MB.
File type
not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
© 2026 Flexera Software. All Rights Reserved.
Case id: 00001065
Activity: Status change: 2 hours ago