Unable to set up Email Channel: Email is currently used by another Service Management project

お困りですか?

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

コミュニティに質問


プラットフォームについて: Server、Data Center、および Cloud (状況に応じる) - この記事はアトラシアンのサーバーおよびデータセンター プラットフォーム向けに記載されていますが、Atlassian Cloud のお客様も記事の内容を利用できる可能性があります。この記事で説明されている手順の実施が役立つと考えられる場合、アトラシアン サポートにお問い合わせのうえ、この記事を紹介してください。

問題

Users are not able to configure Email Request in Jira Service Desk. The following error message appears:

The email address you entered is currently used by another service project. Please choose another email address. Check out our troubleshooting docs for help resolving the issue.

診断

診断ステップ

  • Check if there is an existing project that is currently using that email address
  • If there is none, you can then check further if you are affected by this problem.

原因

The email address is somehow not deleted from the database properly when the corresponding project is removed.

ソリューション

Remove the "residue" of the problematic email address from the database.

  1. Run the following query to find the deleted project that contains problematic email address. If it returns any result, you can use below resolution.

    select * from "AO_54307E_VIEWPORT" where "PROJECT_ID" not in (select id from project);
  2. Check all email addresses in the database.

    select * from "AO_2C4E5C_MAILCONNECTION";
  3. Backup the database before proceeding with below steps.

  4. Bring down Jira and run below queries.

    delete from "AO_2C4E5C_MAILHANDLER" where "MAIL_CHANNEL_ID" in (select "ID" from "AO_2C4E5C_MAILCHANNEL" where "PROJECT_ID" not in (select id from project));
    delete from "AO_2C4E5C_MAILCHANNEL" where "PROJECT_ID" not in (select id from project);
    delete from "AO_2C4E5C_MAILCONNECTION" where "ID" not in (select "MAIL_CONNECTION_ID" from "AO_2C4E5C_MAILCHANNEL");
    delete from "AO_54307E_EMAILCHANNELSETTING" where "SERVICE_DESK_ID" in (select "ID" from "AO_54307E_SERVICEDESK" where "PROJECT_ID" not in (select id from project));
  5. Bring up Jira.

 

最終更新日 2020 年 11 月 23 日

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

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