SDL TMS - Job Error for Jobs created in Job Create Portal - 'Violation of PRIMARY KEY constraint' and 'Cannot insert duplicate key in object 'dbo.#tempWorkflowUsers'
000015107|4/8/2021 11:16 AM
Upon Creating a Job via the TMS Create Job screen the job instantly goes into a Job Error state with the following error:
Violation of PRIMARY KEY constraint 'PK__#tempWor__BEEAB84D399C3B97'.
Cannot insert duplicate key in object 'dbo.#tempWorkflowUsers'.
The duplicate key value is (29773108). The statement has been terminated
Remove any duplications of stages in the workflow and save the changes. Resubmit the files in a new Job.
The Workflow being used by this Job had somehow contained two instances on the same Workflow Stage - 'Convert Item'
This may have occurred due to this duplication of stages being possible in early versions of TMS but this is not allowed in 12.5 and up.