Details
-
Suggestion
-
Resolution: Unresolved
-
None
-
0
-
Description
Problem Definition
Missing Rank field(s) value(s) in the "AO_60DB71_LEXORANK" table can cause Ranking action (move issues up/down) to fail on Jira agile board.
- Issues with Rank values missing and while trying to re-rank the issue on the Agile Board we get this error on the UI:
- Missing issue ID 15810 (PRG-123)
jira854=# SELECT * FROM "AO_60DB71_LEXORANK" WHERE "ISSUE_ID" = '15810'; BUCKET | FIELD_ID | ID | ISSUE_ID | LOCK_HASH | LOCK_TIME | RANK | TYPE --------+----------+----+----------+-----------+-----------+------+------ (0 rows)
- Trying rank this issue will throw this error in the UI
- Missing issue ID 15810 (PRG-123)
- Currently Lexorank integrity checker does not identify these missing rank issues, all checks are green :
Suggested Solution
Having this check with a reported number of issues that should have a Rank value but doesn't will help with the following:
- make it clear why we're getting this error on the UI
- take necessary action (reindex) on the issue to build a rank field value
Workaround
- Run this SQL query to identify the issues missing a Rank field value in the table:
SELECT jiraissue.id FROM jiraissue LEFT OUTER JOIN "AO_60DB71_LEXORANK" ON jiraissue.id = "AO_60DB71_LEXORANK"."ISSUE_ID" AND "AO_60DB71_LEXORANK"."FIELD_ID" = '<RANK_CF_ID>' WHERE "AO_60DB71_LEXORANK"."ISSUE_ID" IS NULL;
- Depending on the number of issue IDs returned in the query you can either:
- Make a test modification on the issue (add a comment, transition the issue etc.)
- a couple issues?: Manually run this REST call to index the issue:
POST https://<BASE-URL>/rest/api/2/reindex/issue?issueId=<$ISSUE_ID>
- 100s of issues?: Write a small script and hit the above API for each issue IDs
- 1000s and more?: Run a lock and reindexing
Technically, you can run any reindexing operation for this issue id(s) returned. However, based on the situation you're in you can choose from the options above.
Attachments
Issue Links
- is related to
-
JSWSERVER-20910 Remove the ability to have multiple Rank Fields
- Gathering Interest
- is cloned by
-
FLASH-2886 Loading...
- mentioned in
-
Page Loading...