| Subject: | Restore database needs to be blocked from accessing scheduled processes to prevent data issues |
| Summary: | When a copy of a database is restored on a test environment, we use the PROCESS SOURCE to identify the scheduler that runs the API processes. The process source is currently made up of the Machine Name When the TEST server is the same as the PRODUCTION server, this can cause issued with Integrations. To prevent this, we add the DATABASE and DATABASE SERVER Names to the Process Source. |
| Audit Notes: | Edited by sanjay on 13/10/21 10:53. Edited by sanjay on 07/09/21 08:43. Edited by sanjay on 07/09/21 08:43. |
| 07 Sep 2021 | 08:45AM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 07-09-2021 12:43 PM Time Taken: 6.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version:13.03.0907 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Change the Process Source Name to be the MachineName|SSQL Server Name | SQL Database Name
3. Affected Areas: - Process Scheduler (Web and Windows)
4. The issue was caused by: - Handle TEST databases on Production servers
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT
|
|
| 07 Sep 2021 | 10:35AM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-09-2021 12:45 PM |
| Process Source is reset when updating from versions prior to V13.03 |
|
| 09 Sep 2021 | 01:51PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 09-09-2021 05:40 PM Time Taken: 1.00 |
|
The following tests were performed:
Table 1 - Test Results
| # | Test Case Details | Pass/Fail | Comments | | 1 | - Validate that database names added to process status
| Pass | |
Environment Details - OS version:
- Application version: 13.03.907GA
- Setup on:
- Server:LinkQA4
- Database: UAT-LINKSOFT
- LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
- Login Details: Standard username and password for user "admin"
Next Step:Closure
|
|
| 10 Sep 2021 | 02:12PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 10-09-2021 06:12 PM |
| Thanks Rashna |
|
| 13 Oct 2021 | 10:53AM Comment 5 by Sanjay (Link Technologies) ETC was changed from 10/09/2021 to 10/09/2021 |