Company: Link Technologies
Case No: L12220. Project: 12.42: LinkSOFT Version 12.42
Logged By: Rashna (Edge Business Solutions) on 12 Apr 2021 02:55PM
Priority: Low
Product: Framework
Group: New Feature
Time Taken: 8.00 (Weight: 8.00)
Version: 12.42
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Thursday, 13 May 2021 11:59 PM [1319 days since logged date]
Status: Closed
Subject: Add ability to delete multiple records from "Email Log"
Summary:    

Enhancement Request by Client

  1. Failed emails are recorded in the "Email Log" and at times there is a great number of records. Refer to Figure 1.
  2. Deleting 1 record at a time is time-consuming. 
  3. Add option to "Select" and  "Delete" multiple/all records from the email logs.

___________________________________________________________

Internal tests with version 12.40.0428GA after comment 1 in the case. 

Steps

  1. Enable process "POS012" with an invalid backup file path. 
  2. Setup email SMTP with invalid credentials.
  3. Run the process, the process fails to create the backup.
    1. This created an entry in the "Email Log".
    2. The email fails in the "Email Log" due to invalid settings
      1. Emails can also fail if the email addresses are missing if there is a network issue, no data in the report, etc. 
  4. The system is designed to rerun the process after 10 minutes if it has failed.
    1. This creates a lot of failed records as 6 entries are created in 1 hour.
  5. Hence, every time the process fails, it also adds to the Email log with failed email entries. 

Figure 1: Multiple Email Logs
 

Audit Notes:Edited by sanjay on 26/05/21 16:08. Edited by rashna on 10/05/21 08:59. Edited by sanjay on 06/05/21 14:36. Edited by rashna on 29/04/21 14:04. 
12 Apr 202102:59PM Comment 1 by Alvis (Link Technologies) Case L12220 added to project 12.4
12 Apr 202103:06PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 14-04-2021 03:00 PM

In version 12.3, the system does not log multiple emails of the same content.

This change is not required.



12 Apr 202103:07PM Comment 3 by Alvis (Link Technologies) Case L12220 removed from project 12.4
29 Apr 202102:07PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 05-05-2021 02:04 PM Time Taken: 1.00

Hi Alvis, 

I have tested the case as per comment 1, however, it was noted that multiple emails are created for failed processes.

The case header has been updated with the details for review.

Thanks
Rashna


30 Apr 202103:11PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 05-05-2021 02:57 PM Time Taken: 1.00

Development meeting agreed to:

  1. Add a "Delete" button to select and delete multiple records.
  2. If the email is identical to an existing record that has "Failed" or "Not Sent", we do not log the email. 
  3. We need a status message to show the number of emails that have been consolidated.

06 May 202102:36PM Comment 6 by Sanjay (Link Technologies) Case L12220 added to project 12.42
06 May 202103:05PM Comment 7 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 13-05-2021 03:04 PM Time Taken: 4.00 Notes: ETC extended from: 24/03/2021 to 13/05/2021

Completed  the following:

  1. Added a "delete" button to delete multiple selected lines

Next step:

  1. Action item 2 of Comment 5

07 May 202103:46PM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-05-2021 03:17 PM Time Taken: 1.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 12.42

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

  1. Changed the check for an existing email to include the email footer in the message body.

3. Affected Areas:

  1. Processes -> Failed processes that create an email alert

4. The issue was caused by:

  1. When the emails are added to the notification, the system adds the email footer. This caused the check for the existing email to fail as the content of the message was changed.

5. Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


10 May 202108:59AM Comment 9 by Rashna (Edge Business Solutions) ETC was changed from 13/05/2021 to 13/05/2021
10 May 202110:17AM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-05-2021 10:02 AM 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 3 records for test email with invalid "To Address".

  1. The above should fail the email.
  2. Select and delete all 3 records. This should be completed without errors
Pass
2Fail process SYS003, validate that there no duplicate emails for the failed process Pass

Environment Details

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

Next Step: 

  1. For Closure

    10 May 202112:00PM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 12-05-2021 12:00 PM
    Thanks Rashna

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

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