Company: Link Technologies
Case No: L12225. Project: 12.40: LinkSOFT Version 12.40 - 12.41
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on 13 Apr 2021 03:47PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 40.00 (Weight: 40.00)
Version: 12.40
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay, Vineet
Resolve By: Wednesday, 14 April 2021 11:59 PM [1109 days since logged date]
Status: Closed
Subject: The customer search filter in the Reports takes over 2 minutes to load.
Summary:    
PART A - Issue Details
1. Details

The customer search filter in the Reports takes over 2 minutes to load.

2. Error Message (Include screenshots of error)

The customer search filter in the Reports takes over 2 minutes to load.

Steps to Replicate:

  1. Uploaded 70k Customers
  2. On the following reports, when clicked on the customer search filter, the screen loads for more than 2 minutes to display data
  3. Report Names are:
    • Customer Statement
    • Customer Balance Listing
    • Customer Fleet Charges
    • Customer Fleet Statement
    • Customer Loyalty Transaction
    • Customer Listing Report
    • Customer Fleet Transaction Listing
3. Environment Details
Server Name: LINKTESTHQ 
Database name: LINKSOFT-OTGL-Training  
Application Hosted on: 
Login User ID/Password: Admin/ 12 
Client Operating System: 
Version: LinkSOFT - 12.32.0409.GA 

Audit Notes:Edited by aarti on 19/04/21 13:16. Edited by sanjay on 16/04/21 13:20. 
16 Apr 202101:23PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-04-2021 07:20 PM Time Taken: 2.00

Hi guys, yes this will be an issue given that you have over 70,000 customers in these lookups. 

To resolve the issue, we have made the following changes:

  1. Add a parameter to limit the number of rows to return where there is search capability. This includes all lookup's in Business Intelligence
  2. The Data search functionality can be used to reload data from the database 
  3. In Report Search, we auto filter based on already typed values

Since this affects all our reports, we will need a couple of days to change and test these scripts.

Most of the changes have been done, Rashna will be completing System tests on Monday next week and er expect to have a script ready by Tuesday next week


19 Apr 202108:06AM Comment 2 by Alvis (Link Technologies) Case L12225 added to project 12.4
19 Apr 202101:08PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 19-04-2021 07:04 PM Time Taken: 34.00
PART A - Development work for this case has been completed.

1. The change will be available in version:12.34.0419

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

  1. Added a global configuration to limit the number of rows in lookups where there is search capability
  2. Changed all lookups to limit based on 1 above. This includes all report lookups

3. Affected Areas:

  1. Reports
  2. User Maintenance List
  3. Recruitment -> Applicant Profile
  4. Recruitment -> Vacancy Manage
  5. Employee Profile -> Employee Maintenance
  6. Inventory -> Product Master
  7. Point of Sale -> Customer Profile
  8. Point of Sale -> Payment Allocation
  9. Helpdesk -> View All Calls
  10. Integration -> AP Invoice
  11. Integration -> AR Adjustment
  12. Integration -> AR Receipt
  13. Integration -> AR Sales Order
  14. Integration -> AR Transaction
  15. Integration -> GL Journal View
  16. Global Administration -> Audit Data
  17. Global Administration -> User Maintenance

4. The issue was caused by:

  1. Large Data volumes in Customer masterfile

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


19 Apr 202101:16PM Comment 4 by Aarti Pooja Gayaneshwar (Link Business Solutions) ETC was changed from 14/04/2021 to 14/04/2021
19 Apr 202103:21PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 19-04-2021 09:21 PM
Hi Rashna, proceed with UAT

19 Apr 202104:11PM Comment 6 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 19-04-2021 09:53 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

Reports - verified all report filters are loading correctly

pass
2

User Maintenance List

pass
3Recruitment -> Applicant Profile
pass
4Recruitment -> Vacancy Manage
pass
5Employee Profile -> Employee Maintenance
pass
6Inventory -> Product Master
pass
7Point of Sale -> Customer Profile
pass
8Point of Sale -> Payment Allocation
pass
9Helpdesk -> View All Calls
pass
10Integration -> AP Invoice
pass
11Integration -> AR Adjustment
pass
12Integration -> AR Receipt
pass
13Integration -> AR Sales Order
pass
14Integration -> AR Transaction
pass
15Integration -> GL Journal View
pass
16Global Administration -> Audit Data
pass
17Global Administration -> User Maintenance
pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.40.0419
  3. Setup: Demo
  4. Server : 10.0.0.10
  5. Database: DEV-LINKSOFT-124

Next Step: 

  1. For UAT

    26 Apr 202101:48PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 26-04-2021 07:41 PM Time Taken: 1.00 Notes: Edited by rashna on 26/04/21 13:50. 
    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

    Set the configuration for "Number of rows to return in forms with search capability" as 5. Validate that following screens and report filters only load 5 records.

    1. Reports
    2. User Maintenance List
    3. Recruitment -> Applicant Profile
    4. Recruitment -> Vacancy Manage
    5. Employee Profile -> Employee Maintenance
    6. Inventory -> Product Master
    7. Point of Sale -> Customer Profile
    8. Point of Sale -> Payment Allocation
    9. Helpdesk -> View All Calls
    10. Integration -> AP Invoice
    11. Integration -> AR Adjustment
    12. Integration -> AR Receipt
    13. Integration -> AR Sales Order
    14. Integration -> AR Transaction
    15. Integration -> GL Journal View
    16. Global Administration -> Audit Data
    17. Global Administration -> User Maintenance


     

    		Fails, the Inventory Master (Inventory -> Product Master) shows all records
     

    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 12.40.0426RC1
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFT-DEMO-124

    Next Step: 

    1. For Review

      26 Apr 202102:50PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 26-04-2021 08:12 PM Time Taken: 1.00
      PART A - Development work for this case has been completed.

      1. The change will be available in version:12.40.0426

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

      1. corrected the product master screen to use the common rows to return.

      3. Affected Areas:

      1. Inventory -> Product Master

      4. The issue was caused by:

      1. The common "Rows to Return" configuration was not applied to the product master.

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


      27 Apr 202111:07AM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 27-04-2021 05:07 PM
      Please proceed with UAT

      27 Apr 202102:02PM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 27-04-2021 08:00 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
      1Set the configuration for "Number of rows to return in forms with search capability" as 15. Validate that only 15 records are loaded on the "Product Master"
      		Pass

      Environment Details

      1. OS version: Windows Server 2012
      2. Application version: 12.40.0427RC1
      3. Setup: Demo
      4. Server : 10.0.0.14
      5. Database: DEMO-LINKSOFT

      Next Step: 

      1. For Closure

        27 Apr 202102:45PM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 27-04-2021 08:44 PM
        Thanks Rashna

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

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