Violation of UNIQUE KEY constraint '_ActionersUnique'

Was originally getting an error in the event log stating:

Violation of UNIQUE KEY constraint '_ActionersUnique'. Cannot insert duplicate key in object 'dbo._Actioners'.

After following steps to clear the Actioners in the following post:

I am now getting the following error in the Workspace:

Violation of UNIQUE KEY constraint '_ActionersUnique'. Cannot insert duplicate key in object 'dbo._Actioners'. The statement has been terminated.

Any suggestions?

Page 1 / 1

I have also seen this error when somebody inserts a trailing space before/after the actioner's name.

Do a backup and try this. If this works, you probably need to scan your process destination rules to see where this trailing space is coming from.

UPDATE _Actioners
SET ActionerName = LTRIM(RTRIM(ActionerName))

That worked like a charm! Thanks Johnny.

Sign up