Company: Link Technologies
Case No: L12823
Logged By: Vineshwar Prasad (Edge Business Solutions) on 21 Nov 2022 03:47PM
Priority: High
Product: Framework
Group: Software Defect
Time Taken: 10.00 (Weight: 8.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay, Sitla Sharma, Vineshwar Prasad
Resolve By: Friday, 16 December 2022 01:34 PM [514 days since logged date]
Status: Closed
Subject: Email queue Logs is sending emails at a very slow pace
1. Problem Details

Alert Email Logs stuck with Status as "Ready" since 21/11/2022 6.00 AM

2. Error Message (screenshot of the error)

3. Environment Details
  1. Version - 14.30.1116
Audit Notes:Edited by sanjay on 12/12/22 16:28. Edited by sanjay on 23/11/22 10:12. Edited by sanjay on 23/11/22 09:50. Edited by sanjay on 23/11/22 09:47. Edited by sanjay on 23/11/22 09:35. Edited by vineshwar on 21/11/22 15:47. 
23 Nov 202209:45AM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 30-11-2022 03:35 PM Time Taken: 4.00

Hi Vineshwar, as discussed, please note the following:

  1. Emails are throttled using the following rules:
    1. Menu "Global Administration ~> Process Setup" determines how often the system will attempt to send out a batch of Emails. If the interval is set to 600 seconds, this means that every 10 minutes, the system will try and send out emails.
    2. Mail Settings in Company Administration have throttle limits. These determine how many emails get set out for each email batch.
  2. If you have multiple companies in a database, note that item 1.1 above is for each Database, while configuration item 1.2 is by Company. Set the numbers keeping these two rules in mind.
  3. If you are in a multi-company environment and require a lot of emails to go through, you should configure 1.1 to run more frequently. Calculate the numbers based on the volume and frequency while keeping in mind Spam Filtering requirements from your mail provider.
  4. We noted that when the application pool stops, the email queue can accumulate a large number of emails and therefore the queue is large in the mornings.

Figure 1 - Mail Settings:

Next Step: Sanjay to work out if there is merit in running the Process in 1.1 above for each company, instead of for each database.

23 Nov 202209:50AM Comment 2 by Sanjay (Link Technologies) ETC was changed from 22/11/2022 to 30/11/2022
12 Dec 202204:14PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 12-12-2022 10:10 PM Time Taken: 3.00

Further explanation regarding Comment 1 item 2:

  1. The Throttle Limit is based on the company. 
  2. When there are multiple emails in a queue, emails are sent on a first come first serve basis. Each item in the queue is picked up the email throttle used to determine how many emails to send.

In Multiple Company Environments, you can do the following to speed up emails:

  1. Set the Email scheduler to run every minute
  2. Set  each company throttle limit to 20+

12 Dec 202204:28PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 12-12-2022 10:14 PM Time Taken: 1.00
Hi Vineshwar, are the emails in the queue going through fast enough?

I checked Jack's database and all emails are sent within 80 minutes, even the queued ones at 6 am.

Do you need any further action on this case?

12 Dec 202204:28PM Comment 5 by Sanjay (Link Technologies) ETC was changed from 30/11/2022 to 16/12/2022
01 Feb 202311:36AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 01-02-2023 05:09 PM Time Taken: 2.00

Hi Guys, we have confirmed that the following settings are best for most clients:

  1. Set the configuration "_SendPerMinute" to 50
  2. Set the Email Scheduler to 60 seconds. 

This will ensure that for all companies in the database, we can handle sending 50 emails per minute or 500 per 10-minute interval.

The documentation has been updated. Closing case,

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

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