| Subject: | Report Schedule unable to send emails |
| Summary: | 1. Problem Details Report Scheduler not working as expected. I have setup 4 examples in QA4 on client DB CLIENT-INKSOFT933
2. Error Message (Include screenshot of error)
Email Select Script is invalid for this report. See event log 3. Environment Details | Server Name: | QA4 | | Database name: | CLIENT-XXXXX-LINKSOFT933 | | Application Hosted on: | QA4 - http://localhost/pos | | Login User ID/Password: | manager/Infotech0410 | | Client Operating System: | | | Browser version (if Aplicable): |
|
4. Relevant History Information
Scheduler is able to send only two report (Role Menu Access Report & Discount Report - Email received successfully)
The issue can be reproduced by performing the following: 1. Edit TC Deleted Items Report and set Next run date to few days back
2. Email log should be created after job has executed
3. No Log is created
4. Event Log has error message. "Email Select Script is invalid for this report."
|
| Audit Notes: | |
| 18 Apr 2018 | 03:47PM Comment 1 by Alvis (Link Technologies) Case 9256 added to project 09.4 |
| 18 Apr 2018 | 04:27PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 18-04-2018 04:27 PM Time Taken: 2.00 |
| The issue was caused by the report username configuration. We have made the following changes to correct the issue: - Removed the need for username when the report is not configured for username.
- Changed email data script to use report schedule email address when username is not specified.
the update will be in version 9.4 regards
Alvis/Sanjay |
|
| 20 Apr 2018 | 08:11AM Comment 3 by Sanjeet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-04-2018 08:11 AM Time Taken: 0.50 |
| Hi Sanjay, Am I able to get patch forV9.3.3? Regards
Sanjeet
|
|
| 20 Apr 2018 | 02:39PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-04-2018 02:39 PM Time Taken: 1.00 |
| Hi Sanjeet, A patch for version 9.3.3 is available from this link. regards
Alvis |
|
| 01 May 2018 | 01:19PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 01-05-2018 01:19 PM Time Taken: 1.00 |
| System test completed. The following were done to verify: - Created Report schedule for "Deleted Items Report"
- An entry in "Report Email Log" was created with the correct report data.
- Received email and confirm it is working.
regards
Alvis
|
|
| 02 May 2018 | 12:36PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 03-05-2018 12:00 AM Time Taken: 2.00 |
| Hi Sanjay, This case has successfully tested. Documentation has been updated on the case. - Email Log has been updated Business Intelligence -- Email Log.
- Updated steps under Report Schedule
Test Enviornment - Version 9400 Beta 1
- Database - LINKSOFT on QA1
- Application on QA1
- OS - Windows 7
| Test No | Description | Status | | 1 | Schedule the "Delete item report" to run with a offset as 0. Email should be sent without errors. Transactions for 02/05/2018 should be loaded. | Pass | | 2 | Schedule the "Delete item report" to run with a offset as -1. Email should be sent without errors.Transactions for 01/05/2018 should be loaded.
| Pass | | 3 | Schedule the "Customer Statement" report to run by "PDF Attachment to each customer", this should email the statement to each customer. Tested multiple email address with rashna@linktechnologies.com.au;vineet@linktechnologies.com.au | Pass | | 4 | Schedule the "Customer Statement" report to run by "PDF Attachment will be emailed to the user running the report", this should email the statement to only linkadmin@linktechologies.com
| Pass | | 5 | Report Email Log should be updated with the email status | Pass | | 6 | Users should be able to expand and view the details of the email. | Pass |
Thanks
Rashna |
|
| 02 May 2018 | 03:15PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-05-2018 03:15 PM |
| Thanks Rashna |
|
| 09 Oct 2019 | 08:14AM Comment 8 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |