How to configure Jira Service Management to process old emails
プラットフォームについて: 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 は除く
目的
Jira Service Management will only create a new tickets for email sent after the incoming mail handler is configured. Use cases may need unread email sent before the incoming mail is configured to be processed, however the email by default will be ignored and issues will not be created.
ソリューション
To workaround this behavior, it's possible to specify the date and time for Jira Service Management to start pulling e-mails using direct database manipulation.
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
Run following SQL query:
SELECT * FROM AO_2C4E5C_MAILCONNECTION;
- Take note from the result for the email address related to the Jira Service Management mailbox you want to modify.
- Get the starting date you would like to create issue from the mail inbox. The database uses epoch time, so you may need to convert the date. Go to http://www.epochconverter.com for the converter. Get the Timestamp in milliseconds result.
Update the PULL_FROM_DATE value by running the SQL query below, after you changed the date and email address values:
UPDATE AO_2C4E5C_MAILCONNECTION SET PULL_FROM_DATE = [NEW_EPOCH_VALUE] WHERE EMAIL_ADDRESS = 'EMAIL_ADDRESS_FROM_CHANNEL';