Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033235Retail ModulesWeb POSpublic2016-06-13 15:402016-07-01 07:34
Reportermtaal 
Assigned Tomtaal 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR16Q3Fixed in Version 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033235: Replicating transactions - research a different way to execute transactions in a multi-server environment
DescriptionSee:
http://wiki.openbravo.com/wiki/Projects:Store_Server_Replicating_Transactional_Tables_Research [^]
Steps To ReproduceSee Description
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
causes defect 0033396 closed AugustoMauch NPE with symmetric DS modules installed but not used in tomcat 
Attached Filesdiff retail.storeserver.synchronization.but.diff (11,996) 2016-06-16 23:22
https://issues.openbravo.com/file_download.php?file_id=9548&type=bug
diff erp-core.diff (453) 2016-06-16 23:22
https://issues.openbravo.com/file_download.php?file_id=9551&type=bug
diff retail.storeserver.synchronization.diff (75,601) 2016-06-17 08:44
https://issues.openbravo.com/file_download.php?file_id=9552&type=bug
diff mobile-core.diff (13,584) 2016-06-17 08:45
https://issues.openbravo.com/file_download.php?file_id=9553&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-06-13 15:40mtaalNew Issue
2016-06-13 15:40mtaalAssigned To => mtaal
2016-06-13 15:40mtaalTriggers an Emergency Pack => No
2016-06-16 23:22mtaalFile Added: retail.storeserver.synchronization.but.diff
2016-06-16 23:22mtaalFile Added: retail.storeserver.synchronization.diff
2016-06-16 23:22mtaalFile Added: mobile-core.diff
2016-06-16 23:22mtaalFile Added: erp-core.diff
2016-06-17 08:44mtaalFile Deleted: mobile-core.diff
2016-06-17 08:44mtaalFile Deleted: retail.storeserver.synchronization.diff
2016-06-17 08:44mtaalFile Added: retail.storeserver.synchronization.diff
2016-06-17 08:45mtaalFile Added: mobile-core.diff
2016-06-22 00:50mtaalTarget VersionRR16Q4 => RR16Q3
2016-06-22 00:53hgbotCheckin
2016-06-22 00:53hgbotNote Added: 0087760
2016-06-22 00:53hgbotStatusnew => resolved
2016-06-22 00:53hgbotResolutionopen => fixed
2016-06-22 00:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/c25bf709408039c95d9f8bb32b202f65d3ccf88f [^]
2016-06-22 01:08hgbotCheckin
2016-06-22 01:08hgbotNote Added: 0087761
2016-06-22 01:10hgbotCheckin
2016-06-22 01:10hgbotNote Added: 0087762
2016-06-30 18:33AugustoMauchRelationship addedcauses 0033396
2016-07-01 07:34migueldejuanaReview Assigned To => migueldejuana
2016-07-01 07:34migueldejuanaNote Added: 0088123
2016-07-01 07:34migueldejuanaStatusresolved => closed

Notes
(0087760)
hgbot   
2016-06-22 00:53   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: c25bf709408039c95d9f8bb32b202f65d3ccf88f
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Jun 22 00:53:07 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/c25bf709408039c95d9f8bb32b202f65d3ccf88f [^]

Fixes issue 33235: Replicating transactions - research a different way to execute transactions in a multi-server environment

DataSynchronizationProcess.java --> display the causing exception message in synchronized mode
MultiServerJSONProcess.java --> execute a transaction in only one server if the correct json parameter was set, create archived import entry in a different way to prevent it interfering with any replication mechanism
javascript changes --> send in the right parameter to force execution on one server.

---
M src/org/openbravo/mobile/core/process/DataSynchronizationProcess.java
M src/org/openbravo/mobile/core/servercontroller/MultiServerJSONProcess.java
M web/org.openbravo.mobile.core/source/data/ob-datasource.js
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
---
(0087761)
hgbot   
2016-06-22 01:08   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization.but
Changeset: 8c16380354a303c569b462358b87b8c24d5672c2
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Jun 22 01:08:16 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization.but/rev/8c16380354a303c569b462358b87b8c24d5672c2 [^]

Related to issue 33235: Replicating transactions - research a different way to execute transactions in a multi-server environment
Add specific transactional tables to the synchronized table

---
M src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml
---
(0087762)
hgbot   
2016-06-22 01:10   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: 917636f6cb987db465215007cdc7eb0901b283eb
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Jun 22 01:10:29 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/917636f6cb987db465215007cdc7eb0901b283eb [^]

Related to issue 33235: Replicating transactions - research a different way to execute transactions in a multi-server environment
Implement writer filter adapters to update computed fields after replication. Add a multi-server json hook to give
symmetric ds a kick.
Added new tables to the synchronized table and store server dataset

---
M src-db/database/sourcedata/AD_DATASET_COLUMN.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
M src-db/database/sourcedata/STRSYNC_EXCLUDEDCOL.xml
M src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml
M src/org/openbravo/retail/storeserver/synchronization/ImportEntryWriterFilterAdapter.java
A src/org/openbravo/retail/storeserver/synchronization/CustomerCreditWriterFilterAdapter.java
A src/org/openbravo/retail/storeserver/synchronization/InventoryWriterFilterAdapter.java
A src/org/openbravo/retail/storeserver/synchronization/MultiServerJSONSymmetricDSStarter.java
A src/org/openbravo/retail/storeserver/synchronization/OrderDocumentNoWriterFilterAdapter.java
---
(0088123)
migueldejuana   
2016-07-01 07:34   
Tested and reviewed