Openbravo Issue Tracking System - Retail Modules |
View Issue Details |
|
ID | Project | Category | View Status | Date Submitted | Last Update |
0029055 | Retail Modules | Web POS | public | 2015-02-24 19:59 | 2015-03-30 14:15 |
|
Reporter | marvintm | |
Assigned To | marvintm | |
Priority | normal | Severity | major | Reproducibility | have not tried |
Status | closed | Resolution | fixed | |
Platform | | OS | 5 | OS Version | |
Product Version | | |
Target Version | RR15Q2 | Fixed in Version | RR15Q2 | |
Merge Request Status | |
Review Assigned To | malsasua |
OBNetwork customer | |
Support ticket | |
Regression level | |
Regression date | |
Regression introduced in release | |
Regression introduced by commit | |
Triggers an Emergency Pack | No |
|
Summary | 0029055: Web POS doesn't handle update of local database tables correctly |
Description | Right now there are several different problems in the way Web POS handles updates of both the main module and other extension modules:
- The Web POS only considers that the database needs to be updated when the database version is changed. This is an unreliable method for the Web POS as this version is not automatically updated each release, and doesn't work in case extension modules add tables to the database
- The update process is very intrusive because it basically drops the whole database and recreates it again.
The idea is to improve both problems with the following idea: Now the Web POS will not track database versions. Instead, it will store a structure descriptor of each model in the local storage. Whenever one of them is found to have changed, the model itself will be updated, but the rest of the models will be untouched.
This mechanism will automatically work also for extension modules which add their own models to the system. The same checks will be done for them, and the update will be handled in the same way.
|
Steps To Reproduce | Update to a newer version of the Web POS.
Notice that most of the times you need to delete the browser cache for the Web POS to work again. |
Proposed Solution | |
Additional Information | |
Tags | No tags attached. |
Relationships | related to | defect | 0029282 | | closed | Orekaria | Stabilization: The context should be explicitly saved when the user has logged in | related to | defect | 0029283 | | closed | Orekaria | Stabilization: When, in the local database, there is not the table to be synchronized, move to the next sync model | depends on | feature request | 0028933 | RR16Q1 | closed | Retail | QA: RR15Q2: Add tests for Mobile applications | depends on | defect | 0029290 | | closed | Orekaria | Stabilization: The 'OB.MobileApp.model.syncAllModels' process should be executed once | has duplicate | feature request | 0028410 | RR15Q3 | closed | marvintm | Update client web sql in robust manner when the database schema changes | has duplicate | defect | 0026157 | | closed | marvintm | Web POS doesn't reset the database if the modules or the Web POS itself change | related to | defect | 0029351 | | closed | Orekaria | Stabilization: A call to 'ProfileUtils' is being executed while logging out | blocks | feature request | 0029186 | | closed | Orekaria | Add a method to retrieve the status of the Sync Models | blocks | feature request | 0029281 | | closed | Orekaria | Stabilization: Raise the log level of the OB.Dal.find errors, from 'warn' to 'error' | blocks | design defect | 0029280 | | closed | Orekaria | Stabilization: Session related management requires a synchronous flow | blocks | feature request | 0029377 | RR15Q3 | closed | Orekaria | Stabilization: RR15Q2 related | causes | defect | 0029394 | | closed | Orekaria | Stabilization: Better calls to setUserModelOnline | causes | defect | 0029670 | pi | closed | marvintm | WebPOS does not work on the lastest beta Chrome release (43) |
|
Attached Files | |
|
Issue History |
Date Modified | Username | Field | Change |
2015-02-24 19:59 | marvintm | New Issue | |
2015-02-24 19:59 | marvintm | Assigned To | => marvintm |
2015-02-24 19:59 | marvintm | Triggers an Emergency Pack | => No |
2015-02-24 20:09 | hgbot | Checkin | |
2015-02-24 20:09 | hgbot | Note Added: 0074885 | |
2015-02-24 20:09 | hgbot | Status | new => resolved |
2015-02-24 20:09 | hgbot | Resolution | open => fixed |
2015-02-24 20:09 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/ad49f99476b7425a360d7d2e540d1e314d36e13f [^] |
2015-02-24 20:09 | hgbot | Checkin | |
2015-02-24 20:09 | hgbot | Note Added: 0074886 | |
2015-02-25 19:02 | hgbot | Checkin | |
2015-02-25 19:02 | hgbot | Note Added: 0074937 | |
2015-02-26 13:44 | hgbot | Checkin | |
2015-02-26 13:44 | hgbot | Note Added: 0074966 | |
2015-02-26 20:04 | hgbot | Checkin | |
2015-02-26 20:04 | hgbot | Note Added: 0075000 | |
2015-03-04 11:46 | hgbot | Checkin | |
2015-03-04 11:46 | hgbot | Note Added: 0075148 | |
2015-03-04 11:56 | hgbot | Checkin | |
2015-03-04 11:56 | hgbot | Note Added: 0075149 | |
2015-03-04 12:28 | hgbot | Checkin | |
2015-03-04 12:28 | hgbot | Note Added: 0075153 | |
2015-03-04 13:13 | hgbot | Checkin | |
2015-03-04 13:13 | hgbot | Note Added: 0075157 | |
2015-03-04 17:35 | hgbot | Checkin | |
2015-03-04 17:35 | hgbot | Note Added: 0075164 | |
2015-03-04 17:36 | hgbot | Checkin | |
2015-03-04 17:36 | hgbot | Note Added: 0075165 | |
2015-03-04 18:36 | hgbot | Checkin | |
2015-03-04 18:36 | hgbot | Note Added: 0075172 | |
2015-03-05 14:25 | hgbot | Checkin | |
2015-03-05 14:25 | hgbot | Note Added: 0075195 | |
2015-03-05 15:04 | hgbot | Checkin | |
2015-03-05 15:04 | hgbot | Note Added: 0075197 | |
2015-03-09 00:20 | hgbot | Checkin | |
2015-03-09 00:20 | hgbot | Note Added: 0075287 | |
2015-03-09 07:46 | Orekaria | Note Added: 0075289 | |
2015-03-09 08:45 | Orekaria | Relationship added | blocks 0029186 |
2015-03-09 08:46 | Orekaria | Relationship added | depends on 0028933 |
2015-03-09 09:52 | Orekaria | Note Deleted: 0075289 | |
2015-03-09 19:58 | hgbot | Checkin | |
2015-03-09 19:58 | hgbot | Note Added: 0075348 | |
2015-03-13 15:55 | hgbot | Checkin | |
2015-03-13 15:55 | hgbot | Note Added: 0075575 | |
2015-03-13 22:41 | Orekaria | Relationship added | blocks 0029281 |
2015-03-13 22:42 | Orekaria | Relationship added | blocks 0029280 |
2015-03-14 06:08 | hgbot | Checkin | |
2015-03-14 06:08 | hgbot | Note Added: 0075592 | |
2015-03-14 06:09 | hgbot | Checkin | |
2015-03-14 06:09 | hgbot | Note Added: 0075593 | |
2015-03-14 06:09 | hgbot | Checkin | |
2015-03-14 06:09 | hgbot | Note Added: 0075594 | |
2015-03-14 06:09 | hgbot | Checkin | |
2015-03-14 06:09 | hgbot | Note Added: 0075597 | |
2015-03-14 06:16 | Orekaria | Relationship added | related to 0029282 |
2015-03-14 06:16 | Orekaria | Relationship added | related to 0029283 |
2015-03-14 06:18 | Orekaria | Note Added: 0075598 | |
2015-03-14 06:18 | Orekaria | Note Edited: 0075598 | bug_revision_view_page.php?bugnote_id=0075598#r7967 |
2015-03-16 15:54 | malsasua | Note Edited: 0075598 | bug_revision_view_page.php?bugnote_id=0075598#r7980 |
2015-03-16 15:54 | malsasua | Review Assigned To | => malsasua |
2015-03-16 15:54 | malsasua | Note Added: 0075629 | |
2015-03-16 15:54 | malsasua | Status | resolved => closed |
2015-03-16 15:54 | malsasua | Fixed in Version | => RR15Q2 |
2015-03-16 17:47 | Orekaria | Relationship added | depends on 0029296 |
2015-03-16 17:49 | Orekaria | Relationship added | depends on 0029290 |
2015-03-19 08:53 | hgbot | Checkin | |
2015-03-19 08:53 | hgbot | Note Added: 0075764 | |
2015-03-19 22:13 | hgbot | Checkin | |
2015-03-19 22:13 | hgbot | Note Added: 0075780 | |
2015-03-19 22:13 | Orekaria | Relationship added | related to 0029351 |
2015-03-20 18:06 | hgbot | Checkin | |
2015-03-20 18:06 | hgbot | Note Added: 0075824 | |
2015-03-20 20:51 | Orekaria | Note Added: 0075836 | |
2015-03-20 20:51 | Orekaria | Status | closed => new |
2015-03-20 20:51 | Orekaria | Resolution | fixed => open |
2015-03-20 20:51 | Orekaria | Fixed in Version | RR15Q2 => |
2015-03-20 20:52 | Orekaria | Note Edited: 0075836 | bug_revision_view_page.php?bugnote_id=0075836#r8055 |
2015-03-20 21:14 | hgbot | Checkin | |
2015-03-20 21:14 | hgbot | Note Added: 0075837 | |
2015-03-20 21:14 | hgbot | Status | new => resolved |
2015-03-20 21:14 | hgbot | Resolution | open => fixed |
2015-03-20 21:14 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/ad49f99476b7425a360d7d2e540d1e314d36e13f [^] => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/7a790ed0e2411e4b0c84b124d7c6a8f2528c1cf2 [^] |
2015-03-20 21:20 | Orekaria | Note Added: 0075838 | |
2015-03-24 20:47 | Orekaria | Relationship added | causes 0029394 |
2015-03-25 17:27 | Orekaria | Relationship added | blocks 0029377 |
2015-03-30 14:15 | malsasua | Note Added: 0076145 | |
2015-03-30 14:15 | malsasua | Status | resolved => closed |
2015-03-30 14:15 | malsasua | Fixed in Version | => RR15Q2 |
2015-03-30 20:13 | marvintm | Relationship added | has duplicate 0028410 |
2015-04-22 15:11 | Orekaria | Relationship added | causes 0029670 |
2016-03-09 09:40 | marvintm | Relationship added | has duplicate 0026157 |
Notes |
|
(0074885)
|
hgbot
|
2015-02-24 20:09
|
|
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: ad49f99476b7425a360d7d2e540d1e314d36e13f
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Feb 24 20:08:53 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/ad49f99476b7425a360d7d2e540d1e314d36e13f [^]
Fixed issue 29055. Greatly improved the way Web POS handles database updates:
- Now a checksum of each models's structure will be computed and stored in the local storage of the browser.
- This checksum will be used to detect changes in the structure of one model. If changes are detected, the table will be dropped and recreated.
- For masterdata models, this will trigger automatically a full refresh, to ensure that all data is correctly loaded.
- For data synchronization models, a security check will be done before recreating the table. If there is still data pending to be synchronized, a synchronization will be triggered. If this synchronization still doesn't work, and data is still pending to be synchronized, then an error will be shown to the user, and the process will be cancelled.
---
M web/org.openbravo.mobile.core/source/data/ob-model.js
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
---
|
|
|
(0074886)
|
hgbot
|
2015-02-24 20:09
|
|
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: d14828ca485ee15f7144c8c2fe4617e749276cf8
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Feb 24 20:05:31 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d14828ca485ee15f7144c8c2fe4617e749276cf8 [^]
Related to issue 29055. Removed unnecessary function, and added special criteria for the cash up model, to ensure that no false positives are detected when looking for changes.
---
M web/org.openbravo.retail.posterminal/js/login/model/login-model.js
---
|
|
|
(0074937)
|
hgbot
|
2015-02-25 19:02
|
|
|
|
(0074966)
|
hgbot
|
2015-02-26 13:44
|
|
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 049a34feae3e9add04ab5e30dc4e44bce610ecc5
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Feb 26 13:44:13 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/049a34feae3e9add04ab5e30dc4e44bce610ecc5 [^]
Related to issue 29055. Moved query to a better place in the code. It now uses cache to ensure it performs well.
---
M web/org.openbravo.retail.posterminal/js/components/menu.js
M web/org.openbravo.retail.posterminal/js/login/model/login-model.js
M web/org.openbravo.retail.posterminal/js/utils/ob-utilitiesuipos.js
---
|
|
|
(0075000)
|
hgbot
|
2015-02-26 20:04
|
|
|
|
(0075148)
|
hgbot
|
2015-03-04 11:46
|
|
|
|
(0075149)
|
hgbot
|
2015-03-04 11:56
|
|
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 93d6d63e7155e0a406c3313ea20d8966107a34c3
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Mar 04 11:56:20 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/93d6d63e7155e0a406c3313ea20d8966107a34c3 [^]
Related to issue 29055. Avoid warnings related to not-yet-created tables in the initial load of the Web POS
---
M web/org.openbravo.mobile.core/source/data/ob-dal.js
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
---
|
|
|
(0075153)
|
hgbot
|
2015-03-04 12:28
|
|
|
|
(0075157)
|
hgbot
|
2015-03-04 13:13
|
|
|
|
(0075164)
|
hgbot
|
2015-03-04 17:35
|
|
|
|
(0075165)
|
hgbot
|
2015-03-04 17:36
|
|
|
|
(0075172)
|
hgbot
|
2015-03-04 18:36
|
|
|
|
(0075195)
|
hgbot
|
2015-03-05 14:25
|
|
|
|
(0075197)
|
hgbot
|
2015-03-05 15:04
|
|
|
|
(0075287)
|
hgbot
|
2015-03-09 00:20
|
|
Repository: tools/automation/pi-mobile
Changeset: 7c7f24150f18fca2a7359e480adb36d7ddf86e28
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Mar 05 20:00:25 2015 +0100
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/7c7f24150f18fca2a7359e480adb36d7ddf86e28 [^]
Related to issue 28933. Verifies issue 29055. Added two automated tests
---
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/loginout/TerminalUpdateTestBasicChange.java
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/loginout/TerminalUpdateTestMasterdataChange.java
---
|
|
|
(0075348)
|
hgbot
|
2015-03-09 19:58
|
|
Repository: tools/automation/pi-mobile
Changeset: f697f7e055ff75838306ab4b972492f5a978a93d
Author: Rafa Alonso <rafael.alonso <at> openbravo.com>
Date: Mon Mar 09 09:43:13 2015 +0100
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/f697f7e055ff75838306ab4b972492f5a978a93d [^]
Related to issue 28933. Verifies issue 29055: Added 2 more tests
---
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/loginout/I29055_TerminalChange.java
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/loginout/I29055_TerminalChangeWithLogin.java
---
|
|
|
(0075575)
|
hgbot
|
2015-03-13 15:55
|
|
|
|
(0075592)
|
hgbot
|
2015-03-14 06:08
|
|
|
|
(0075593)
|
hgbot
|
2015-03-14 06:09
|
|
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 989037b6f0a7f146d58250835c92cf2b52d1eeb6
Author: Rafa Alonso <rafael.alonso <at> openbravo.com>
Date: Sat Mar 14 02:08:19 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/989037b6f0a7f146d58250835c92cf2b52d1eeb6 [^]
Related to issue 29055: Added different drop messages...
The drop message is different if the model is about to be dropped because it should not exists (the localStorage does not have a checksum of the model) or because it is really obsolete
---
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
---
|
|
|
(0075594)
|
hgbot
|
2015-03-14 06:09
|
|
|
|
(0075597)
|
hgbot
|
2015-03-14 06:09
|
|
|
|
(0075598)
|
Orekaria
|
2015-03-14 06:18
(edited on: 2015-03-16 15:54) |
|
|
|
|
|
|
(0075764)
|
hgbot
|
2015-03-19 08:53
|
|
|
|
(0075780)
|
hgbot
|
2015-03-19 22:13
|
|
|
|
(0075824)
|
hgbot
|
2015-03-20 18:06
|
|
|
|
(0075836)
|
Orekaria
|
2015-03-20 20:51
(edited on: 2015-03-20 20:52) |
|
|
|
(0075837)
|
hgbot
|
2015-03-20 21:14
|
|
|
|
|
Please consider testing offline when closing |
|
|
|
|