| Subject: | SYS004 Fails to Run when "Archive Point Of Sales Transactions" is enabled with a large "Cut-Off Days" configuration |
| Summary: | When the SYS004 process is run with Archive Point Of Sales Transactions enabled, the job fails to run. The Event log displays this message. Adding a value to a 'datetime' column caused an overflow. This job will process again in 10 minutes. - In the Demo Database perform the sales in the Year 2020.
- Set the Sales Order Days Archive Cut off days to 730
- Enable the SYS004 process to run.
The process will fail with an error in the event log. "Adding a value to a 'datetime' column caused an overflow.. This job will process again in 10 minutes." LinkQA8-LBS2 Link Technologies - DEMO LinkSOFT-Demov15 http://10.0.0.18/LinkSOFT-Demov15/
|
| Audit Notes: | Edited by sanjay on 23/02/24 11:35. Edited by sanjay on 21/02/24 11:59. Edited by sanjay on 20/02/24 15:26. Edited by sanjay on 09/02/24 10:32. Edited by sanjay on 08/02/24 11:41. |
| 29 Nov 2023 | 10:52AM Comment 1 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 29-11-2023 02:50 PM Time Taken: 1.00 Notes: Edited by vineet on 29/11/23 10:53. ETC extended from: 28/11/2023 to 29/11/2023 |
| Bula Further investigation into this we noted that under SYS004, if you change the value for rule Remove entries from Archive tables that hold Processed Sales Orders and Payments. The number in this field defines the number of days to keep. to 99999, that is when this error is thrown. Thanks
Vineet Ram |
|
| 29 Nov 2023 | 11:44AM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-11-2023 05:38 PM Time Taken: 1.00 |
| Check date limit and raise error stating the date cannot be less than XX. Check date limit on SQL2017 |
|
| 08 Feb 2024 | 11:41AM Comment 3 by Sanjay (Link Technologies) Case L12978 added to project 15.20 |
| 08 Feb 2024 | 11:41AM Comment 4 by Sanjay (Link Technologies) ETC was changed from 29/11/2023 to 29/02/2024 |
| 09 Feb 2024 | 11:29AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 09-02-2024 04:32 PM Time Taken: 7.00 Notes: Edited by sanjay on 20/02/24 15:27. Edited by sanjay on 20/02/24 15:26. |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 15.20 2. The following changes were made (Include Database object names, Program classes, and any other relevant information): - When calculating the "Cut-Off Date", we subtract the configuration "Days to Keep" from "today's" date. If the configuration has a value that is exceptionally large, and the calculated "Cut-Off Date" is before "1900/01/01" there is a date Overflow error. We have corrected this by checking this configuration and resetting the "Days to keep" to a value that does not exceed "1900/01/01"
3. Affected Areas: - Process that purge POS Transactions
4. The issue was caused by: - Enhancement
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 21 Feb 2024 | 09:13AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 21-02-2024 03:06 PM Time Taken: 5.00 |
|
The following tests were performed:
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Change configuration "SYS004.SalesOrderArchive.CutOffDays" to 999999
| System should limit he Cut Off Date to "1900/01/01"
| Pass
|
| | 2 | Change configuration "SYS004.SalesOrderArchive.CutOffDays" to 55
| Cut Off date calculation should be 55 days before today
| Pass
|
| | 3 |
|
|
|
| | 4 |
|
|
|
| | 5 |
|
|
|
|
Environment Details - OS version: Win11
- Application version: 15.20
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|