Company: Link Technologies
Case No: L12863. Project: 14.60: LinkSOFT Version 14.60 - April 2023
Logged By: Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 17 Mar 2023 05:49PM
Priority: Medium
Product: Framework
Group: Software Defect
Time Taken: 10.00 (Weight: 19.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay, Vineshwar Prasad
Resolve By: Tuesday, 21 March 2023 03:43 PM [397 days since logged date]
Status: Closed
Subject: Database Upgrade Fails. Message: Invalid object name 'LT_SYS_ProcessRulesModuleConfiguration_vw'
Summary:    
Section A - Describe what the issue is about. Include Error Message (and screenshots (600px x 800px 100kb max size)

Database Upgrade Fails. Message: Invalid object name 'LT_SYS_ProcessRulesModuleConfiguration_vw'

Section B. 
Relevant History Information:
Any information that is relevant to this issue, or may have caused this issue.

Error on Script 14000 - 14999

-----------------------------------------------------------------
Invalid object name 'LT_SYS_ProcessRulesModuleConfiguration_vw'.

--Renamed ConfigurationRule 'PasswordValidationErrorText' to PasswordValidationText
DELETE FROM LT_SYS_ConfigurationRule where RuleCode IN ('PasswordValidationErrorText')
--Reset TNA Purge to improve performance
UPDATE LT_SYS_ProcessRulesModuleConfiguration_vw SET RuleValue = 50 WHERE RuleCode = 'TimesheetImport.ArchiveRecordsDays' AND RuleValue > 50
UPDATE LT_SYS_ProcessRulesModuleConfiguration_vw SET RuleValue = 100 WHERE RuleCode = 'TimesheetImport.DeleteRecordsDays' AND RuleValue > 100
--------Standard Code below this line-------------------

Section C.
The issue can be reproduced by performing the following steps: 
  1. Install version 14.50.0301.GA
  2. Created a Demo Database using Link Database Tools. Database Name: LINKSOFT-DEMO
  3. Upgrade the Database
Environment Details
  1. Setup on LinkQA2
Audit Notes:Edited by sanjay on 25/03/23 13:50. Edited by sanjay on 22/03/23 14:08. Edited by sanjay on 20/03/23 16:19. Edited by sanjay on 20/03/23 13:41. Edited by sanjay on 20/03/23 13:41. 
20 Mar 202301:41PM Comment 1 by Sanjay (Link Technologies) Case L12863 added to project 14.50
20 Mar 202301:43PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 21-03-2023 03:41 PM Time Taken: 6.00 Notes: Edited by sanjay on 20/03/23 13:47. ETC extended from: 21/03/2023 to 21/03/2023
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.50.0320. The patch can be downloaded from this link.

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

  1. Corrected upgrade script

3. Affected Areas:

  1. Creating new database using 14.50

4. The issue was caused by:

  1. The upgrade script was using a database view before the view it was created

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


20 Mar 202301:45PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 21-03-2023 03:43 PM Time Taken: 4.00 Notes: ETC extended from: 21/03/2023 to 21/03/2023
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Perform an upgrade on a version > 14.0
The upgrade should complete successfully as this view already exists
Pass

2Perform an upgrade on a version prior to V14.0
Upgrade fails Pass

3
Apply Patch and run the upgrade
Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.50
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


20 Mar 202304:19PM Comment 4 by Sanjay (Link Technologies) Case L12863 added to project 14.60
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12863 in the subject line of all emails regarding this issue.

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