| Subject: | Emails are not sending. Status is "Ready" in the email log |
| Summary: | Client advised that some Emails have status: "Ready" and it's passed one day. He requested assistance on how to send these emails. |
| Audit Notes: | Edited by sanjay on 02/06/22 14:59. Edited by sanjay on 02/06/22 14:58. Edited by sanjay on 16/05/22 11:29. Edited by sanjay on 16/05/22 11:28. |
| 12 May 2022 | 12:41PM Comment 1 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 13-05-2022 12:34 PM Time Taken: 0.75 |
| Bula Vinaka Team Further to our team viewer meeting, we reviewed the below:
- Verified the SYS001 process – it was running successfully every minute
- Verified the process setup – it was running successfully
- Confirmed SMTP details in web file – correct
- Confirmed main setup in Configuration - correct
- We reset the process setup and restart IIS – verified the emails but the status was still as Ready
- We restarted the SQL services – verified the emails but the status was still as Ready
- We then restart the server machine – verified the emails but the status was still as Ready
We will reconnect to diagnose this further.
Please do not hesitate to contact our support team at +679 2220084 or email support@linktechnologis.com.fj for further queries or concerns. Thank You Aarti Gayaneshwar Helpdesk Coordinator Link Business Solutions +679 2220086 |
|
| 13 May 2022 | 12:32PM Comment 2 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 13-05-2022 12:27 PM Time Taken: 1.00 Notes: Edited by sanjay on 16/05/22 11:31. |
| Please find diagnostics: - Were emails being sent prior to this? have any email config changed?
- Yes, the emails were being sent prior to this
- The emails in the “Alert Email Log” are marked as “Ready” since the 9th of May. Refer below:
- However, emails in the “PDF Report Email Log” are being sent. A payslip batch was emailed today and has been sent out.
- No email configurations have been changed
- WEB or Windows Scheduler or mix scheduler in use?
- The file web schedule is enabled
- The Windows schedule is disabled
- Is the Email Process running?
- The below processes are running:
- SYS001 and SYS009
- Process Setup – Refer to the below image:
|
|
| 13 May 2022 | 11:34AM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 13-05-2022 02:20 PM Notes: Edited by sanjay on 13/05/22 14:22. |
| ***Skype Conversation Vineet, 11:34 AM Hi Sanjay
Motibhai has logged case T13972 Emails on "Ready" status since 1 day. I am not sure what the problem is. We have updated case with our diagnostics. Are you able to assist
11:46 AM Let me have a look at the case 11:54 AM There are some error messages in the event log, can you attend to them.
also, confirm the following and update the case: 1. Were emails being sent prior to this? have any email config changed? 2. WEB or Windows Scheduler or mix scheduler in use? 3. Is the Email Process running?
if it doesn't start sending we can connect later this afternoon at 2:30 AEST after you update the case.
Vineet, 12:07 PM Ok working on it now
Aarti, 12:59 PM Hi @Sanjay case updated with the answers, the issue is still there.
2:08 PM
@Sanjay Aarti, Today at 12:59 PM ok we can do a teams session at 2.30 pm. you can connect and we can have a look |
|
| 16 May 2022 | 09:21AM Comment 4 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 16-05-2022 09:15 AM Time Taken: 2.00 Notes: Edited by sanjay on 16/05/22 11:34. |
| Aarti and Sanjay connected on-site via Teams and found the following issue: - All settings are correct
- Procedure "LT_SYS_MSG_Notifications_Select2" is timing out as there are a large number of un-sent emails with lots of CC and TO address to go through. The process is taking over 40 seconds.
- Resolved the issue by reducing the batch size
Next step: - Aarti to setup a TEST environment for Sanjay to see what can be done to prevent this in V12
- Sanjay to confirm this issue is resolved in the current release
|
|
| 16 May 2022 | 11:28AM Comment 5 by Sanjay (Link Technologies) Case L12725 added to project 14.00 |
| 16 May 2022 | 11:28AM Comment 6 by Sanjay (Link Technologies) ETC was changed from 13/05/2022 to 31/05/2022 |
| 16 May 2022 | 02:29PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 16-05-2022 08:26 PM Time Taken: 12.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 14.00 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Added the Email selection process to use "DataCoommandTimeout" which increases the time allowance from 30 seconds to 1 hour
3. Affected Areas: - Email and Report Email processing
4. The issue was caused by: - Found that some "email body" can be very large, causing the selection process to take longer than 30 seconds. In MLC case, it was taking 46 seconds causing a timeout and failing the email task.
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 21 Jul 2022 | 02:19PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-07-2022 06:16 PM Time Taken: 2.00 |
|
The following tests were performed:
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Verify command timeout on source code
|
| Pass
|
| | 2 | Create 10,000 records on MSG Notifications table with the status "Ready"
| Email log should load even if the time taken is more than 20 seconds
| Pass
|
|
Environment Details - OS version: Win11
- Application version: 14.00
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|