SDL TMS 12.1 | CRQ-9830 | Tasks going to recovery during ApplyTM due to PRIMARY KEY error

Symptoms:
During the ApplyTM stage, some files are failing to recovery because of a database PRIMARY KEY error.

Explanation:
This happened as part of a "race condition" which caused the file to have two simultaneous workflows in the database.

Resolution:
When a file has multiple workflows in the database, the stored procedure has been amended to use only the live workflow.

SDL-hosted customers should contact SDL Support to arrange for this hotfix to be deployed.

Customers who host SDL TMS themselves should download the installer for SDLTMS12.1 Hotfix for CRQ-9830.exe from the following FTP site: ftp://ftp-emea.sdlproducts.com/SDL TMS/12.1/Hotfix/