Company: Link Technologies
Case No: L12581. Project: 13.10: LinkSOFT version 13.10 - Improvements and Stabilisation
Logged By: Sanjay (Link Technologies) on 20 Sep 2021 11:28AM
Priority: Low
Product: Point of Sale
Group: Enhancement
Time Taken: 21.00 (Weight: 23.00)
Version: 13.10.1011
Assigned To: Sanjay (Link Technologies)
Circulation: Rashna, Sanjay
Resolve By: Friday, 24 September 2021 11:59 PM [943 days since logged date]
Status: Closed
Subject: Replication Rule - Send Transactions to Configured Locations - Handle NO CONFIGURED LOCATIONS
Summary:    

When configuring location filters on Replication servers, we define which locations will receive the transactions.

In some cases, we want to use Location filters, however, we also want to set up a server that receives all location transactions, for example, a Reporting Server.

To achieve this, we can configure the Reporting server as a Branch, and leave the Locations BLANK. 

The current version stops all transactions from going into the Reporting server.

If we turn off the rule for the location filter, all transactions go to all branches.

To resolve this, can we implement the condition:

  1. If no locations are configured, we send all transactions


Audit Notes:Edited by sanjay on 21/09/21 09:31. Edited by sanjay on 20/09/21 11:28. 
20 Sep 202111:28AM Comment 1 by Sanjay (Link Technologies) ETC was changed from 24/09/2021 to 24/09/2021
20 Sep 202102:09PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 22-09-2021 02:08 PM Time Taken: 14.00
PART A - Development work for this case has been completed.

1. The change will be available in version:13.04

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

  1. Changed behaviour so that when no locations are configured, we send all data to that location.

3. Affected Areas:

  1. Replication with Transactions Limits

4. The issue was caused by:

  1. Improvement

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


28 Sep 202108:57AM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 30-09-2021 08:32 AM Time Taken: 4.00

System test revealed that when doing compare data with a table that required Location, we get a syntax error.

The issue was caused by "Compare Data by Table" not having any configured locations. 

Corrected the issue by setting "ALL" locations for tables that require a location.


29 Sep 202111:39AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 01-10-2021 11:18 AM Time Taken: 2.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1
  1. Set up replication 
    1. LINKSOFT- HQ
    2. LINKSOFT-B1
  2. Do not enable replication rules.
  3. Create an adjustment for item FC11,  validate this adjustment is replicated to the branch database 
 Pass 
 2
  1. Enable replication rules 2 and 3
  2. Do not configure any locations for
  3. Create an adjustment for itemFC11 for locations "Retail" and "Main".
  4. Validate both adjustments are replicated
 Pass 
 3 
  1. Enable replication rules 2 and 3
  2. Configure locations "Retail" for the branch server.
  3. Create an adjustment for itemFC11 for locations "Retail" and "Main".
  4. Validate only the adjustments for "Retail" is replicated
 Pass 
 4
  1. Compare data using table "LBS_INVENTORY", validate compare is completed without syntax error
 Pass 

Environment Details

  1. OS version:
  2. Application version:13.03.0928RC5
  3. Setup on:
    1. Server:LinkQA4
    2. Database:UAT-LINKSOFT
    3. LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


30 Sep 202110:45AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-10-2021 10:45 AM Time Taken: 1.00
Thanks Rashna

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

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