ARLRecreateSuitesDeletedByTrigger Violation of PRIMARY KEY constraint 'PK_SoftwareTitleSuite'

[#1]

Summary

This article describes an Application Recognition Library (ARL) import failure error message and how to resolve it.

Symptoms

The ARL library import generally happens weekly. The following error message can be encountered during a failed ARL import:

Exception caught: SQL Server returned error code 2627 : line: 12 in procedure: ARLRecreateSuitesDeletedByTrigger Violation of PRIMARY KEY constraint 'PK_SoftwareTitleSuite'. Cannot insert duplicate key in object 'dbo.SoftwareTitleSuite'. The duplicate key value is (175773).

Cause

There are some content data changes in the Nov 2015 release, however the ARL import script doesn't have correct error handling code, so the combination of the system data + the ARL content factory data updates causes this SQL violation error.

There is a sample Recognition.log file attached to this article that you can use to compare whether this is the same error thrown when the import reaches the 'ARLRecreateSuitesDeletedByTrigger: ' update.

Resolution

A permanent fix has been added in the Jan 31st 2016 release.

Try to download any version later than the above release date and it should fix the issue.

If the import still experiences the same issue, please send a support request to Flexera Technical support team by submitting an updated Recognition.log file.

Workaround

There isn't a workaround if you don't have a newer ARL version later than Jan 31st 2016.

We don't recommend a clean up your system data to avoid the SQL violation error. It should be handled by the ARL import script.