Openbravo Issue Tracking System - Retail Modules
View Issue Details
0033419Retail ModulesWeb POSpublic2016-06-30 16:442016-08-11 08:45
jorge-garcia 
Retail 
normalmajorsometimes
closedfixed 
5
 
RR16Q3 
marvintm
No
0033419: Sometimes synchronization of the syncmodels are failing when returning back from offline
It's failing sometimes in oracle
Using an environment with oracle.
1) Login online to the WEBPOS
2) Do a cashup. Wait to the synchronization.
2) Go offline
3) Create several order and do a cashup
4) Go online.
Sometimes, the synchronization process fails. This error is shown in tomcat:
2 Errors in the OBPOS_Errors table while importing POS data: >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
TYPE --> OBPOS_App_Cashup
ERROR -->
org.openbravo.base.exception.OBException: The cashup is processed, and it can not be set as unprocessed
No tags attached.
blocks defect 0033395 closed jorge-garcia Sometimes synchronization of the syncmodels are failing when returning back from offline 
Issue History
2016-07-05 09:02jorge-garciaTypedefect => backport
2016-07-05 09:02jorge-garciaTarget Version => RR16Q3
2016-07-05 11:50hgbotCheckin
2016-07-05 11:50hgbotNote Added: 0088203
2016-07-05 11:51hgbotCheckin
2016-07-05 11:51hgbotNote Added: 0088204
2016-07-05 11:51hgbotStatusscheduled => resolved
2016-07-05 11:51hgbotResolutionopen => fixed
2016-07-05 11:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR16Q3/rev/be7ed445aa546626d08e40d92f5826aa8013de8b [^]
2016-07-05 11:51hgbotCheckin
2016-07-05 11:51hgbotNote Added: 0088205
2016-08-04 11:54marvintmReview Assigned To => marvintm
2016-08-04 11:54marvintmStatusresolved => closed
2016-08-11 08:45hgbotCheckin
2016-08-11 08:45hgbotNote Added: 0088964

Notes
(0088203)
hgbot   
2016-07-05 11:50   
Repository: retail/backports/3.0RR16Q3/org.openbravo.retail.posterminal
Changeset: a30caba241e1b19fc022a4349c70551879b58029
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Tue Jul 05 11:49:55 2016 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR16Q3/org.openbravo.retail.posterminal/rev/a30caba241e1b19fc022a4349c70551879b58029 [^]

Related to issue 33419: Sometimes synchronization of the syncmodels are failing
when returning back from offline

Change SynchModels to use the new timestamp column.

---
M src/org/openbravo/retail/posterminal/importprocess/CashManagementImportEntryProcessor.java
M src/org/openbravo/retail/posterminal/importprocess/CashUpImportEntryProcessor.java
M src/org/openbravo/retail/posterminal/importprocess/OrderImportEntryProcessor.java
M src/org/openbravo/retail/posterminal/importprocess/VoidLayawayEntryProcessor.java
---
(0088204)
hgbot   
2016-07-05 11:51   
Repository: erp/backports/3.0PR16Q3
Changeset: be7ed445aa546626d08e40d92f5826aa8013de8b
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Tue Jul 05 11:49:24 2016 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR16Q3/rev/be7ed445aa546626d08e40d92f5826aa8013de8b [^]

Fixed issue 33419: Sometimes synchronization of the syncmodels are failing
when returning back from offline

Added a new column in c_import_entry table wich contains the timestamp in
miliseconds of the import entry.

With this new value, the import entry records are filtered.

---
M src-db/database/model/tables/C_IMPORT_ENTRY.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src/org/openbravo/service/importprocess/ImportEntryManager.java
---
(0088205)
hgbot   
2016-07-05 11:51   
Repository: retail/backports/3.0RR16Q3/pi-mobile
Changeset: 36d86ba82ab3882b66e25e4cf55405ca152c063c
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Tue Jul 05 11:47:59 2016 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR16Q3/pi-mobile/rev/36d86ba82ab3882b66e25e4cf55405ca152c063c [^]

Related to issue 33419: Sometimes synchronization of the syncmodels are failing
when returning back from offline

Reactivate offline tests:
* LoginOnlineAllowedFlows
* LoginOnlineAllowedFlowsWait

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/offline/LoginOnlineAllowedFlows.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/offline/LoginOnlineAllowedFlowsWait.java
---
(0088964)
hgbot   
2016-08-11 08:45   
Repository: tools/automation/pi-mobile
Changeset: 36d86ba82ab3882b66e25e4cf55405ca152c063c
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Tue Jul 05 11:47:59 2016 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/36d86ba82ab3882b66e25e4cf55405ca152c063c [^]

Related to issue 33419: Sometimes synchronization of the syncmodels are failing
when returning back from offline

Reactivate offline tests:
* LoginOnlineAllowedFlows
* LoginOnlineAllowedFlowsWait

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/offline/LoginOnlineAllowedFlows.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/offline/LoginOnlineAllowedFlowsWait.java
---