Company: Link Technologies
Case No: L12066. Project: 12.30: LinkSOFT Version 12.30
Logged By: Sanjay (Link Technologies) on 16 Nov 2020 11:43AM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 17.00 (Weight: 17.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Rashna, Sanjay
Resolve By: Friday, 20 November 2020 11:59 PM [1253 days since logged date]
Status: Closed
Subject: Add an "Email notifications" Archive functionality to prevent high CPU Usage due to Email Attachments
Summary:    To avoid high CPU usage on the server, we need to archive email notifications as they can contain large amounts of data in the email body, especially if there are images
Audit Notes:Edited by sanjay on 07/12/20 16:53. Edited by rashna on 04/12/20 16:19. Edited by sanjay on 25/11/20 08:07. 
16 Nov 202011:46AM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-11-2020 03:43 PM Time Taken: 16.00

Development work for this case has been completed.

The change will be available in version:12.3.1116

1. The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Added a new table to archive email notifications
  2. When an email is sent, we immediately send it to the archive table
  3. When a resend if required, we move the email entry back into the notifications table (from the archive table) and process the resend

2. Affected Areas:

  1. Email Notifications

3. The issue was caused by:

  1. High CPU usage on AZURE environment

4. Notes
5. Next Step
: UAT

----------------------

Development Reference:

  1. New Table LT_SYS_Notifications_Archive
  2. Changed ID from INT to GUID
  3. Added procedures to archive and move entries as required
  4. No change to the interface

25 Nov 202008:07AM Comment 2 by Sanjay (Link Technologies) ETC was changed from 20/11/2020 to 20/11/2020
22 Dec 202002:06PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 22-12-2020 04:49 PM Time Taken: 1.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Create a "Test" email under "Alert Email Log" to the email address "rashnalingam@linktechnologies.com.au".

  1. Validate that the email is added to the "LT_SYS_MSG_Notifications" table.
  2. Once the email is sent validate that the email is added to the "LT_SYS_MSG_Notifications_Archive" table.
  3. Resend the email from "Alert Email Log". The email record should move from the archive table to the notifications table to resend

 

Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.30.1221
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-123

Next Step

  1. For review and closure

    24 Dec 202009:30AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 24-12-2020 01:30 PM
    Thanks Rashna 

    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12066 in the subject line of all emails regarding this issue.

    Document size: 7.4 KB
    For call complaints, please contact the Managing Director of the company using this form