How to reset the project counter after moving issues

お困りですか?

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

コミュニティに質問

この記事はアトラシアンのサーバー製品にのみ適用されます。クラウドとサーバー製品の違いについてはこちらをご確認ください。

問題

After moving issues from project A to B (e.g. moving A-1 and A-2 issues from A to B) the issue keys moved from project A cannot be used anymore.

原因

This is an expected behavior. When an issue is moved JIRA retains the old issue key as reference. This happens because the old issue links continue to work (confluence links to the old issue, links send to customers and so on will continue to work).

回避策

Please note that after executing the steps below the old links (created before moving the issues) will be unavailable or pointing to the new issues with the same moved issue keys. This is very important change, since it can create a lot of confusing to users that already have links to the moved issues.

データベースの変更を行う場合は必ず事前にバックアップを取得してください。

Modifying data directly in JIRA's database is out of scope for Atlassian Support. These instructions are to help provide guidance if these changes are absolutely needed.


 To reset the project count you need to execute the following two steps (please substitute A in the below queries for your project key):

  1.     Reset the pcounter field from project table

    UPDATE project SET pcounter=0 WHERE pkey='A';
  2. Remove the rows referencing the old issue keys from moved_issue_key

    DELETE FROM moved_issue_key WHERE old_issue_key like 'A-%';

 After the above steps you should be capable to create issues starting from the number that was set in the pcounter field.


説明 After moving issues from project A to B (e.g. moving A-1 and A-2 issues from A to B) the issue keys moved from project A cannot be used anymore.
製品Jira
プラットフォームサーバー
最終更新日: 2018 年 9 月 12 日

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

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