Pie chart and project overview showing incorrect status count in JIRA
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
問題
Pie chart gadget and Status Summary at Project Overview shows incorrect status count for a given issue status.
診断
This KB article may be useful if the problem shows the following characteristics:
- There is a missing status in both Pie Chart and Status Summary
- The missing status is being accounted in the status with incorrect number of issues
The inconsistency can be verified by a JQL search, since the search will return the correct number of issues for a given state.
The following screenshots were taken when the problem was in place:
The following screenshots were taken after the problem is resolved:
原因
For some unknown reason there are two status with the same sequence number in the issuestatus database table.
回避策
Each sequence number needs to have its own sequence number. Select the one of the doubled status and change it's sequence number to a number not used for any other status.
The following SQL query should solve the problem:
-
UPDATE issuestatus SET sequence=(SELECT max(sequence)+1 FROM issuestatus) WHERE pname=<STATUS_NAME>;Please change <STATUS_NAME> in the above query to the correct status name you want it's sequence to be updated.
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。