Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040814Retail ModulesStoreServerpublic2019-05-08 19:192019-05-30 10:29
ReporterAugustoMauch 
Assigned Tojarmendariz 
PrioritynormalSeveritymajorReproducibilityhave 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
Summary0040814: Improve the traceability of the store server state transitions
DescriptionCurrently, the only way to know about a store server previous state transitions is by checking the log. This is very inconvenient, and sometimes the log is not even available.

A better way to have traceability of the store server state transitions is by persisting the state changes in a table, that should be synchronized from the store servers to the central server using SymmetricDS.

At least the following actions should be persisted in that table:
- The status the store server has when it is started
- The moment when the status of a store server is set to OFFLINE
- The moment when the status of a store server is set to ONLINE

It could be also interesting to persist failed transitions to online and transitions to offline, including in the new table the reason why the transition failed

Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0040983 closed jarmendariz ServerStatusLogger cannot be instantiated using Weld in ant task 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-05-08 19:19AugustoMauchNew Issue
2019-05-08 19:19AugustoMauchAssigned To => jarmendariz
2019-05-08 19:19AugustoMauchTriggers an Emergency Pack => No
2019-05-15 13:30jarmendarizStatusnew => scheduled
2019-05-27 10:34hgbotCheckin
2019-05-27 10:34hgbotNote Added: 0112156
2019-05-27 10:34hgbotStatusscheduled => resolved
2019-05-27 10:34hgbotResolutionopen => fixed
2019-05-27 10:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/fc0ffc5a8f799ff785c284930f9690d51885b3e5 [^]
2019-05-27 11:15hgbotCheckin
2019-05-27 11:15hgbotNote Added: 0112157
2019-05-27 11:23hgbotCheckin
2019-05-27 11:23hgbotNote Added: 0112158
2019-05-27 11:24hgbotCheckin
2019-05-27 11:24hgbotNote Added: 0112159
2019-05-27 13:07hgbotCheckin
2019-05-27 13:07hgbotNote Added: 0112166
2019-05-28 15:44hgbotCheckin
2019-05-28 15:44hgbotNote Added: 0112209
2019-05-28 15:46AugustoMauchReview Assigned To => AugustoMauch
2019-05-28 15:46AugustoMauchNote Added: 0112210
2019-05-28 15:46AugustoMauchStatusresolved => closed
2019-05-30 10:29hgbotCheckin
2019-05-30 10:29hgbotNote Added: 0112259
2019-05-31 09:27jarmendarizRelationship addedrelated to 0040983

Notes
(0112156)
hgbot   
2019-05-27 10:34   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: fc0ffc5a8f799ff785c284930f9690d51885b3e5
Author: Javier Armendáriz <javier.armendariz <at> openbravo.com>
Date: Mon May 27 00:46:31 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/fc0ffc5a8f799ff785c284930f9690d51885b3e5 [^]

Fixed issue 40814: Improving traceability of store server transitions

Created a new table and read-only Window to log all state transitions
of the store server. All transitions entries should be created with the
utility class ServerStatusLogger.
This table should be synchronized with the central server.

---
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_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src-db/database/sourcedata/AD_TAB.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src-db/database/sourcedata/AD_TREENODE.xml
M src-db/database/sourcedata/AD_WINDOW.xml
M src/org/openbravo/mobile/core/servercontroller/MobileMainServerCheck.java
M src/org/openbravo/mobile/core/servercontroller/MobileServerController.java
A src-db/database/model/tables/OBMOBC_SERVER_STATUS_LOG.xml
A src/org/openbravo/mobile/core/servercontroller/log/ServerStatusLogger.java
A src/org/openbravo/mobile/core/servercontroller/log/ServerTransitionStatus.java
---
(0112157)
hgbot   
2019-05-27 11:15   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 919a50e4786668634e430fda3cc981c9f68b6404
Author: Javier Armendáriz <javier.armendariz <at> openbravo.com>
Date: Mon May 27 11:15:46 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/919a50e4786668634e430fda3cc981c9f68b6404 [^]

Related to issue 40814: Changed license text to OBCL

---
M src/org/openbravo/mobile/core/servercontroller/log/ServerStatusLogger.java
M src/org/openbravo/mobile/core/servercontroller/log/ServerTransitionStatus.java
---
(0112158)
hgbot   
2019-05-27 11:23   
Repository: erp/pmods/org.openbravo.replication.symmetricds
Changeset: e116961a03999cb96e76c5106dba44ea23f40611
Author: Javier Armendáriz <javier.armendariz <at> openbravo.com>
Date: Thu May 23 14:12:37 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/e116961a03999cb96e76c5106dba44ea23f40611 [^]

Related to issue 40814: Improve the traceability of store server transitions

Added to store server transitions log the initial state of the store server when
it starts up.

---
M src/org/openbravo/replication/symmetricds/SetupSymmetricListener.java
---
(0112159)
hgbot   
2019-05-27 11:24   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: a476aa9b957ad1ecbdcd6a1ed31b2bf2326162af
Author: Javier Armendáriz <javier.armendariz <at> openbravo.com>
Date: Thu May 23 14:13:28 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/a476aa9b957ad1ecbdcd6a1ed31b2bf2326162af [^]

Related to issue 40814: Improve the traceability of store server transitions

Server Transition Log table should be synchronized from the store servers to
be gathered in central server.

---
M src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml
---
(0112166)
hgbot   
2019-05-27 13:07   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 401cd8f8c43a03acd83cc90e781414c0ac0220d1
Author: Javier Armendáriz <javier.armendariz <at> openbravo.com>
Date: Mon May 27 13:07:05 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/401cd8f8c43a03acd83cc90e781414c0ac0220d1 [^]

Related to issue 40814: Fixing AD data

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0112209)
hgbot   
2019-05-28 15:44   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: fc410c92f1a5317de1dfc4b6927aff51693e7d9a
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue May 28 15:44:41 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/fc410c92f1a5317de1dfc4b6927aff51693e7d9a [^]

Related with issue 40814: Updates transition list item names

The names of the following list items have been updated, to make them more clear:

Transition to Online -> Successful Transition to Online
Transition to Offline -> Successful Transition to Offline

---
M src-db/database/sourcedata/AD_REF_LIST.xml
---
(0112210)
AugustoMauch   
2019-05-28 15:46   
Code reviewed and verified
(0112259)
hgbot   
2019-05-30 10:29   
Repository: erp/pmods/org.openbravo.replication.symmetricds
Changeset: 43778b7b84103bd75d17762399a1733cf6d4b9ef
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Thu May 30 10:29:51 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/rev/43778b7b84103bd75d17762399a1733cf6d4b9ef [^]

Related with issue 40814: Do not inject serverStatusLogger in tomcat listener

We have found that sometimes the serverStatusLogger is not properly injected. Now its instance is
created using WeldUtils instead.

---
M src/org/openbravo/replication/symmetricds/SetupSymmetricListener.java
---