Company: Link Technologies
Case No: L12895. Project: 14.80: LinkSOFT Version 14.80 - June 2023
Logged By: Vineet (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 17 May 2023 08:21AM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 11.00 (Weight: 19.00)
Assigned To: Development
Circulation: Development, Sanjay, Vineet
Resolve By: Wednesday, 31 May 2023 04:15 PM [554 days since logged date]
Status: Closed
Subject: Data Views: "Order Detail Sales" and "Invoice Detail Listing" Times out for 1 days data when Load Data is clicked
Summary:    

Section A. Describe what the issue is about. Include Error Message (and screenshots (600px x 800px 100kb max size)

The below Data Views give a Timeout error when selected for 1 day:

  1. POS - Order Detail Sales for dates 01/05/2023 - 01/05/2023
  2. POS - Invoice Detail Listing for dates 01/05/2023 - 01/05/2023

Error Message

"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding"

Section B. Relevant History Information: Any information relevant to this issue.

Upon diagnosing this, we noted that this view has to extract data from 44 million records. The application timeout is set to 30 seconds. This customer has data from 2013.


Section C. The issue can be reproduced by performing the following steps: 
  1. Login to OTGL setup using this URL http://10.0.0.18/Linksoft
  2. Login with user admin standard password
  3. Navigate to Business Intelligence>>Data View
  4. Load the Invoice Detail Listing and set the date from 01/05/2023 and Date to 01/05/2023
  5.  Click on Load Data. Timeout message will come after 30 seconds
    Audit Notes:Edited by sanjay on 26/05/23 09:08. Edited by sanjay on 23/05/23 13:32. 
    17 May 202309:11AM Comment 1 by Sanjay (Link Technologies) Case L12895 added to project 14.80
    17 May 202311:52AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 19-05-2023 01:11 PM Time Taken: 9.00 Notes: ETC extended from: 17/05/2023 to 19/05/2023
    PART A - Development work for this case has been completed.

    1. The change will be available in version: 14.80

    2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

    1. Added a larger data timeout to Data View Queries
    2. Corrected BI View named "POS - Order Detail Sales". This view was loading all transactions with the intention to filter using the "On Grid" filter. This has been changed to load only the date range as is the case on all other views.
    3. Changed the Date Filters so that it doesn't use a Convert Function to check all dates on the Order table. This improves search engine efficiency.

    3. Affected Areas:

    1. BIVW for "Sales Order" and "Invoices"

    4. The issue was caused by:

    1. Programming and Design issue

    5. Other Relevant Notes: 
    6. Next Step     (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


    25 May 202301:20PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-05-2023 04:15 PM Time Taken: 2.00 Notes: ETC extended from: 19/05/2023 to 31/05/2023
    The following tests were performed:

    Test Setup Instructions:
    1. Use OTGL DATABASE
    Table 1 - Test Results
    NoTest CaseExpected ResultPass/FailComments
    1Generate Dataview: POS - Order Detail Sales for dates 01/05/2023 - 01/05/2023
    		The result appears in under 1 sec
    		Pass

    2Generate Dataview POS - Invoice Detail Listing for dates 01/05/2023 - 01/05/2023
    		The result appears in under 1 sec
    		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: L12895 in the subject line of all emails regarding this issue.

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