CDR Tickets

Issue Number 4302
Summary [Genetics Directory] GP Mailer - re-mail issues
Created 2017-08-18 13:53:43
Issue Type Task
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2018-03-17 17:02:23
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.213119
Description

We have come across a few cases where a mailer was generated, sent and a response received. However, the same record was again selected for a re-mail as if no response was received and meanwhile, the responses to the mailers are not recorded. It may be a problem with the mailer check-in "program" because in some cases no mailer check-in date was recorded for mailers sent and received several months ago. Here are some examples on PROD:
1. Person record - CDR756388
i. Mailer was generated on 4/20
ii. Mailer response 5/4 (Not recorded in mailer history).
iii. Mailer re-mail 7/14
iv. Mailer response 7/16 (Not recorded in mailer history).
v. Mailer re-mail 8/16
vi. Mailer response 8/18 (Not yet recorded in Mailer history).
So, this record is being picked up for re-mail each time I run a re-mail (annual, I guess) and even though we have received multiple responses, the responses have not been captured in the attached mailer history report.

Please check attached screenshot. Also, please let me know if you want to see additional examples.

Comment entered 2018-03-07 08:47:06 by Kline, Bob (NIH/NCI) [C]

This is very strange. Here's what I get for that report on PROD:

Comment entered 2018-03-12 16:05:44 by Kline, Bob (NIH/NCI) [C]

will test with more recent mailers.

Comment entered 2018-03-12 17:47:51 by Osei-Poku, William (NIH/NCI) [C]

Recording the changes in the mailer history appears to have been resolved as the mailers I generated on 3/8 that have been completed are now recorded in the mailer history. However, for nearly all the ones I reviewed, there is a second mailer recorded in the history (a re-mail) that is recorded as having taken place on 3/6. However, I do not remember running this re-mailer job. There is also no record in the GP Emailers list to indicate that a mailer job was ran on 3/6. I checked my email to see if I can find the notification for 3/6 but didn't find any. I will attach a sample shortly.

Comment entered 2018-03-12 19:06:14 by Osei-Poku, William (NIH/NCI) [C]

I will attach a sample shortly.

I attached two samples one with admin changes and the other with no changes.

Comment entered 2018-03-13 06:28:21 by Kline, Bob (NIH/NCI) [C]

You did notice that the 3/6 mailers were sent out a year ago, not two days before the 3/8 mailers, right?

Comment entered 2018-03-13 12:31:19 by Osei-Poku, William (NIH/NCI) [C]

Oh no. I didn't look at that closely. Thanks! I will run a re-mail soon just to make sure these aren't picked up again.

Comment entered 2018-03-15 12:47:55 by Osei-Poku, William (NIH/NCI) [C]

I ran a re-mailer job last night which is not yet recorded on GP Emailers list. I will verify once they are recorded and close this ticket if no further needs to be performed.

Comment entered 2018-03-17 17:02:10 by Osei-Poku, William (NIH/NCI) [C]

The mailers appear to be working correctly on PROD now. The problems must have been fixed in the GAUSS release.

Attachments
File Name Posted User
mailer.png 2017-08-18 13:54:08 Osei-Poku, William (NIH/NCI) [C]
mailerHistory.png 2018-03-12 18:59:41 Osei-Poku, William (NIH/NCI) [C]
MailerHistoryWithAdminChanges.png 2018-03-12 19:01:38 Osei-Poku, William (NIH/NCI) [C]
screenshot-1.png 2018-03-07 08:46:02 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.001326