페이지 트리
메타 데이터의 끝으로 건너뛰기
메타 데이터의 시작으로 이동

 목적

JIRA Service Desk will only create a new ticket , for newer email send after the incoming mail is configured . However , when there's a case user need UNREAD email previously before the incoming mail is configured . The email by default will be ignored and issue won't be created.

 해결방법

Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.

  1.  Shutdown JIRA

  2. Backup database

  3.  Run below query :-

 

SELECT * FROM AO_2C4E5C_MAILCONNECTION;

Take note on the result , get the email address

     4.   Get the starting date you would like to create issue from the mail inbox . The database use EPOCH date , so you may need to convert the date . Go to [http://www.epochconverter.com/] for the converter. Get the Timestamp in milliseconds result.

    5. Update the PULL_FROM_DATE :-

UPDATE AO_2C4E5C_MAILCONNECTION SET PULL_FROM_DATE = [NEW EPOCH DATE] where EMAIL_ADDRESS = 'EMAIL ADDRESS FROM CHANNEL';

     Change the date and email address value.


     6.  Then restart JIRA .

Run the testing at Test Environment before performing at Production Environment

 

 

 

 

 

 

 

  • 레이블 없음