cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Known Issue: ARL update may fail with error if Technopedia crosswalk data is installed: DELETE statement conflicted with the REFERENCE constraint "FK_TechnopediaProductReleaseInfo_SoftwareTitleID_TS". (IOK-928098)

Known Issue: ARL update may fail with error if Technopedia crosswalk data is installed: DELETE statement conflicted with the REFERENCE constraint "FK_TechnopediaProductReleaseInfo_SoftwareTitleID_TS". (IOK-928098)

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 release: 2022 R2 / Nov 2022 (Cloud)

This issue is planned to be addressed in the following future FlexNet Manager Suite release: 2022 R2 (On Premises)

Other information

Affected components: Content libraries, Integration: Technopedia

Master issue ID: IOK-928098

Also known as: FNML-76686

Labels (1)
Was this article helpful? Yes No

Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.

No ratings
Comments

Hi Flexera support,

 

Do we have the fix released for this issue yet? One of our customer is having the same issue and it is affecting the ARL update atm.

 

Please let us know if you have the fix ready. Thank you.

 

Kind Regards,

Long Dinh

Please contact Flexera Support for guidance if this issue is affecting you.

@longdinh - I know Flexera Support worked with one of your customers yesterday to resolve this issue for one of your customers who had recently upgraded to the FlexNet Manager Suite 2022 R2 release. If you have a 2nd customer being affected then please log a case.

Version history
Last update:
‎Nov 29, 2022 01:27 PM
Updated by: