Company: Link Technologies
Case No: L12894. Project: 14.80: LinkSOFT Version 14.80 - June 2023
Logged By: Sanjay (Link Technologies) on 16 May 2023 01:03PM
Priority: Low
Product: Point of Sale
Group: Enhancement
Time Taken: 16.00 (Weight: 12.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay, Vineet
Resolve By: Friday, 02 June 2023 04:14 PM [338 days since logged date]
Status: Closed
Subject: "Invoice View" and "Shift Management" forms times out in databases with very large volume of POS Transactions

Invoice View and Shift Management form times out in databases with a very large volume of POS Transactions

Example - On The Go database has over 44 Million POS transactions

Audit Notes:Edited by sanjay on 26/05/23 09:10. Edited by sanjay on 23/05/23 13:34. Edited by sanjay on 23/05/23 13:33. Edited by sanjay on 23/05/23 13:32. 
16 May 202301:08PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-05-2023 07:03 PM Time Taken: 5.00

Investigations showed the following:

  1. Shift Management Form. This form loads all shifts in the selected date Range, as well as any shift that is currently OPEN or on HOLD. 
    1. In the OTGL database, there were over 150 open shifts dating back to 2020. This is causing a timeout issue as each shift shown on the screen requires the "Payment Summary" to be displayed.
    2. To correct the issue:
      1. Close all OLD shifts. If they are on HOLD or OPEN, the system will need to show these and calculate all the numbers.
      2. We have reduced the default date range to 1 week
  2. Invoice View. This form loads all transactions on the date range, which defaults to TODAY.
    1. The date range filter is causing an issue on very large databases, so the following changes have been made:
      1. Remove the date range filter
      2. Show the top 1000 rows when there is no filter
      3. Show the TOP N rows when a filter is selected

25 May 202304:14PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-06-2023 03:15 PM Time Taken: 4.00

Hi Vineet, I have added a utility script that you can use to close "Open" and "Hold" shifts before a certain date. 

For example, to close all OPEN/Hold shifts before 01/05/2023 use this script:

EXEC dbo.LT_POS_UTILITY_CloseShiftBeforeDate

     @Username = 'linkadmin',

     @Password = 'Infotech0410',

     @Beforeopentime = '2023/05/01'

25 May 202304:19PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-06-2023 04:14 PM Time Taken: 7.00 Notes: ETC extended from: 16/05/2023 to 02/06/2023
The following tests were performed:

Test Setup Instructions:
  1. Use OTGL setup to verify Performance
  2. Run "Close Shift Utility" to close all shifts before 01/05/2023
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Open Shift Management Form
It opens in under 3 seconds
2Open Invoice Form
It opens in under 3 seconds


Important Note:

  1. Shift form does a lot of computations to determine payment values. We need to keep the shift open for less than 1 week. I cannot see a reason for keeping shifts open for longer than this time.
  2. If you need to keep shifts open for more than 2 days, please create a new case with the business case to explain why this is required so we can come up with a solution.

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 and include the Case No: L12894 in the subject line of all emails regarding this issue.

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