Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033395Retail ModulesWeb POSpublic2016-06-30 16:442016-08-11 18:40
Reporterjorge-garcia 
Assigned Tojorge-garcia 
PrioritynormalSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033395: Sometimes synchronization of the syncmodels are failing when returning back from offline
DescriptionIt's failing sometimes in oracle
Steps To ReproduceUsing 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0033419RR16Q3 closed Retail Sometimes synchronization of the syncmodels are failing when returning back from offline 
depends on backport 0033420RR16Q2.1 closed jorge-garcia Sometimes synchronization of the syncmodels are failing when returning back from offline 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-06-30 16:44jorge-garciaNew Issue
2016-06-30 16:44jorge-garciaAssigned To => Retail
2016-06-30 16:44jorge-garciaTriggers an Emergency Pack => No
2016-06-30 18:16hgbotCheckin
2016-06-30 18:16hgbotNote Added: 0088113
2016-07-05 09:02jorge-garciaStatusnew => scheduled
2016-07-05 09:02jorge-garciaAssigned ToRetail => jorge-garcia
2016-07-05 09:21hgbotCheckin
2016-07-05 09:21hgbotNote Added: 0088183
2016-07-05 09:21hgbotStatusscheduled => resolved
2016-07-05 09:21hgbotResolutionopen => fixed
2016-07-05 09:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6e74d1707a90b4f40fd57f1fd7a7755393941543 [^]
2016-07-05 09:22hgbotCheckin
2016-07-05 09:22hgbotNote Added: 0088184
2016-07-05 09:23hgbotCheckin
2016-07-05 09:23hgbotNote Added: 0088185
2016-07-06 09:22marvintmReview Assigned To => marvintm
2016-07-06 09:22marvintmStatusresolved => closed
2016-08-11 18:40hudsonbotCheckin
2016-08-11 18:40hudsonbotNote Added: 0088987

Notes
(0088113)
hgbot   
2016-06-30 18:16   
Repository: tools/automation/pi-mobile
Changeset: 0455e3fdfa3b71bbb8e3110f6392d606f3771e86
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Thu Jun 30 18:15:28 2016 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/0455e3fdfa3b71bbb8e3110f6392d606f3771e86 [^]

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

Deactivate 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
---
(0088183)
hgbot   
2016-07-05 09:21   
Repository: erp/devel/pi
Changeset: 6e74d1707a90b4f40fd57f1fd7a7755393941543
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Tue Jul 05 09:19:11 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6e74d1707a90b4f40fd57f1fd7a7755393941543 [^]

Fixed issue 33395: 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
---
(0088184)
hgbot   
2016-07-05 09:22   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 46abbcac55752a2ba12b538d5f9540b48c3ea895
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Tue Jul 05 09:15:21 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/46abbcac55752a2ba12b538d5f9540b48c3ea895 [^]

Related to issue 33395: 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
---
(0088185)
hgbot   
2016-07-05 09:23   
Repository: tools/automation/pi-mobile
Changeset: 077c7ab774dbd084ac0aa0438512f698b2ab0b9f
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Tue Jul 05 09:14:19 2016 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/077c7ab774dbd084ac0aa0438512f698b2ab0b9f [^]

Related to issue 33395: 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
---
(0088987)
hudsonbot   
2016-08-11 18:40   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/edaa05b1fb18 [^]
Maturity status: Test