CDR Tickets

Issue Number 5194
Summary Empty Board Member Correspondence Mailer
Created 2023-01-25 15:51:55
Issue Type Task
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2023-01-26 06:03:51
Resolution Won't Fix
Path /home/bkline/backups/jira/ocecdr/issue.337282
Description

The board member correspondence mailers are turning up empty when you receive the emails from PROD. There is no link or name to click on to get the email. Please see the attached sample documents. Both Victoria and I just tried it and got the same results on PROD. (I also tried on DEV and it worked without any problems, so the issue appears to be PROD only). 

PROD CDR Mailer Job Status.msg

 

Repro Steps:

  1. Click on Board Member Correspondence Mailers under the Board Managers main menu

  2. Select Pediatric Treatment Editorial Advisory Board under "Board"

  3. Select Advisory Board Invitation Letter under "Letter"

  4. Select name of any board member displayed under "Board Members"

  5. Click "Submit" and wait for the email response.

Comment entered 2023-01-25 21:46:19 by Kline, Bob (NIH/NCI) [C]

Looking at the logs we may have more than one problem (not sure).

First thing to look into is the failure to find the Editor in chief for the Adult Treatment board. That's the error message which shows up most frequently. Let's see what's left (if anything) after we solve that problem.

Comment entered 2023-01-26 06:03:51 by Kline, Bob (NIH/NCI) [C]

It looks like Franco Muggia was the EIC starting back in September of 2000, and he retired November 2021. The termination date for his reign wasn't recorded until this month, however, which explains why the mailer still works on the lower tiers.

The other problem I saw in the logs appears to have been triggered by someone trying to create an editorial board invitation letter for the Peds board, which has never had a miscellaneous document for the invitation paragraph, so until such a document gets created (and plugged into the lookup table in the code), mailers for that board will never work (though the Peds advisory board invitation should work).

So it seems to me that the software is behaving the way it should.

 

[EDIT: Went back and looked more closely at the document. Indeed, Peggy Nixdorf was the assistant, and Franco Muggia was the actual EIC. 😛]

Comment entered 2023-01-26 06:30:04 by Kline, Bob (NIH/NCI) [C]

As a side note, this seems to be a case in which the web site is ahead of the CDR, rather than behind it. 

So all that needs to happen for this mailer to work again is to plug the EIC TermStartDate element into CDR369849.

Comment entered 2023-01-26 11:15:16 by Osei-Poku, William (NIH/NCI) [C]

The mailers appear to be working after adding the TermStartDate info in the record. I will need to find out more about the misc doc.  Thanks!

Attachments
File Name Posted User
image-2023-01-26-06-27-41-953.png 2023-01-26 06:27:45 Kline, Bob (NIH/NCI) [C]
PROD CDR Mailer Job Status.msg 2023-01-25 15:49:57 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.001867