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 - HQ Database - LINKSOFTHQ
- Branch Database - LINKSOFTB1
- Server - 10.0.0.14
Steps to Replicate - Setup Replication in DEMO database.
- Do not enable any replication rules. By default rules "R1100" and "R0100" are enabled both at HQ and Branch.
- Create a new product in HQ as "HQ001". Update the location to "Retail".
- Validate the product in Branch Server.
Findings - Both "LBS_Inventory" and "LBS_INV_LIST" details go to "LT_REPL_DATA_OUT_QUEUE" table.
- Only "LBS_Inventory" details go to the "LT_REPL_DATA_OUT" table.
- There is no update for "LBS_INV_LIST" in replication history.
|
Audit Notes: | Edited by sanjay on 05/03/19 10:33. |
17 Jan 2019 | 10:37AM Comment 1 by Sanjay (Link Technologies) Case 9849 added to project 10.1 |
18 Jan 2019 | 09: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):| - Changed the replication key column order to use Table column sequence id instead of primary key sequence id.
2. The issue was caused by: - Mis-match in primary key sequence between table column caused data not to replicate.
3. Next Step - UAT
|
|
23 Jan 2019 | 03: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 No | Test Description | Pass/Fail | 1 | Create replication between LINKSOFTHQ and LINKSOFTB1 | Pass | 2 | Do 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 - OS version: Windows 7
- Application version: 10.1.3.9
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFTHQ and LINKSOFTB1
Steps to reproduce failed scenarios:
Next Step: for closure
|
|
25 Jan 2019 | 11:57AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-01-2019 11:57 AM |
| Thanks Rashna |
|
09 Oct 2019 | 08: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 |