Company: Link Technologies
Case No: L12561. Project: 13.03: LinkSOFT version 13.03
Logged By: Sanjay (Link Technologies) on 07 Sep 2021 08:43AM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 7.00 (Weight: 8.00)
Version: 13.03.0917
Assigned To: Sanjay (Link Technologies)
Circulation: Rashna, Sanjay
Resolve By: Friday, 10 September 2021 11:59 PM [958 days since logged date]
Status: Closed
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 202108: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):

  1. Change the Process Source Name to be the MachineName|SSQL Server Name | SQL Database Name

3. Affected Areas:

  1. Process Scheduler (Web and Windows)

4. The issue was caused by:

  1. Handle TEST databases on Production servers

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT


07 Sep 202110: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 202101: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 DetailsPass/FailComments
 1
  1. Validate that database names added to process status
 Pass 

Environment Details

  1. OS version:
  2. Application version: 13.03.907GA
  3. Setup on:
    1. Server:LinkQA4
    2. Database: UAT-LINKSOFT
    3. LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step:Closure


10 Sep 202102:12PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 10-09-2021 06:12 PM
Thanks Rashna

13 Oct 202110:53AM Comment 5 by Sanjay (Link Technologies) ETC was changed from 10/09/2021 to 10/09/2021
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12561 in the subject line of all emails regarding this issue.

Document size: 6.9 KB
For call complaints, please contact the Managing Director of the company using this form