| Subject: | The process "Checks database consistency and sends an alert with results" does not work on SQL Server 2012 onwards |
| Summary: | The process "Checks database consistency and sends an alert with results" does not work on SQL Server 2012 onwards. An error message is logged when this process is enabled on SQL Server 2012 onwards. |
| Audit Notes: | |
| 09 Jul 2018 | 10:44AM Comment 1 by Alvis (Link Technologies) Case 9415 added to project 09.4 |
| 10 Jul 2018 | 02:12PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-07-2018 02:12 PM Time Taken: 2.00 |
| Development work for this case has been completed. The change will be available in version: 9.4.8.7 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Upgraded the check database process to work with SQL Server 2012 onwards as well.
2. The issue was caused by: - The script used to check database was not working SQL Server 2012 onward
3. Next Step - UAT
|
|
| 11 Jul 2018 | 11:40AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 11-07-2018 11:40 AM Time Taken: 1.00 |
| System test completed. Proceed with UAT. |
|
| 11 Jul 2018 | 03:52PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 12-07-2018 12:00 AM Time Taken: 1.00 |
| Hi Alvis, I have tested the case and below is the details Test Plan - Enable process SYS002.
- Use Default Email Template
- Set the To,CC and BCC address on the process.
- Execute the process. The email is successfully sent
- Remove the Set the To,CC and BCC address on the process. Execute the process. The email is not sent. See Figure 1 for error.
- The issue is that the system is not picking the content and email addresses from the template.
Test Environment - Version 948 Beta 9
- LINKSOFTQA4 on QA4 - Demo Setup
- URL - https://10.0.0.11/ESS
Figure 1: Error Thanks Rashna |
|
| 12 Jul 2018 | 11:01AM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-07-2018 11:01 AM |
| Hi Rashna, This process does not use a template. We will add this to version 9.5. regards
Alvis |
|
| 12 Jul 2018 | 11:01AM Comment 6 by Alvis (Link Technologies) Created new case 9428 |
| 09 Oct 2019 | 08:14AM Comment 7 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 |