Issues in some projects cannot be ranked in JIRA Agile

Hello

We have one problem . In two projects when users want to rank a issue within a sprint the following error occures: JIRA Agile cannot execute the rank operation at this time. Other users may be ranking the issues that you are trying to rank. Please try again later.

Users of the projects were earlier (approx. 2 months ago) capable of ranking issues together with together with the fact that the test project I run i am also able to do it. So this has nothing to do with change of user permissions. Can anyone explain to me why it would work for me and not other of our projects? JIRA Agile board version is 6.7.12 if that information is useful. I have tried to both re-index the database and rebalance via the lexirank management screen.

2 answers

1 accepted

Accepted Answer
0 votes

Hi Haseeb,


Looks like you are facing this issue: https://jira.atlassian.com/browse/GHS-10843
Could you please follow the instructions highlighted on the ticket?
In case it does not work take a look here:
You take a look at this knowledge article as well: https://confluence.atlassian.com/jirakb/unable-to-rank-and-or-balancer-fails-to-complete-due-to-incorrect-database-collation-779158922.html

If you are using MS SQL 2012:
https://jira.atlassian.com/browse/JSW-12221
One more in case all the above does not work:

https://confluence.atlassian.com/jirakb/jira-agile-throws-jira-agile-cannot-execute-the-rank-operation-this-board-has-recently-been-configured-to-use-the-rank-field-when-execute-rank-operation-after-jira-agile-upgrade-779158591.html

Overtime there are other bugs in this area but they should be fixed in 6.7.x:

https://jira.atlassian.com/browse/JSW-11178

https://jira.atlassian.com/browse/JSW-10872

https://jira.atlassian.com/browse/JSW-11050

Please write back.
Cheers,
Peter T

Hi Peter

Thank you for your answer, I will do these steps when I have access to the database and let you know the end result smile 

Hi Peter

Sorry for taking so long, another collegue got it fixed with the second link https://confluence.atlassian.com/jirakb/unable-to-rank-and-or-balancer-fails-to-complete-due-to-incorrect-database-collation-779158922.html. The collation for the table AO_60DB71_LEXORANK was wrong and was updated with the content of the section "Microsoft SQL Server". 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

24,114 views 2 7
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you