Company: Link Technologies
Case No: L09849. Project: 10.10: LinkSOFT Version 10.1
Logged By: Rashna (Edge Business Solutions) on 16 Jan 2019 02:37PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 7.00 (Weight: 7.00)
Version: 10.155.0117
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay, Vineshwar Prasad
Resolve By: Thursday, 17 January 2019 12:00 AM [1899 days since logged date]
Status: Closed
Subject: Product details on 519 is not replicated in version 10.1.3.8
Summary:    

Case:

We have set up a replication environment for version 10.1.3.8. While testing we identified that the product details (LBS_INV_LIST) are not replicating.

Setup Details

  1. HQ Database - LINKSOFTHQ
  2. Branch Database - LINKSOFTB1
  3. Server - 10.0.0.14
Steps to Replicate
  1. Setup Replication in DEMO database.
  2. Do not enable any replication rules. By default rules "R1100" and "R0100" are enabled both at HQ and Branch.
  3. Create a new product in HQ as "HQ001". Update the location to "Retail".
  4. Validate the product in Branch Server.

Findings

  1. Both "LBS_Inventory" and "LBS_INV_LIST" details go to "LT_REPL_DATA_OUT_QUEUE" table.
  2. Only "LBS_Inventory"  details go to the  "LT_REPL_DATA_OUT" table.
  3. There is no update for "LBS_INV_LIST" in replication history.
     
Audit Notes:Edited by sanjay on 05/03/19 10:33. 
17 Jan 201910:37AM Comment 1 by Sanjay (Link Technologies) Case 9849 added to project 10.1
18 Jan 201909:19AM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 18-01-2019 09:19 AM Time Taken: 6.00
Development work for this case has been completed.
The change will be available in version: 10.1.3.9

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

  1. Changed the replication key column order to use Table column sequence id instead of primary key sequence id.

2. The issue was caused by:

  1. Mis-match in primary key sequence between table column caused data not to replicate.

    3. Next Step

    1. UAT

    23 Jan 201903:39PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 24-01-2019 12:00 AM 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
    1Create replication between LINKSOFTHQ and LINKSOFTB1Pass
    2Do not enable replication rule. Add location "DEF" to product PNT01 at Head office. This should be replicated to the branch.Pass
    3

    Enable rule R1140. Set the location as "RETAIL" for the branch server. Set the standard cost for item PNT01 as below

    • Location: DEF Cost : 15
    • Location: MAIN  Cost : 20
    • Location: RETAIL  Cost : 10

    The standard cost for location "Retail" should be updated as 10 at the branch server.


    Pass

    Environment Details

    1. OS version: Windows 7
    2. Application version: 10.1.3.9
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFTHQ and LINKSOFTB1

    Steps to reproduce failed scenarios:


    Next Step: for closure


      25 Jan 201911:57AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-01-2019 11:57 AM
      Thanks Rashna 

      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: L09849 in the subject line of all emails regarding this issue.

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