Company: Link Technologies
Case No: L12901. Project: 14.80: LinkSOFT Version 14.80 - June 2023
Logged By: Vineet (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 18 May 2023 03:57PM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 30.00 (Weight: 30.00)
Assigned To: Development
Circulation: Development, Sanjay, Vineet
Resolve By: Wednesday, 31 May 2023 05:48 PM [340 days since logged date]
Status: Closed
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 202311:16AM Comment 1 by Sanjay (Link Technologies) Case L12901 added to project 14.80
22 May 202303: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 202305: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:

  1. Corrected index on Client database and replace with standard index
  2. Add new index for Shift Table
  3. Add a new index for new fields in Customer Maintenance (Category/Group)
  4. Improved Report Layout:
    1. Enlarging "Product Description" which was wrapping for every product
    2. Making the Fleet Summary FONT standard (8 pt) similar to the Main statement
    3. Aligning Totals
    4. 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 202304: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:
  1. Using OTGL setup to verify reports
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Generate 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

2Generate 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

3Generate 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

  1. OS version: Win11
  2. Application version: 14.80
  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: L12901 in the subject line of all emails regarding this issue.

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