Company: Link Technologies
Case No: L12537. Project: 13.03: LinkSOFT version 13.03
Logged By: Sanjay (Link Technologies) on 26 Aug 2021 01:32PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 3.00 (Weight: 4.00)
Version: 13.00.0827
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Tuesday, 31 August 2021 12:00 AM [1183 days since logged date]
Status: Closed
Subject: Restore Database Script to Disable alerts and set the system to TEST Mode
Summary:    

When a database is restored for the purpose of testing, we have found that alerts are sent out before we get a chance to set the MODE to "Test"

To prevent this, here are the suggestions:

  1. By default, schedules should be OFF. Users restoring databases should set the MODE to TEST before enabling the scheduler
  2. Create a script named: LT_SYS_RestoreDatabase_TestMode that will set the mode to TEST and disable all processes except important processes. To run the script, use: EXEC LT_SYS_RestoreDatabase_TestMode 
Audit Notes:Edited by sanjay on 27/08/21 13:10. 
27 Aug 202110:03AM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 01-09-2021 09:10 AM Time Taken: 1.00
PART A - Development work for this case has been completed.

1. The change will be available in version:13.00.0827

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

  1. Created procedure to change the system to test mode. The following tasks will be performed:

    1. Admin user is reset

    2. Processes for API, Alerts, Database Backup & Health Check is disabled

    3. Process Maintenance Schedulers is disabled

    4. Email notifications are marked as deleted

    5. All integration is disabled

    6. VMS is disabled

3. Affected Areas:

  1. Utility script to apply after restoring database on test environment


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


27 Aug 202103:09PM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 01-09-2021 02:55 PM Time Taken: 1.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1
  1. Set the admin password to 12.
  2. Enable below processes
    1. Health Check
    2. FMISSQLAPI
    3. backup
  3. Enable "Email, Integration and Maintenance" schedulers
  4. Create emails in the email log with status as "Ready
  5. Enable VMS
  6. Set the mode to Live

Execute procedure "LT_SYS_RestoreDatabase_TestMode"

  1. Validate that the mode is changed to "Test
  2. Admin password should be updated to "admin
  3. Validate items enabled in 2,3,5 in above are disabled
  4. Validate that the qued emails are deleted
 Pass 

Environment Details

  1. OS version:
  2. Application version:13.00.086GA
  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


30 Aug 202109:26AM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 01-09-2021 09:26 AM Time Taken: 1.00
Thanks Rashna

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12537 in the subject line of all emails regarding this issue.

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