| 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: - We logged in as Admin
- Navigated to Company
- Edited the Company
- 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: - Version: 13.40.0621.GA
- URL: http://10.0.0.18/LinkWEB-Danam
- 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 2022 | 02: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 2022 | 02: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 2022 | 01: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 2022 | 01:53PM Comment 4 by Sanjay (Link Technologies) Case L12756 added to project 14.00 |
| 19 Jul 2022 | 11: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): - Reduced String builder complexity from >10 to 10 parameters
3. Affected Areas: - System Internal Audit logging
4. The issue was caused by: - SQL2019 complexity limits introduced failure
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
Dev References: - ESS Paycode Update
- AccountsReceivableSalesOrderDetail UPDATE
- GeneralLedgerJournalDetail UPDATE
- AccountsPayableInvoiceDetail UPDATE
- DiscountCouponDetail Update
|
|
| 22 Jul 2022 | 02: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
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Verify Company Maintenance Form EDIT/Update when the database is in SQL2019 compatibility
| Update successful
| Pass
|
| | 2 | Verify Timesheet import on sql2019 comatibility
| Import complete without errors
| Pass
|
| | 3 |
|
|
|
|
Environment Details - OS version: Win11
- Application version: 14.00
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|