Company: Link Technologies
Case No: L12291. Project: 12.43: LinkSOFT Version 12.43
Logged By: Rashna (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 21 Jun 2021 04:20PM
Priority: High
Product: Framework
Group: Software Defect
Time Taken: 12.00 (Weight: 12.00)
Version: 12.43.0706
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Friday, 25 June 2021 11:59 PM [1036 days since logged date]
Status: Closed
Subject: Unable to upgrade demo database to version 12.43
Summary:    

Steps to Replicate

  1. Create a demo database using version 12.43.0621
  2. Upgrade database.
  3. The upgrade fails at script 9998.
    1. Error - Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them. EXEC LT_SAA_Framework_Build
Setup
  1. Server - 10.0.0.14
  2. Database - LINKSOFT-DEMO-124.
  3. Application onQA3
Audit Notes:Edited by sanjay on 25/06/21 10:16. Edited by sanjay on 25/06/21 09:30. Edited by sanjay on 24/06/21 10:27. Edited by sanjay on 24/06/21 10:27. Edited by alvis on 21/06/21 16:20. 
21 Jun 202103:59PM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 21-06-2021 09:54 PM

The error is due to the database compactivity level being higher than 140.

Can you set the database compactivity level to "SQL Server 2017 (140)"



21 Jun 202104:20PM Comment 2 by Alvis (Link Technologies) Case L12291 added to project 12.43
21 Jun 202104:22PM Comment 3 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 21-06-2021 10:20 PM Time Taken: 7.00 Notes: Edited by sanjay on 24/06/21 10:27. 
PART A - Development work for this case has been completed.

1. The change will be available in version:12.43.0621

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

  1. Changed the upgrade process to change the database compatibility level as follows:
    1. Change the level to 140. If it fails, attempt to change it to 130.
    2. When both attempts fail, we give a message to the user and exit the upgrade.

3. Affected Areas:

  1. Upgrading databases on SQL Server 2019

4. The issue was caused by:

  1. Improvement

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


24 Jun 202110:27AM Comment 4 by Sanjay (Link Technologies) ETC was changed from 22/06/2021 to 22/06/2021
24 Jun 202102:24PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 24-06-2021 08:05 PM Time Taken: 4.00

The following tests have been done in v12.43.0624

PART A - Used Gold Creek Cafe DB

  1. Set the DB compatibility to SQL2012
  2. Set file and log size to increment by 10%
  3. Completed upgrade to 12.43.0624 ave verified the following:
    1. Compatibility is changed to SQL2017
    2. File size increment was changed to 100MB
    3. Event Log shows the change made

PART A - Used GFI Backup

  1. Set the DB compatibility to SQL2019
  2. Set file and log size to increment by 2%
  3. Completed upgrade to 12.43.0624 ave verified the following:
    1. Compatibility is changed to SQL2017
    2. File size increment was changed to 100MB
    3. Event Log shows the change made

Next step: Rashna to complete QA


25 Jun 202109:31AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-06-2021 03:31 PM
Status changed to UAT

25 Jun 202110:16AM Comment 7 by Sanjay (Link Technologies) ETC was changed from 22/06/2021 to 25/06/2021
28 Jun 202111:12AM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 28-06-2021 05:08 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
1Create and upgrade a demo database with version 12.43. This should be completed without errors 
Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.43.0625GA
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-124

Next Step

  1. For Closure

    28 Jun 202101:54PM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-06-2021 07:54 PM Notes: Comment entered from the WEB using email sent to: sanjay@linktechnologies.com.au
    Thanks Rashna

    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12291 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