Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034943
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Retail Modules] StoreServerminorhave not tried2017-01-13 10:212017-01-25 09:51
ReportermtaalView Statuspublic 
Assigned Tomtaal 
PrioritynormalResolutionfixedFixed in VersionRR17Q2
StatusclosedFix in branchFixed in SCM revision65b2d94b5251
ProjectionnoneETAnoneTarget VersionRR17Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToSandrahuguet
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034943: Implement on-demand replication of process run from store to central server

DescriptionThe ad_process_run table is a table which is frequently updated and also replicated from store to central. This means that there is often data to replicate from store to central. With 300 stores this puts a high load on central and also makes it more difficult for a store to go online as there is data to sync also when the store is not allowing webpos to work.

Also the ad_process_run only needs to be present in central for analyses purposes and nothing more.
Steps To ReproduceInstall multi-server
Proposed Solution- add column to ad_process_run table: sync_to_central, default N
- give ad_process_run special router which ignores all records which have sync_to_central to N
- add a button in mobile server window to replicate 1000 records from store to central for selected mobile server
- when button is pressed call store server with a webservice
- in the webservice pick the last updated 1000 records with sync_to_central to N and set the column to Y
- the 1000 records are replicated
- by pressing the button multiple times the user can download 1000 records more everytime.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0093537)
hgbot (developer)
2017-01-13 14:06

 Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: 6dcfe3b563be00c7879d0bbf1f6c15e6adc31330
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Fri Jan 13 14:03:46 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/6dcfe3b563be00c7879d0bbf1f6c15e6adc31330 [^]

Related with issue 34943:Only process runs with synch_to_central='y' are synced

A new column has been added to ad_process_run: em_obstsyn_sync_to_central. This column determines if a process run should be synchronized from a store server to the central server.

A new router has been added: ProcessRunRouter. This router will only synchronize the entries of ad_process_run whose em_obstsyn_sync_to_central value is 'Y'.

---
M src-db/database/model/modifiedTables/AD_PROCESS_RUN.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.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/ProcessRunRouter.java
---
(0093566)
hgbot (developer)
2017-01-16 00:19

 Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: 65b2d94b5251c1aa1bd815b0d6da75e68ba3752c
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Mon Jan 16 00:19:03 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/65b2d94b5251c1aa1bd815b0d6da75e68ba3752c [^]

Fixes issue 34943: Implement on-demand replication of process run from store to central server
Add button to send request to store server to set process run flag so that it gets replicated.
Add new window to show the server process runs directly in the roottab

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_TAB.xml
M src-db/database/sourcedata/AD_TREENODE.xml
M src-db/database/sourcedata/AD_WINDOW.xml
M src-db/database/sourcedata/OBUIAPP_PROCESS.xml
A src-db/database/model/modifiedTables/OBMOBC_SERVER_DEFINITION.xml
A src/org/openbravo/retail/storeserver/synchronization/process/MobileServerFlagProcessRunToReplicate.java
A src/org/openbravo/retail/storeserver/synchronization/process/MobileServerRetrieveProcessRun.java
---
(0093807)
hgbot (developer)
2017-01-25 09:31

 Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: 750baf3514b3eec96cf708f1e84a19c2fb5bea1d
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Jan 25 09:31:22 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/750baf3514b3eec96cf708f1e84a19c2fb5bea1d [^]

related to issue 34943 applied code review

---
M src/org/openbravo/retail/storeserver/synchronization/router/ProcessRunRouter.java
---
(0093809)
Sandrahuguet (developer)
2017-01-25 09:51

 reviewed and tested

- Issue History
Date Modified Username Field Change
2017-01-13 10:21 mtaal New Issue
2017-01-13 10:21 mtaal Assigned To => mtaal
2017-01-13 10:21 mtaal Triggers an Emergency Pack => No
2017-01-13 13:59 AugustoMauch Assigned To mtaal => AugustoMauch
2017-01-13 14:06 hgbot Checkin
2017-01-13 14:06 hgbot Note Added: 0093537
2017-01-13 14:08 AugustoMauch Assigned To AugustoMauch => mtaal
2017-01-16 00:19 hgbot Checkin
2017-01-16 00:19 hgbot Note Added: 0093566
2017-01-16 00:19 hgbot Status new => resolved
2017-01-16 00:19 hgbot Resolution open => fixed
2017-01-16 00:19 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/65b2d94b5251c1aa1bd815b0d6da75e68ba3752c [^]
2017-01-18 16:33 mtaal Review Assigned To => Sandrahuguet
2017-01-25 09:31 hgbot Checkin
2017-01-25 09:31 hgbot Note Added: 0093807
2017-01-25 09:51 Sandrahuguet Note Added: 0093809
2017-01-25 09:51 Sandrahuguet Status resolved => closed
2017-01-25 09:51 Sandrahuguet Fixed in Version => RR17Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker