Company: Link Technologies
Case No: L08406. Project: 08.20: LinkSOFT Version 8.2
Logged By: Alvis (Link Technologies) on 15 Mar 2017 10:14AM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 9.00 (Weight: 9.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna
Resolve By: Friday, 10 March 2017 12:00 AM [2592 days since logged date]
Status: Closed
Subject: Replication Data from HQ is taking Longer Time to Process
Summary:    

Customer contacted and advised that replication from HQ was slow to all the other branches. There is about 300K data in the replication out queue processing which is taking a longer time to process. He requested for it to be diagnosed.

Vineet

Audit Notes:
15 Mar 201710:16AM Comment 1 by Alvis (Link Technologies) Case 8406 added to project 8.10.001
16 Mar 201708:23AM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-03-2017 08:23 AM Time Taken: 6.00
Development work for this case has been completed.
The change will be available in version: 8.10.001
Documentation update required(Yes/No. Add change details below): No
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):

  1. The issue was caused by the out queue process which was reading heavily on LT_REPL_DATA_OUT_QUEUE table. This caused locks in the process and was slowing down replication.
  2. We have refactored the process to read data into a temp table before looping through the records. This has resolved locks and replication is processing fast. The change was tested in customers environment.

Documentation details:
  

13 Apr 201703:14PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Development Followup Date: 14-04-2017 12:00 AM Time Taken: 3.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? No
Additional Details (Risks, issues, special conditions required for this test to pass etc):

Test Plan

  1. Created replication with 3 branches. Branch 1 and 2 on QA1 and branch 3 in QA4.
  2. Did a inventory upload of 1589 items at HQ.
  3. This data was replicated to all branches in 17 minutes. The out que at HQ was 0

13 Apr 201703:23PM Comment 4 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-04-2017 03:23 PM
documentation not required.

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

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