Company: Link Technologies
Case No: L08394. Project: 08.20: LinkSOFT Version 8.2
Logged By: Vineet (Link Business Solutions) on 06 Mar 2017 09:33AM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 6.00 (Weight: 6.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Vineet
Resolve By: Tuesday, 07 March 2017 12:00 AM [2608 days since logged date]
Status: Closed
Subject: Items deleted from a KIT product is not replicated
Summary:    
1. Description: 
     When a product is deleted from KIT product, this is not replicated to the other branches. This has been replicated on QA4.
  • LINKSOFTHQ parent database.
  • LINKSOFTBR1 Branch 1
  • LINKSOFTBR2 Branch 2
Removed items REST035 from KIT product REST036 at LINKSOFTHQ. This was not replicated to LINKSOFTBR1 AND LINKSOFTBR2


2. Environment Details
Machine Name
 QA4
User name:
 sa
Operating System:
 windows server 2012 R2
Browser name/Version:
 
Other 
3. Steps to recreate
a. For KIT Product REST036, Delete item Rest035 from its list
b.Review this at other Branches to see if this change has been replicated.

4. Current Behaviour:
     Removing items from the KIT is not replicated
5. Expected Behaviour:
     Removing items from KIT should be replicated
-----------------------------------------------------------------------
--- TO BE COMPLETED AFTER THE CASE HAS BEEN RESOLVED ---
Has the problem been solved?:

Steps taken to resolve the issue:

Has the final solution review been done with the customer? (Yes/No)  Notes from discussion with customer:

Audit Notes:
06 Mar 201703:39PM Comment 1 by Alvis (Link Technologies) Case 8394 added to project 8.10.001
07 Mar 201703:21PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 07-03-2017 03:21 PM Time Taken: 4.00
Development work for this case has been completed.
The change will be available in version: 8.10.001 (eta 31/03/2017)
Documentation update required(Yes/No. Add change details below): 
QA required(Yes/No.Include areas that require testing): Yes

The following changes were made(Include Database object names, Program classes and any other relevant information): 
 The issue with this replication process is that the primary key on the kit item table is changed. This prevents us from knowing what changes to propagate to other servers. 

The way to prevent this would be to disallow the user from changing the kit item. To make a change you can delete and add the changed item.

We have also changed back-office screen to disallow users from changing the kit items.


Documentation details:
  

16 Mar 201708:06AM Comment 3 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-03-2017 08:06 AM

The following changes were done to resolve this issue:

  1. Changed procedure LT_REPL_DATA_OUT_INSERT to handle records that are deleted from the database. These records send the key fields in replication for other branches to delete the record.

06 Apr 201709:20AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-04-2017 09:20 AM
Please proceed with UAT.

10 Apr 201707:44AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Development Followup Date: 10-04-2017 07:44 AM Time Taken: 2.00
1. Was this test completed using Demo / New / Other database? Demo
2. Did the test pass or fail? Pass
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? N/A
4. Data verified, saved, edit, delete/void? N/A
5. Documentation update required? 
Additional Details (Risks, issues, special conditions required for this test to pass etc): 

Test Plan

Task No Task Decription  Status 
1  Create a kit item Pas
2   Add Item to the kit item, this should be replicated to all branches   
3    Delete Item to the kit item, this should be replicated to all branches  Pass
4    Verify Inventory List and Inventory Kit Listing Report  Pass


10 Apr 201711:55AM Comment 6 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 10-04-2017 11:55 AM
documentation not required, closing case.

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

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