Company: Link Technologies
Case No: L12105. Project: 12.30: LinkSOFT Version 12.30
Logged By: Sanjay (Link Technologies) on behalf of Alvis (Link Technologies) on 07 Dec 2020 03:21PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 3.00 (Weight: 8.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Saturday, 12 December 2020 11:59 PM [1445 days since logged date]
Status: Closed
Subject: Upgrade process error handling should log issues for the administrator to review POST upgrade.
Summary:    

When upgrading process fails at the 99996 script, we are not able to re-run upgrade.

Things to correct:

  1. Check if the database is a LinKSOFT DB. currently, we are checking for SY_COMPANY.
  2. Upgrade log insert to be done directly instead of a procedure
Audit Notes:Edited by alvis on 09/02/21 16:51. 
15 Dec 202008:10AM Comment 1 by Sanjay (Link Technologies) Case L12105 added to project 12.3
18 Dec 202011:43AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-12-2020 11:31 AM Time Taken: 2.00

PART A - Development work for this case has been completed.

1. The change will be available in version:12.30.1218

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

  1. Upgrade utility now looks at the existence of table SY_CONTROL to determine if it is a LinkSOFT database
  2. Changed the base upgrade script to recreate log insert if it does not exist.

3. Affected Areas:

  1. LinkSOFT upgrade utility

4. The issue was caused by:

  1. improvement

5. Notes: 
6. Next Step: UAT

----------------------

PART B - Development Reference:

1. Changes implemented was according to the approved design (Y/N):N/A

2. Variations to the approved design:N/A


24 Dec 202009:38AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 30-12-2020 09:35 AM
Please proceed with UAT 

29 Dec 202003:34PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 31-12-2020 03:09 PM 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
NoTest DescriptionPass/Fail
1
  1. Created a database as "LinkSOFT-DEMO-1222
  2. Deleted the "SY_Control" table from the database.
  3. Upgraded database. This should prompt that database is not valid
Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.30.1224BETA
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-123

Next Step: 

  1. For Closure

    04 Jan 202103:25PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-01-2021 03:24 PM
    Thanks Rashna 

    09 Feb 202104:51PM Comment 6 by Alvis (Link Technologies) ETC was changed from 12/12/2020 to 12/12/2020
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12105 in the subject line of all emails regarding this issue.

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