Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033420Retail ModulesWeb POSpublic2016-06-30 16:442016-07-06 09:19
Reporterjorge-garcia 
Assigned Tojorge-garcia 
PrioritynormalSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR16Q2.1Fixed 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
Summary0033420: 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
blocks defect 0033395 closed jorge-garcia Sometimes synchronization of the syncmodels are failing when returning back from offline 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-07-05 09:02jorge-garciaTypedefect => backport
2016-07-05 09:02jorge-garciaTarget Version => RR16Q2.1
2016-07-05 12:49hgbotCheckin
2016-07-05 12:49hgbotNote Added: 0088206
2016-07-05 12:49hgbotStatusscheduled => resolved
2016-07-05 12:49hgbotResolutionopen => fixed
2016-07-05 12:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR16Q2.1/rev/e5e6e0d26f32235fb7b667ec188b1cba5be52527 [^]
2016-07-05 12:50hgbotCheckin
2016-07-05 12:50hgbotNote Added: 0088207
2016-07-05 18:43marvintmAssigned ToRetail => jorge-garcia
2016-07-06 09:19marvintmReview Assigned To => marvintm
2016-07-06 09:19marvintmStatusresolved => closed

Notes
(0088206)
hgbot   
2016-07-05 12:49   
Repository: erp/backports/3.0PR16Q2.1
Changeset: e5e6e0d26f32235fb7b667ec188b1cba5be52527
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Tue Jul 05 12:48:48 2016 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR16Q2.1/rev/e5e6e0d26f32235fb7b667ec188b1cba5be52527 [^]

Fixed issue 33420: 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
---
(0088207)
hgbot   
2016-07-05 12:50   
Repository: retail/backports/3.0RR16Q2.1/org.openbravo.retail.posterminal
Changeset: 105f8f3ce90bf8c14dece1e59ab21f94b10aab7e
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Tue Jul 05 12:27:40 2016 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR16Q2.1/org.openbravo.retail.posterminal/rev/105f8f3ce90bf8c14dece1e59ab21f94b10aab7e [^]

Related to issue 33420: 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
---