Company: Link Technologies
Case No: L12756. Project: 14.00: LinkSOFT Version 14.00
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 12 Jul 2022 11:07AM
Priority: Low
Product: Payroll & HR
Group: Software Defect
Time Taken: 33.00 (Weight: 33.00)
Version: 14.00
Assigned To: Development
Circulation: Aarti Pooja Gayaneshwar, Development, Sanjay
Resolve By: Friday, 29 July 2022 07:50 PM [646 days since logged date]
Status: Closed
Subject: "An expression services limit has been reached." Error when making changes to the "Company Maintenance" form.
Summary:    

Hi Sanjay

After restoring the database for Danam:

  1. We logged in as Admin
  2. Navigated to Company
  3. Edited the Company
  4. Clicked Saved

Error: LT_SAA_Company_FrameworkBuild
Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.

Environment Details: 

  1. Version: 13.40.0621.GA
  2. URL: http://10.0.0.18/LinkWEB-Danam
  3. Login: standard "admin" login
Audit Notes:Edited by sanjay on 21/07/22 16:51. Edited by sanjay on 21/07/22 15:03. Edited by sanjay on 15/07/22 13:53. 
12 Jul 202202:44PM Comment 1 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 12-07-2022 08:44 PM Time Taken: 1.00

Meeting with Sanjay and Aarti


Error 1: Module: LT_ESS_TimesheetImport_Compute
Error: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.

Discussed: Sanjay has taken a trace of this error. He advised that he would rectify this and update


12 Jul 202202:47PM Comment 2 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-07-2022 08:46 PM
Assigning case to Sanjay

15 Jul 202201:52PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 29-07-2022 07:50 PM Time Taken: 4.00 Notes: ETC extended from: 13/07/2022 to 29/07/2022

Hi Aarti, this issue is to do with SQL Server 2019 compatibility. The workaround is to change compatibility to 2017 on your DB.

I will investigate this issue further.


15 Jul 202201:53PM Comment 4 by Sanjay (Link Technologies) Case L12756 added to project 14.00
19 Jul 202211:27AM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-07-2022 11:23 AM Time Taken: 22.00 Notes: Edited by sanjay on 19/07/22 11:58. 
PART A - Development work for this case has been completed.

SQL2019 has an expression limit that was exceeded by our audit notes string builder. The workaround was to change SQL Server database compatibility to SQL2017. We have corrected this issue in V14.

1. The change will be available in version:14.00

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

  1. Reduced String builder complexity from >10 to 10 parameters 

3. Affected Areas:

  1. System Internal Audit logging

4. The issue was caused by:

  1. SQL2019 complexity limits introduced failure

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


Dev References:

  1. ESS Paycode Update
  2. AccountsReceivableSalesOrderDetail UPDATE
  3. GeneralLedgerJournalDetail UPDATE
  4. AccountsPayableInvoiceDetail UPDATE
  5. DiscountCouponDetail Update


22 Jul 202202:24PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-07-2022 04:18 PM Time Taken: 6.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Verify Company Maintenance Form EDIT/Update when the database is in SQL2019 compatibility
Update successful
Pass

2Verify Timesheet import on sql2019 comatibility
Import complete without errors
Pass

3



Environment Details

  1. OS version: Win11
  2. Application version: 14.00
  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


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

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