JIRA Agile ドキュメント

Jira Agile 6.3
GreenHopper 6.2
GreenHopper 6.1


Agile Knowledge Base Resources

  • Several actions such as issue ranking, move, export are failing



atlassian-greenhopper.log に次のメッセージが表示される。

Details: ------- org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getHtml' in class com.atlassian.jira.issue.fields.layout.column.ExcelColumnLayoutItem threw exception com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=10700] at templates/jira/issue/table/macros.vm[line 115, column 34] at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:337) at 


Looking into the database, the AO_60DB71_LEXORANK is empty (has no rows in it)


It seems that the ranking has not been migrated to the Lexorank format.

This could be because the JIRA Agile plugin was downgraded in the past and the ranking never got migrated after that.


  • Get the rank field id from the above error message. In this case, it is 10700.
  • Jira を停止します。
  • Run the following query in the database replacing the <Rank id> with the rank field id in your case

    insert into AO_60DB71_LEXORANK values
    (<Rank id>,7,-9223372036854775808,NULL,NULL,'0|000000:',0);
    insert into AO_60DB71_LEXORANK values
    (<Rank id>,1,9223372036854775807,NULL,NULL,'0|zzzzzz:',2);
  • Jira を起動します。
  • Reindex JIRA

Help us improve!
  • ラベルなし