Pie Chart Gadget showing Unknown as result

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。

問題

Using pie chart gadget in the dashboard, there are a portion where it returns Unknown.

For eg: Pie Chart : Returned Filter based on Reporter

Result: Unknown = 5% (16 issues)

  1. Clicking on the unknown link which opens the issue search navigator, there are less issue shown here ( either no issue or lesser than the 6 issue stated)
  2. Should be showing user name instead of 'Unknown'

原因

This is caused by there are issue that is holding obsolete data on the Reporter/Assignee field that is pointing to a user which is no longer in the system

  • If you manage to find the the 'Unknown' issue, you will notice that at the Reporter/Assignee field, the username is grayed out and wont be able to click it
  • This can be cause by a direct modification of cwd_user; by deleting the user directly from database
  • Deletion of user from external directory
  • Other unknown actions that lead to data integrity for the issues


ソリューション

ソリューションはアプリケーション全体の問題を修正するものであり、一般にハックに該当するようなものではありません。

  1. Jira を停止します。
  2. Perform the following in your database
  3. Replace XXXXX either with Reporter or Assignee column accordingly. 

    tip/resting Created with Sketch.

    Please perform a backup to your database prior to perform any modification to it.

    update jiraissue set XXXXX='' where lower(XXXXX) not in (select lower_user_name from cwd_user);
     
    eg: update jiraissue set reporter='' where lower(reporter) not in (select lower_user_name from cwd_user);
  4. Jira を起動します。
  5. Perform a full reindex
  6. You will notice that when you click on 'Unknown', the correct amount of issue is shown. Then, proceed to update the assignee or reporter field to a valid user manually or using bulk edit

最終更新日 2018 年 11 月 12 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.