Company: Link Technologies
Case No: L12272. Project: 12.43: LinkSOFT Version 12.43
Logged By: Rashna (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 28 May 2021 03:24PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 7.50 (Weight: 15.00)
Version: 12.43.0706
Assigned To: Rashna (Edge Business Solutions)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Saturday, 29 May 2021 11:59 PM [1273 days since logged date]
Status: Closed
Subject: "Customer Statement" takes long to generate in databases with large number of customers and transactional data
Summary:    

The issue has been reported by Tappoo Chemist.  

The below has been tested in version 12.42.056GA

Steps

  1. Generate the "Customer Statement" with the below filters:  
    1. Date From: 01/04/2021
    2. Date To: 30/04/2021
    3. Customer From: CU0000014048
    4. Customer To: CU0000014048
    5. Show Items: Y
    6. Statement Format: Running Total - Portrait
  2. Time Taken: 6 minutes
  3. Number of Pages: 10
Setup:
  1. Server - 10.0.0.14
  2. Database  - CLIENT-TAPPOOCHEMIST-LINKSOFT
  3. URL - http://10.0.0.13/linkweb
Audit Notes:Edited by sanjay on 01/07/21 07:59. Edited by sanjay on 01/07/21 07:59. Edited by sanjay on 25/06/21 10:02. Edited by sanjay on 18/06/21 17:32. Edited by alvis on 11/06/21 13:54. 
04 Jun 202109:20AM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 04-06-2021 03:19 PM
Hi Rashna, you haven't given us login details.

04 Jun 202110:53AM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 04-06-2021 04:51 PM Time Taken: 0.50

Hi Team,

Login Details as below:

  1. Username - admin
  2. Password - Linkfiji123

Thanks
Rashna


11 Jun 202101:54PM Comment 3 by Alvis (Link Technologies) Case L12272 added to project 12.43
11 Jun 202101:59PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 11-06-2021 07:54 PM Time Taken: 1.00
PART A - Development work for this case has been completed.

1. The change will be available in version:12.43

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

  1. Refactored the reports data extraction function to filter customers based on the customer master file table instead of the transactional table.

3. Affected Areas:

  1. Customer Statement - Running Total

4. The issue was caused by:

  1. When records were filtered using the transactional table, the query optimizer was slow in extracting the data, however, changing the filter to use the customer master file has improved the performance of the query.

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


14 Jun 202105:19PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 14-06-2021 08:51 PM Time Taken: 1.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Restore the client database.

  1. Generate the report with filters in the case header -Time Taken 6 minutes.
  2. Apply correction scripts.
  3. Validate the report is generated in a timely manner

Pass.

The report generates under 1 minute.


Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.42.0526GA
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: CLIENT-TAPPOOCHEMIST-LINKSOFT

Next Step: 

  1. Please publish the scripts on public FTP so we can apply the same on site,
  2. Case for closure.

Thanks


    15 Jun 202108:14AM Comment 6 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 15-06-2021 02:13 PM Time Taken: 1.00
    Thanks Rashna

    17 Jun 202101:39PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 17-06-2021 07:38 PM Time Taken: 0.50

    Hi Alvis, 

    Can you provide us the update for the case to use on-site,

    Thanks
    Rashan


    18 Jun 202102:01PM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 18-06-2021 07:46 PM Time Taken: 2.00
    Hi Rashna, the patch for 12.43 is available at this link

    18 Jun 202102:02PM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 18-06-2021 08:01 PM Time Taken: 1.00
    Case marked as Resolved. Please close after the patch is applied.

    18 Jun 202105:32PM Comment 10 by Sanjay (Link Technologies) ETC was changed from 29/05/2021 to 29/05/2021
    21 Jun 202106:07AM Comment 11 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 21-06-2021 12:05 PM Time Taken: 0.50

    Hi Team,

    Thanks for the patch, we will apply the updates on-site based on the client availability

    We will proceed to close this case. 

    Thanks
    Rashna


    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12272 in the subject line of all emails regarding this issue.

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