• Type: Bug
• Resolution: Fixed
• Priority: Low (View bug fix roadmap)
• Fix Version/s: None
• Affects Version/s: 6.4.0.3
• Component/s: None
• Labels:

  • affects-cloud
  • affects-server
  • fixme
  • warranty

1. error.png

   24/Jun/2014 6:43 AM

   36 kB

   Mauro Badii

[JSWSERVER-10843] Unable to Rank issues: Error: "Other users may be ranking the issues that you are trying to rank."

Bugfix Automation Bot made changes - 27/Mar/2019 11:25 PM

Minimum Version

New: 6.04

Owen made changes - 16/Oct/2018 1:06 AM

Workflow	Original: JAC Bug Workflow v2 [ 2853333 ]	New: JAC Bug Workflow v3 [ 2934437 ]
Status	Original: Resolved [ 5 ]	New: Closed [ 6 ]

Owen made changes - 25/Sep/2018 12:50 AM

Workflow

Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2545947 ]

New: JAC Bug Workflow v2 [ 2853333 ]

Ignat (Inactive) made changes - 01/Feb/2018 12:09 PM

Workflow

Original: JIRA Bug Workflow w Kanban v6 - Restricted [ 1550777 ]

New: JIRA Bug Workflow w Kanban v7 - Restricted [ 2545947 ]

Collapse comment: MattS added a comment - 09/May/2017 10:10 PM

MattS added a comment - 09/May/2017 10:10 PM

mysql> SELECT FIELD_ID, COUNT(1), RANK FROM AO_60DB71_LEXORANK GROUP BY FIELD_ID, RANK HAVING COUNT(1) > 1;
Empty set (18.08 sec)

worked for my on MySQL

Expand comment: MattS added a comment - 09/May/2017 10:10 PM

MattS added a comment - 09/May/2017 10:10 PM mysql> SELECT FIELD_ID, COUNT(1), RANK FROM AO_60DB71_LEXORANK GROUP BY FIELD_ID, RANK HAVING COUNT(1) > 1; Empty set (18.08 sec) worked for my on MySQL

Danilo Conrad made changes - 21/Mar/2017 5:16 PM

Description

Original: When trying to rearrange issues in the backlog or in Work mode, an error is displayed and it is impossible to reorder issues. Error message: "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." *How to verify:* When running the following query on the Jira database: {code}SELECT "FIELD_ID", COUNT(1), "RANK" FROM "AO_60DB71_LEXORANK" GROUP BY "FIELD_ID", "RANK" HAVING COUNT(1) > 1;{code} 1 or more lines are returned with duplicate ranks. *Temporary Solution:* As a sysadmin, issue a rebalance request by going to {{rest/greenhopper/1.0/lexorank/balance}} Notes: On OnDemand, create a support request at https://support.atlassian.com The rebalance may take several minutes to process.

New: When trying to rearrange issues in the backlog or in Work mode, an error is displayed and it is impossible to reorder issues. Error message: "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." *How to verify:* When running the following query on the Jira database: {code}SELECT "FIELD_ID", COUNT(1), "RANK" FROM "AO_60DB71_LEXORANK" GROUP BY "FIELD_ID", "RANK" HAVING COUNT(1) > 1;{code} 1 or more lines are returned with duplicate ranks.

Confluence Escalation Bot (Inactive) made changes - 16/Mar/2017 4:34 AM

Labels

Original: affects-server fixme warranty

New: affects-cloud affects-server fixme warranty

Confluence Escalation Bot (Inactive) made changes - 20/Feb/2017 2:57 AM

Labels

Original: fixme warranty

New: affects-server fixme warranty

Owen made changes - 07/Jul/2016 7:05 AM

Workflow

Original: JIRA Bug Workflow w Kanban v6 [ 909578 ]

New: JIRA Bug Workflow w Kanban v6 - Restricted [ 1550777 ]

Kiran (Inactive) made changes - 10/Aug/2015 1:02 AM

Remote Link

Original: This issue links to "Page (Extranet)" [ 82331 ]

New: This issue links to "Page (Extranet)" [ 82331 ]

Load more older events