Multiple rank fields causing errors while moving issues

[Marc]

Hi,

it appears that somehow there are four rank fields in our Jira installation. 

This is causing two major problems. 

1. We are unable to delete any issues at the moment

2. We are unable to move issues to a different type or project. 

Three of the fields are failing the balancing checks in the LexoRank management system. 

The error logs begins with the following lines: 

Log's referral number: ff42b050-a103-4af3-8c9d-597ee90ef53d
Cause
Referer URL: ..../secure/MoveIssue!default.jspa?id=10719
com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=10005]

Since the rank fields are locked and therefore cannot be deleted, what can we do to fix the issue? 

[Nic Brough -Adaptavist- · Accepted solution]

Be very careful to pick only one to keep.

Then do this for the ones you want to kill off: https://confluence.atlassian.com/jirakb/how-to-unlock-a-locked-field-779158866.html

[Marc]

Alright, thank you!

[Marc]

Okay it seems that the solution provide here fixed my problem.

Issues can now be moved and deleted without problems.

BUT, how do I delete the remaining three "unnecessary" rank-fields in our system?