Company: Link Technologies
Case No: L09559. Project: 10.10: LinkSOFT Version 10.1
Logged By: Sanjeet (Link Business Solutions) on 13 Sep 2018 03:24PM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 1.50 (Weight: 1.50)
Version: 10.155.0117
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Sanjay, Sanjeet
Resolve By: Friday, 14 September 2018 12:00 AM [2024 days since logged date]
Status: Closed
Subject: Menu 573 - Screen Opening Takes upto 3 Miniutes to open
Summary:    
1. Problem Details

There are two main issues on this screen

  • Menu 573 takes up to three minutes to load when the database has many purchase order records. 
  • PO Search screen takes the same amount of time to open

2. Error Message (Include screenshot of error)

Form Load Call

There is no error message, however, a trace run shows for some reason it is calling the below select statement when opening the form. Can you check if we had placed this is for some reason? 


SELECT lbs_po_hd.po_no,   

         lbs_po_hd.status,   

         lbs_po_hd.vendor_code,   

         lbs_po_hd.ship_to_loc,   

         lbs_po_hd.attention_name,   

         lbs_po_hd.attention_phone,   

         lbs_po_hd.currency_code,   

         lbs_po_hd.po_notes,   

         lbs_po_hd.tax_code,   

         lbs_po_hd.total_gross,   

         lbs_po_hd.total_tax,   

         lbs_po_hd.po_amount,   

         lbs_po_hd.who_entered,   

         lbs_po_hd.po_date,   

         lbs_po_hd.approve_by,   

         lbs_po_hd.approve_date,   

         lbs_po_hd.approve_comments,   

         lbs_po_hd.void_by,   

         lbs_po_hd.void_date,   

         lbs_po_hd.company_id,   

         lbs_po_hd.approver_code  

    FROM lbs_po_hd  (nolock)

   WHERE lbs_po_hd.company_id = '1001'     AND

lbs_po_hd.po_no <> ' '

ORDER by  lbs_po_hd.po_no desc


Search Screen Load Call


There is no error message, however, a trace run shows that we are doing an entire select on the lbs_po_hd table as below


SELECT  lbs_po_hd.po_no,   

         lbs_po_hd.status,   

         lbs_po_hd.vendor_code,   

         lbs_po_hd.ship_to_loc,   

         lbs_po_hd.attention_name,   

         lbs_po_hd.attention_phone,   

         lbs_po_hd.currency_code,   

         lbs_po_hd.po_notes,   

         lbs_po_hd.tax_code,   

         lbs_po_hd.total_gross,   

         lbs_po_hd.total_tax,   

         lbs_po_hd.po_amount,   

         lbs_po_hd.who_entered,   

         lbs_po_hd.po_date,   

         lbs_po_hd.approve_by,   

         lbs_po_hd.approve_date,   

         lbs_po_hd.approve_comments,   

         lbs_po_hd.void_by,   

         lbs_po_hd.void_date,   

         lbs_vendor_vw.vendor_name,   

         lbs_po_hd.approver_code,   

         lbs_po_hd.company_id  

 FROM (oj lbs_po_hd (nolock)LEFT OUTER JOIN lbs_vendor_vw (nolock) ON lbs_po_hd.vendor_code = lbs_vendor_vw.vendor_code AND lbs_po_hd.company_id = lbs_vendor_vw.company_id)   

WHERE (lbs_po_hd.po_no +

cast(CONVERT(VARCHAR(10),lbs_po_hd.po_date,103) as varchar(80))  +

  lbs_po_hd.vendor_code +

 lbs_vendor_vw.vendor_name +

  lbs_po_hd.status

  like '%'+''+'%')

ORDER by  lbs_po_hd.po_no desc


3. Changes Required
  • Remove the select ob lbs_po_hd table when opening the Purchase Order Screen
  • PO Search Screen - load top 500 or 1000. This screen has a search facility which users can use to search and filter

You can run the profiler on any LinkSOFT DB to see the above trace.



Audit Notes:Edited by sanjay on 05/03/19 09:40. 
24 Sep 201801:01PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjeet (Link Business Solutions) Followup Date: 24-09-2018 01:01 PM

Hi Sanjeet, the case needs details of environment where this issue can be seen. Can you place the database on QA4 where the load takes 3 minutes and update the case with details?


26 Sep 201801:46PM Comment 2 by Sanjeet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 28-09-2018 12:00 AM Time Taken: 0.50

Hi Sanjay,

The database has been restored on QA as "CLIENT-EXTRA-949". 

Regards
Sanjeet


26 Sep 201805:00PM Comment 3 by Alvis (Link Technologies) Case 9559 added to project 10.0
27 Sep 201811:28AM Comment 4 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 27-09-2018 11:28 AM Time Taken: 1.00

The PO Entry screen was redesigned in version 10. Refer to case 9048.

We have tested the response for this client in version 10 and the PO entry screen loads in less than 0.5 seconds.



09 Oct 201908:14AM Comment 5 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L09559 in the subject line of all emails regarding this issue.

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