| Subject: | Reports taking a long time to generate or "Times Out" |
| Summary: | When the Sales Summary Detail report and Customer Fleet Statement is generated using the below filters, the system logs out after 2100 seconds and gives the below message "An error has occurred in the system, Please contact your systems Administrator. Error message: Thread was being aborted." Sales Summary/Detail Report
Date From: 01/02/2023
Date To: 01/02/2023
Location: SIG01
Customer Fleet Statement
Date From: 01/02/2023
Date To: 28/02/2023
Customer Category: Mobil Shift Close Report (A4)
Date From: 06/02/2023
Date To: 12/02/2023
The above has been reproduced on Server: LINKQA4\CP1
DB: CLIENT-OTGL-LinkSOFT-HQ
Hosted On: http://10.0.0.18/LINKSOFT/
User: admin
PW: Standard
Version: 14.80.0518.Beta2 |
| Audit Notes: | Edited by sanjay on 26/05/23 09:06. Edited by sanjay on 23/05/23 17:08. Edited by sanjay on 23/05/23 13:34. Edited by sanjay on 23/05/23 13:33. Edited by sanjay on 22/05/23 11:16. Edited by vineet on 19/05/23 08:41. |
| 22 May 2023 | 11:16AM Comment 1 by Sanjay (Link Technologies) Case L12901 added to project 14.80 |
| 22 May 2023 | 03:43PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 24-05-2023 03:16 PM Time Taken: 6.00 |
| Sanjay's Investigation Results:
The issue with the "Sales Order Detail" report is that OTGL Index is altered and different from our standard indexes. If I replace the index with standard, the report comes up in less than 5 second
|
|
| 23 May 2023 | 05:08PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 25-05-2023 05:34 PM Time Taken: 8.00 Notes: ETC extended from: 18/05/2023 to 25/05/2023 |
| The following changes have been done: - Corrected index on Client database and replace with standard index
- Add new index for Shift Table
- Add a new index for new fields in Customer Maintenance (Category/Group)
- Improved Report Layout:
- Enlarging "Product Description" which was wrapping for every product
- Making the Fleet Summary FONT standard (8 pt) similar to the Main statement
- Aligning Totals
- Rename the Amount column from "Amount (Inc Tax) to "Amount". Moved the "Inc Tax" to the Total section to give more space to "Product Description"
|
|
| 25 May 2023 | 04:19PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-05-2023 05:48 PM Time Taken: 16.00 Notes: ETC extended from: 25/05/2023 to 31/05/2023 |
|
The following tests were performed:
Test Setup Instructions: - Using OTGL setup to verify reports
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Generate Report:
Sales Summary/Detail Report Date From: 01/02/2023. Date To: 01/02/2023. Location: SIG01 | A reasonable time is taken to display the report
| Pass
| Event Log:
Username: admin, Report: Sales Summary/Detail Report, Report option: PDF Viewer. Time Taken: < 1 min
| | 2 | Generate Report:
Customer Fleet Statement Date From: 01/02/2023 Date To: 01/02/2023 Customer Category: Mobil | A reasonable time is taken to display the report
| Pass
| Statement Reports are best run as Scheduled Reports as they do a lot of computations in the background. It is common to allocate 3 to 5 seconds per client in the statement selection.
In your example, there are 1267 customers in the statement selection which will take some time. Event Log for Date: 01/02/2023 to 01/02/2023:
Username: admin, Report: Customer Fleet Statement, Report option: PDF Viewer. Time Taken: 3 min | | 3 | Generate Report:
Shift Close Report (A4). Date From: 06/02/2023. Date To: 12/02/2023 | A reasonable time is taken to display the report
| Pass
|
|
Environment Details - OS version: Win11
- Application version: 14.80
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|