Company: Link Technologies
Case No: L12245. Project: 12.40: LinkSOFT Version 12.40 - 12.41
Logged By: Rashna (Edge Business Solutions) on 04 May 2021 04:18PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 6.00 (Weight: 6.00)
Version: 12.41
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay, Vineshwar Prasad
Resolve By: Tuesday, 04 May 2021 11:59 PM [1089 days since logged date]
Status: Closed
Subject: Changing "Product Code" times out when there are lots of Additional Fields configured
Summary:    
1. Problem Details

Shalvin advised that Changing "Product Code" times out in the system

2. Environment Details

Version - 12.30.0224.GA
Audit Notes:Edited by rashna on 04/05/21 16:18. Edited by rashna on 04/05/21 14:16. Edited by alvis on 04/05/21 14:04. Edited by rashna on 04/05/21 13:56. Edited by rashna on 04/05/21 13:56. 
28 Apr 202111:27AM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 30-04-2021 11:16 AM Time Taken: 1.00 Notes: Edited by vineshwar on 30/04/21 16:14. ETC extended from: 29/04/2021 to 30/04/2021
Bula Team,

We did a Team Viewer meeting and worked on the case. The following was done;
  1. Navigate to Product Master and searched for A047477
  2. Edited records and changed Product Code to DT01062071
This gives a message as; Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.



We will get our technical team to diagnose the issue and advise.

Regards
Vineshwar Prasad

30 Apr 202104:46PM Comment 2 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 04-05-2021 04:36 PM Time Taken: 2.00 Notes: ETC extended from: 30/04/2021 to 04/05/2021
Bula Team,

We had requested a copy of the LinkSOFT Database to diagnose the issue internally. The following has been tested;
  1. Setup an Environment internally with the Tappoo Chemist Database
  2. Installed LinkSOFT Application version 12.30.0224.GA (same as onsite)
  3. Perform Product Code Change
    • Navigate to Product Master
    • Search for Item A047477
    • Edited record and changed Product Code to DT01062071
    • Save record
    • This gives a message as; Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  4. Uninstalled LinkSOFT Application version 12.30.0224.GA
  5. Reinstalled LinkSOFT Application version 12.40.0429.GA
  6. Upgraded the Database
  7. Perform Product Code Change
    • Navigate to Product Master
    • Search for Item A047477
    • Edited record and changed Product Code to DT01062071
    • Save record
    • This gives a message as; Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
After the above tests, the issue remains. We will get our development team to diagnose the issue and advise.

Regards
Vineshwar Prasad

04 May 202101:56PM Comment 3 by Rashna (Edge Business Solutions) Case L12245 added to project 12.4
04 May 202102:07PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 04-05-2021 08:04 PM Time Taken: 1.00
PART A - Development work for this case has been completed.

1. The change will be available in version:12.41.0405

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

  1. Refactored renaming source primary key in "Notes & Attachments" framework by filtering part of the key.  

  2. We need to filter the records by source primary key. Since the full key is not known, we can filter part of the key using a like operator. This will limit the number of records to rename.

3. Affected Areas:

  1. Inventory -> Product Master -> Change Part Number.

4. The issue was caused by:

  1. Renaming the source primary key in all the notes and attachments framework was taking a long time to complete. 

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


04 May 202102:16PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 04-05-2021 08:16 PM
Hi Rashna, please test on today's build.

04 May 202102:16PM Comment 6 by Rashna (Edge Business Solutions) ETC was changed from 04/05/2021 to 04/05/2021
04 May 202104:41PM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 04-05-2021 10:38 PM Time Taken: 1.00
Table 1 - Test Results
Test NoTest CasePass/FailComments
1Change product code for an itemPassThe product changed within 5 seconds.







Environment Details
1. OS version:
2. Application version:12.41.0504.GA
3. Setup:Client
4. Server:10.0.0.14
5. Database:CLIENT-TAPPOOCHEM-LINKSOFT

Part B: Next Step:Review


05 May 202102:19PM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 05-05-2021 08:16 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

Change product code from "A047477" to "DT01062071" 

  1. Change should be saved without errors
  2. Save should not be delayed
Pass

Environment Details

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

Next Step: 

  1. For Closure

    05 May 202104:11PM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 05-05-2021 10:10 PM
    Thanks Rashna

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

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