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