000036258 - Reminder Notifications using the One Email option are incomplete and editing notification templates causes loss of configuration information after upgrading to RSA Archer 6.3 P5

Document created by RSA Customer Support Employee on Apr 13, 2018Last modified by RSA Customer Support Employee on Apr 13, 2018
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000036258
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Database
RSA Version/Condition: 6.3 P5
Platform: Windows, SQL
IssueAfter upgrading to RSA Archer 6.3 P5 (6.3.0.5), Reminder Notifications using the One Email option do not get "CC" and "BCC" values from the template resulting in the notification going out to an incomplete mail distribution list.

Also, editing and saving the email template will result in the values set for "CC" and "BCC" to be lost.
CauseThe issue was introduced while attempting to resolve an issue where Reminder Notifications using the One Email option do not work when multiple Record Permissions are selected as recipients.

The change made resulted in a migration script not copying "CC" and "BCC" entries to the "To" field.
ResolutionA script has been developed that resolves the issue.  The script will correctly migrate the "CC" and "BCC" fields to the "To" field in the Email Notification template and also resolves the loss of configuration information when saving a Reminder Notification template.  The attached script is "Update Reminder Emails for 6.3 P5.sql" and will need to be run against each RSA Archer Instance database in your target environment.
NotesStarting with Archer 6.3 P5 (6.3.0.5) and higher, the One Email option is disabled for Reminder Notifications.
 
User-added image

Outcomes