Scrum Boards Fail to Open With Re-Indexing Error
症状
Trying to access any Scrum board fails with the below error even after doing re-indexing:
atlassian-jira.log に次のメッセージが表示される。
2012-12-12 17:25:05,351 http-bio-8080-exec-38 WARN username 1045x955814x1 1wfrgko <<IP Address>> /rest/greenhopper/1.0/xboard/plan/backlog/data.json [web.rapid.plan.PlanningModeResource] JiraCopiedRestErrorCollection[errorMessages=[Scrum boards are currently unavailable. An administrator must perform a re-index before you can use Scrum board functionality.],errors={}]診断
This is applicable only if the installed version of JIRA Agile <= 6.1.2.
Please run the below SQL in the JIRA database:
SELECT propertyvalue from propertynumber WHERE ID in (SELECT ID FROM propertyentry WHERE ENTITY_NAME='GreenHopper.properties' AND PROPERTY_KEY='GreenHopper.Sprint.Index.Check.Necessary') If the above statement returns '1' as the query result, this article is applicable.
原因
There are two possible reason for this error:
- A background re-indexing is not sufficient to get the data updated for JIRA Agile. This is reported as a bug here GHS-7280 - Getting issue details... STATUS
- The JIRA Agile internal flag not getting reset even after re-indexing. Please see the related bug reported here - GHS-6954 - Getting issue details... STATUS
ソリューション
方法 1
The faults are corrected in 6.1.3 version of JIRA Agile and upgrading to the latest version of JIRA Agile will resolve this error.
方法 2
ステップ 1
Perform a full re-index of JIRA ('Lock JIRA and rebuild index' option as described in Search Indexing) and check whether the boards are functioning as expected.
If the above step does not resolve the issue, proceed to the next step below.
ステップ 2
To correct this error please perform the below steps:
- Jira をシャットダウンします。
Connect to JIRA database and run the below SQL command. The above command will give the ID of the entry which needs to be used in the next command.
SELECT ID FROM propertyentry WHERE ENTITY_NAME='GreenHopper.properties' AND PROPERTY_KEY='GreenHopper.Sprint.Index.Check.Necessary';Run the below SQL using the ID got in the previous command to update the database.
UPDATE propertynumber SET propertyvalue=0 WHERE ID = '<ID Got in the above command'; COMMIT;- Jira を再起動します。