Summary
When an application recognition library (ARL) update is applied that attempts to delete an application that is referenced in Technopedia crosswalk data, the update may fail.
Details
When this issue occurs, logging similar to the following appears in the C:\ProgramData\Flexera Software\Compliance\Logging\recognition.log file generated by the library update process:
2021-01-27 17:42:59,243 [ecognition.Recognition] [INFO ] SQL Server returned error code 547 : line: 154 The DELETE statement conflicted with the REFERENCE constraint "FK_TechnopediaProductReleaseInfo_SoftwareTitleID_TS". The conflict occurred in database "FNMSCompliance", table "dbo.TechnopediaProductReleaseInfo_MT", column 'SoftwareTitleID_S'.
Cause
This issue is caused by a logic error which results in the referencing Technopedia crosswalk data not being deleted.
Fix status
This issue has been fixed in the following FlexNet Manager Suite releases: 2022 R2 (On Premises), 2022 R2 / Nov 2022 (Cloud)
Other information
Affected components: Content libraries, Integration: Technopedia
Master issue ID: IOK-928098
Also known as: FNML-76686
Related Articles
ARL update may fail with error if Technopedia crosswalk data is installed: DELETE statement conflicted with the REFERENCE … 5Number of Views RemoveMissingComputers writer may fail with error: The DELETE statement conflicted with the REFERENCE constraint "FK_Virtu… 4Number of Views RemoveMissingComputersAndAssociatedProperties import writer step may fail with error - 'The DELETE statement conflicted wi… 4Number of Views ApplicationDeletion import writer step may fail with error: DELETE statement conflicted with the SAME TABLE REFERENCE cons… 4Number of Views Import may fail at step "WriteComputers - Insert new computers" with error: The DELETE statement conflicted with the REFER… 4Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
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. | |
Case id: 00001065
Activity: Status change: 2 hours ago