Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040336Retail ModulesWeb POSpublic2019-03-07 12:352019-05-02 15:17
Reportermalsasua 
Assigned TojavierRodriguez 
PriorityurgentSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q3 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerGold
Support ticket8538
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040336: sales orders are missing when environment is updated from 17Q3 to 18Q3
Descriptionwhen there are sales orders pending to sync in the terminal, and system is updated from 17Q3 (or before) to 18Q3 (or higher), the sales orders never are synced to the backoffice.
Steps To Reproduce[POS]
. in 17Q3
. go offline
. complete Sales Order SO1 -> record is stored in message local table

. update to 18Q3
. go online
. the records in local table are deleted, but sales order SO1 is not sent to backoffice -> there is not any record in Data IMport Entry with this sales order

It seems that this problem is generated by Terminal Log functionality, as it is changing the table "message" structure (see attachments)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0040729RR19Q2 closed javierRodriguez sales orders are missing when environment is updated from 17Q3 to 18Q3 
depends on backport 0040730RR19Q1.1 closed javierRodriguez sales orders are missing when environment is updated from 17Q3 to 18Q3 
related to backport 0040484RR19Q1.1 closed rqueralta Cashup with corrupted data is synced after to update to 18Q3 
causes defect 0040852 closed javierRodriguez Unable to login in WebPOS if it has synchronize mode and French certificate 
Attached Filespng MESSAGE_TABLE_17Q3.png (348,096) 2019-03-07 13:04
https://issues.openbravo.com/file_download.php?file_id=12715&type=bug
png MESSAGE_TABLE_18Q3.png (355,222) 2019-03-07 13:04
https://issues.openbravo.com/file_download.php?file_id=12716&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-03-07 12:35malsasuaNew Issue
2019-03-07 12:35malsasuaAssigned To => Retail
2019-03-07 12:35malsasuaOBNetwork customer => Gold
2019-03-07 12:35malsasuaSupport ticket => 8538
2019-03-07 12:35malsasuaResolution time => 1552172400
2019-03-07 12:35malsasuaTriggers an Emergency Pack => No
2019-03-07 13:04malsasuaFile Added: MESSAGE_TABLE_17Q3.png
2019-03-07 13:04malsasuaFile Added: MESSAGE_TABLE_18Q3.png
2019-03-07 13:15malsasuaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=18400#r18400
2019-03-07 16:33rqueraltaAssigned ToRetail => rqueralta
2019-03-07 16:36rqueraltaStatusnew => scheduled
2019-03-07 23:21rafarodaIssue Monitored: rafaroda
2019-03-12 09:33javierRodriguezResolution time1552172400 =>
2019-03-12 09:33javierRodriguezAssigned Torqueralta => javierRodriguez
2019-03-12 09:33javierRodriguezTypedefect => design defect
2019-04-23 09:03marvintmTypedesign defect => defect
2019-04-25 08:54hgbotCheckin
2019-04-25 08:54hgbotNote Added: 0111297
2019-04-25 08:54hgbotStatusscheduled => resolved
2019-04-25 08:54hgbotResolutionopen => fixed
2019-04-25 08:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/d8e541e2640072aa6f992bcd1e209b68ea9cbc05 [^]
2019-04-30 14:37javierRodriguezStatusresolved => new
2019-04-30 14:37javierRodriguezResolutionfixed => open
2019-04-30 14:38javierRodriguezStatusnew => scheduled
2019-04-30 14:38javierRodriguezStatusscheduled => resolved
2019-04-30 14:38javierRodriguezResolutionopen => fixed
2019-05-02 11:21hgbotCheckin
2019-05-02 11:21hgbotNote Added: 0111423
2019-05-02 15:16marvintmAssigned TojavierRodriguez => marvintm
2019-05-02 15:17marvintmAssigned Tomarvintm => javierRodriguez
2019-05-02 15:17marvintmReview Assigned To => marvintm
2019-05-02 15:17marvintmStatusresolved => closed
2019-05-02 15:17marvintmFixed in Version => RR19Q3
2019-05-17 18:36dmitry_mezentsevRelationship addedcauses 0040852
2019-07-23 12:35rafarodaRelationship addedrelated to 0040484

Notes
(0111297)
hgbot   
2019-04-25 08:54   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: d8e541e2640072aa6f992bcd1e209b68ea9cbc05
Author: Javier Rodriguez <javier.rodriguez <at> openbravo.com>
Date: Thu Apr 25 08:54:02 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/d8e541e2640072aa6f992bcd1e209b68ea9cbc05 [^]

Fixed issue 40336: sales orders are missing when environment is updated from 17Q3 to 18Q3

Created a new function to check if there is any data to sync in message table before drop all local database

if there is something, the app will try to sync all this data. if any data failed, A pop up will be shown and it will
force to relog again.

there is also a modification in sendAllMessages function wich allow as to add a callback and also a errorcalback

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M web/org.openbravo.mobile.core/source/data/ob-requestrouter.js
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
---
(0111423)
hgbot   
2019-05-02 11:21   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: d8ab7ccd0c01d22c0ddbdac4534a64f437c06f38
Author: Javier Rodriguez <javier.rodriguez <at> openbravo.com>
Date: Thu May 02 11:21:11 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/d8ab7ccd0c01d22c0ddbdac4534a64f437c06f38 [^]

Related to issue 40336

---
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
---