When upgrading JIRA Agile to 6.4.3 with JIRA below 6.2, the upgrade task to convert the Global Rank field into LexoRank is not setting up the marker rows in the LexoRank table. This prevents ranking operations from working in any Agile board.
You may see a lot of entries in the log file similar to the below:
Run the below SQL to detect the condition:
If there are not exactly two results in the second query, for each result returned in the first query, then you are affected.
You'll need to insert the marker fields into the table manually:
- Backup JIRA before making any changes.
- Stop JIRA.
- Find out the field ID or IDs for LexoRank fields:
- For each field ID returned by the previous query, run a query like below, replacing <FIELD_ID> by the field ID:
- Start JIRA.