| 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 2020 | 11: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): - Added a new table to archive email notifications
- When an email is sent, we immediately send it to the archive table
- 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: - Email Notifications
3. The issue was caused by: - High CPU usage on AZURE environment
4. Notes:
5. Next Step: UAT ---------------------- Development Reference: - New Table LT_SYS_Notifications_Archive
- Changed ID from INT to GUID
- Added procedures to archive and move entries as required
- No change to the interface
|
|
| 25 Nov 2020 | 08:07AM Comment 2 by Sanjay (Link Technologies) ETC was changed from 20/11/2020 to 20/11/2020 |
| 22 Dec 2020 | 02: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 | No | Test Description | Pass/Fail | | 1 | Create a "Test" email under "Alert Email Log" to the email address "rashnalingam@linktechnologies.com.au". - Validate that the email is added to the "LT_SYS_MSG_Notifications" table.
- Once the email is sent validate that the email is added to the "LT_SYS_MSG_Notifications_Archive" table.
- 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 - OS version: Windows Server 2012
- Application version: 12.30.1221
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-123
Next Step: - For review and closure
|
|
| 24 Dec 2020 | 09:30AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 24-12-2020 01:30 PM |
| Thanks Rashna |
|