Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039652Retail ModulesStoreServerpublic2018-11-20 11:152018-12-10 15:17
ReporterAugustoMauch 
Assigned Tomtaal 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039652: The synchronization of the m_product_service table is not properly configured
DescriptionThe synchronization of the m_product_service table is not properly configured. Right now it is being routed based on the organization of the entry in the m_product_service, but it could be the the record is defined in * (it is exported to all store servers) but either the referenced product or the referenced service belongs to an organization other than * (so they are present only in some store servers).

Steps To ReproduceIn a multiserver environment
Create a product in *
Create a service in specific organization not in the natural tree of a store server
Create a record in the m_product_service that links the product and the service. A synchronization error will occur because the record will be synchronized to the store server but the referenced service will not be present there.
Proposed SolutionExport/route the records of m_product_service to the stores that have access to:
- The organization of the m_product_service record and
- The organization of the product and
- The organization of the service
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-11-20 11:15AugustoMauchNew Issue
2018-11-20 11:15AugustoMauchAssigned To => Retail
2018-11-20 11:15AugustoMauchTriggers an Emergency Pack => No
2018-11-29 08:49mtaalAssigned ToRetail => mtaal
2018-12-01 22:33hgbotCheckin
2018-12-01 22:33hgbotNote Added: 0108208
2018-12-01 22:33hgbotStatusnew => resolved
2018-12-01 22:33hgbotResolutionopen => fixed
2018-12-01 22:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/9d7aab293fc4045790e0ff0c1a3bfe1cdef857e5 [^]
2018-12-07 13:22hgbotCheckin
2018-12-07 13:22hgbotNote Added: 0108328
2018-12-08 22:12hgbotCheckin
2018-12-08 22:12hgbotNote Added: 0108339
2018-12-09 12:54hgbotCheckin
2018-12-09 12:54hgbotNote Added: 0108344
2018-12-09 12:54hgbotCheckin
2018-12-09 12:54hgbotNote Added: 0108345
2018-12-09 22:07mtaalReview Assigned To => AugustoMauch
2018-12-10 15:17AugustoMauchNote Added: 0108361
2018-12-10 15:17AugustoMauchStatusresolved => closed

Notes
(0108208)
hgbot   
2018-12-01 22:33   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: 9d7aab293fc4045790e0ff0c1a3bfe1cdef857e5
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Sat Dec 01 22:33:09 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/9d7aab293fc4045790e0ff0c1a3bfe1cdef857e5 [^]

Fixes issue 39652: The synchronization of the m_product_service table is not properly configured
Added router and updated dataset

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
M src-db/database/sourcedata/STRSYNC_CUSTOM_ROUTER.xml
M src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml
A src/org/openbravo/retail/storeserver/synchronization/router/ProductServiceRouter.java
---
(0108328)
hgbot   
2018-12-07 13:22   
Repository: erp/pmods/org.openbravo.replication.symmetricds
Changeset: 7c2d862cae72277d8277deeba1118a005d4ab176
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Fri Dec 07 13:22:52 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/7c2d862cae72277d8277deeba1118a005d4ab176 [^]

Related to issue 39652: The synchronization of the m_product_service table is not properly configured
provide query in log if error occurs

---
M src/org/openbravo/replication/symmetricds/validation/ExportedTableValidator.java
---
(0108339)
hgbot   
2018-12-08 22:12   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: e3b2427a9de93a9f633c79c80487522cb505a996
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Sat Dec 08 22:12:10 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/e3b2427a9de93a9f633c79c80487522cb505a996 [^]

Related to issue 39652: The synchronization of the m_product_service table is not properly configured
Correct syntax so it works with Oracle

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0108344)
hgbot   
2018-12-09 12:54   
Repository: tools/automation/pi-mobile
Changeset: d28b468ffe72ca06b43261f40ba10194629d5bd4
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Sun Dec 09 12:53:50 2018 +0100
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/d28b468ffe72ca06b43261f40ba10194629d5bd4 [^]

Related to issue 39652, 39722 add tests

---
M src-test/org/openbravo/test/mobile/retail/multiserver/MultiserverUtils.java
M src-test/org/openbravo/test/mobile/retail/multiserver/unittests/suites/dbsynch/DatabaseSynchronizationSuite.java
A src-test/org/openbravo/test/mobile/retail/multiserver/unittests/tests/functionaldbsynch/LocationSynchronization.java
A src-test/org/openbravo/test/mobile/retail/multiserver/unittests/tests/functionaldbsynch/ProductServiceSynchronization.java
---
(0108345)
hgbot   
2018-12-09 12:54   
Repository: tools/automation/pi-mobile
Changeset: 22011f880e13920c6bbf3fcee781cab749338295
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Sun Dec 09 12:54:18 2018 +0100
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/22011f880e13920c6bbf3fcee781cab749338295 [^]

Related to issue 39652, 39722 add tests
Do db sync tests as part of the other store1 tests

---
M build.xml
---
(0108361)
AugustoMauch   
2018-12-10 15:17   
Code reviewed and verified