How to configure Jira Service Management to process old emails
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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.
*Except Fisheye and Crucible
Purpose
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.
Solution
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.
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
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';