Error 500 on Move Issue between projects

Hello,

On a fresh JIRA 6.3.1 installation with data imported from an On Demand backup, we are getting an Error 500 on moving an Issue between projects. Clone is also affected. No other issues are identified atm.

java.lang.RuntimeException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=13740]

Jira 6.3.1 with Agile 6.4.3 on a Win Server 2012R2 with MySQL DB.

Best regards,

João Duarte

4 answers

1 accepted

This widget could not be displayed.

I ended up having to open a ticket in the JIRA support. A simple check revelated that the MySQL table AO_60DB71_LEXORANK was empty, sign of a problematic import, maybe version missmatch from the On Demand to Local Server? Don't know.

Anyway, the following two SQL queries resolved my issue, please be careful with this, your problem might not be the same. Check the AO_60DB71_LEXORANK table first.

INSERT INTO AO_60DB71_LEXORANK (ID, FIELD_ID, ISSUE_ID, RANK, TYPE) VALUES (DEFAULT, 13740, -9223372036854775808, '0|000000:', 0);
INSERT INTO AO_60DB71_LEXORANK (ID, FIELD_ID, ISSUE_ID, RANK, TYPE) VALUES (DEFAULT, 13740, 9223372036854775807, '0|zzzzzz:', 2);
After this, do a full locked re-index.
You should now be able to move, export and clone Issues.

Edit: Atention! Your FIELD_ID might be diferent, mine was 13740 as seen on the 500 error. Use the correct ID.

Good luck!
Best regards,
João Duarte


thanks João Duarte, it worked for me ... you saved my day .. //Sathish

Ty for the quick response.

The Reindex never game me errors.

However, when I execute the SQL query SELECT FIELD_ID, TYPE, substring(RANK from 1 for 1) AS bucket FROM AO_60DB71_LEXORANK WHERE TYPE IN (0, 2);

the result is an empty set...

I checked on the original On Demand JIRA and the issue is not present there, only on the local server.

Best regards,

João Duarte

Just found out that the table AO_60DB71_LEXORANK is empty. Is this normal with an active Agile plugin?

This widget could not be displayed.

Ty for the quick response.

The Reindex never game me errors.

However, when I execute the SQL query SELECT FIELD_ID, TYPE, substring(RANK from 1 for 1) AS bucket FROM AO_60DB71_LEXORANK WHERE TYPE IN (0, 2);

the result is an empty set...

I checked on the original On Demand JIRA and the issue is not present there, only on the local server.

Best regards,

João Duarte

This widget could not be displayed.

I am having the same issue. It impacts both "move" and "clone" functionality. This article was relevant but didn't apply to me (there were no duplicate rows in that table that needed to be deleted):

https://confluence.atlassian.com/display/AGILEKB/Cannot+reindex+jira+due+to+Expected+exactly+2+rows+the+maximum+marker+row+and+the+lowest+ranked+row+for+rank+field

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

286 views 5 0
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