Skip to main content

Error: 'The create unique index statement terminated because a duplicate key was found for the object name dbo.orc_TaskRelations'

Written by Charnjit Singh Dharival

Full error message when trying to upgrade Orchestrate:
​
​An unexpected error occurred. Please report this problem to your system administrator with the following information:
System.Data.SqlClient.SqlException: 'the create unique index statement terminated because a duplicate key was found for the object name dbo.orc_TaskRelations and the index name IX_orc_TaskRelations. The duplicate key value is (123,456,78). The statement has been terminated.


To resolve this issue Support will need to run some scripts on the database. Therefore please raise a new case online and reference the title of this article and please include details of the old version being upgraded from and the new version trying to be upgraded to.

Did this answer your question?