| Subject: | Standalone replication server connection does not complete |
| Summary: | Standalone replication server connection does not complete. Investigations show that when a standalone connection is created, the process "Clears All Replication" then creates the standalone connection. The "Clear all replication" process also disables the SQL Agent Job "POS008" which is required to complete the process. This results in the standalone connection to display as "Deleted".
|
| Audit Notes: | Edited by rashna on 04/03/19 08:07. Edited by alvis on 18/02/19 16:15. |
| 14 Feb 2019 | 04:54PM Comment 1 by Alvis (Link Technologies) Case 10169 added to project 09.X |
| 14 Feb 2019 | 04:57PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 14-02-2019 04:57 PM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version: 10.2 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Changed "Clear All Replication" process to:
- Mark server connections as deleted for any "configured" status.
- Removed process "POS008" from being disabled
2. The issue was caused by: - The "Clear all replication" process also disables the SQL Agent Job "POS008" which is required to complete the process. This results in the standalone connection to display as "Deleted".
3. Next Step: - UAT
4. Notes: |
|
| 15 Feb 2019 | 11:31AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 18-02-2019 12:00 AM Time Taken: 1.00 |
| QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues | No | Test Description | Pass/Fail | | 1 | Setup databases as below on 10.0.0.14. - LINKSOFT-104-HQ
- LINKSOFT-104-B1 (Created from Replication Servers)
- LINKSOFT-104-STANDALONE (Backup of LINKSOFT-104-B1 .)
- Created replication between "LINKSOFT-104-HQ" and "LINKSOFT-104-B1 "
- Created replication between "LINKSOFT-104-B1" and "LINKSOFT-104-STANDALONE "
- Deleted the existing connection in the "LINKSOFT-104-STANDALONE" database.
- Add the server for "Standalone" database
- Created a"Standalone" connection with source as "LINKSOFT-104-STANDALONE" and destination "LINKSOFT-104-B1"
- The connection was created without been deleted. Process POS008 did not disable.
- The "Parent" connection was successfully created in "LINKSOFT-104-B1".
| Pass |
Environment Details - OS version: Windows Server 2012
- Application version: 10.4
- Setup: Demo
- Server : 10.0.0.10
- Database:LINKSOFT-104-HQ
Steps to reproduce failed scenarios: N/A Next Step: for closure
|
|
| 18 Feb 2019 | 04:15PM Comment 4 by Alvis (Link Technologies) Case 10169 added to project 10.1 |
| 22 Feb 2019 | 08:57AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 22-02-2019 08:57 AM |
| Thanks Rashna |
|
| 09 Oct 2019 | 08:14AM Comment 6 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 |