How to fix a failed project automation rule because of the duplicated key?

[Vera Valshonok]

I am trying to fix a failed project automation rule: when the issue of specific issue type is created 2 fileds should change to (...set by me). The rule fails sometimes: Unexpected error executing rule:Duplicate key and shows this key.

Are there ways to fix it?

[Guilhem Dupuy]

Hello,

Have you checked that you don't have a duplicated field, ie a field that is appearing more than once on a defined Screen ?

You can check this by running the following query to your database :

select f.name, i.fieldidentifier, count(*)
from fieldscreen f, fieldscreenlayoutitem i, fieldscreentab t
where f.id = t.fieldscreen
and i.fieldscreentab = t.id
group by f.name, i.fieldidentifier having count(*) > 1;

If you do have a duplicate, the query will return the Screen where a duplicate exists and the concerned field

You can find extra explanations about this process on the following article :

Duplicate Key Error 

Hoping it will help you,

Guilhem