Company: Link Technologies
Case No: L12846. Project: 14.50: LinkSOFT Version 14.50 - March 2023
Logged By: Sanjay (Link Technologies) on 24 Feb 2023 03:13PM
Priority: Medium
Product: Framework
Group: Software Defect
Time Taken: 46.00 (Weight: 19.00)
Assigned To: Development
Circulation: Development, Sanjay
Resolve By: Friday, 03 March 2023 12:00 AM [423 days since logged date]
Status: Closed
Subject: Email Logs not clearing - Process to send emails seems very slow

Email Logs not clearing - The process to send emails seems very slow.

Diagnostics done at the client's site showed the following:

  1. The client had 28000 active users. The Email scheduler needs to check if the Email address allocated to the user is valid and that the "Unsubscribe" list is activated. this was causing significant delays
  2. There were over 5000 emails in the queue. 
  3. Email Send Restriction was set to "50" per minute

We will investigate further and see how we can improve this.

Audit Notes:Edited by sanjay on 27/02/23 15:33. 
27 Feb 202303:32PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 28-02-2023 05:29 PM Time Taken: 38.00 Notes: Edited by sanjay on 27/02/23 15:32. 
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.50

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

  1. Moved Email Address Validation for Messages to the Background Process
  2. Added Message Logs to clearly label the reason for Email Address Failure. The two reasons are:
    1. The Email address is in the Exclusion List
    2. The email address belongs to a user that is "Not Approved" or "Does Not Have Access" to the company sending the email

3. Affected Areas:

  1. Email Messages
  2. Report Email Logs

4. The issue was caused by:

  1. Design Change to Improve Performance

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

01 Mar 202309:50AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 02-03-2023 11:27 AM Time Taken: 8.00
The following tests were performed:

Test Setup Instructions:
  1. Create user A001 - Approve user. Set email as
  2. Create user A002 - Not Approved. Email
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Send Email to A001
Email Received

2Send Email to A002
Email Marked as Deleted - Log should show the reason

3Add A001 Email to Unsubscribe List. Send Email to A001
Email Marked as Deleted - Log should show reason



Environment Details

  1. OS version: Win11
  2. Application version: 14.50
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure

If you have any queries regarding this support incident, please email and include the Case No: L12846 in the subject line of all emails regarding this issue.

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