Openbravo Issue Tracking System - Retail Modules
View Issue Details
0033536Retail ModulesWeb POSpublic2016-07-21 11:202016-11-07 12:28
marvintm 
ranjith_qualiantech_com 
normalmajorsometimes
closedfixed 
5
 
RR16Q3 
marvintm
No
0033536: Masterdata loading fails when pagination happens
The Web POS loads masterdata models using pagination, which means that if there are many records (currently, more than 35000) in a given model, the first 35000 will be loaded, and then the next 35000, and so on, until all of them are loaded.

Currently, this mechanism is failing in some cases, so that if there are more than 35000 records in a model, some of them are not loaded in the Web POS.
There are two ways to reproduce the problem:

- Find a database with many records (more than 35000 in one model). Log in the Web POS, and verify that not all records are in the local database.

An easier way (and advisable for the developer who will be fixing the problem) is the following:
- Log in the Web POS, go to Chrome Developer Tools, and execute the query in the local database:
select count(*) from m_product
Verify that there are 164 records in the table.
- Then, go to file ob-datasource.js.
- Find this line:
handleIncrementalRequest(35000, 0, params, incremental);
and change it to:
handleIncrementalRequest(20, 0, params, incremental);
- Clear cache and log in the Web POS again.
- Execute the same query in the local database. Verify that there are 162 products. There were two products lost at some point, and this is wrong.
No tags attached.
blocks defect 0033519 closed ranjith_qualiantech_com Masterdata loading fails when pagination is used 
causes backport 0034408RR16Q3.3 closed ranjith_qualiantech_com [RR16Q3] It is not possible to load on WebPOS if you have more than 35000 products 
Issue History
2016-07-26 09:30marvintmTypedefect => backport
2016-07-26 09:30marvintmTarget Version => RR16Q3
2016-07-26 13:54hgbotCheckin
2016-07-26 13:54hgbotNote Added: 0088671
2016-07-26 13:54hgbotStatusscheduled => resolved
2016-07-26 13:54hgbotResolutionopen => fixed
2016-07-26 13:54hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR16Q3/org.openbravo.mobile.core/rev/701f8f37413c72c9d87ef4b004524df7b1ab4c25 [^]
2016-08-04 11:59marvintmReview Assigned To => marvintm
2016-08-04 11:59marvintmStatusresolved => closed
2016-11-07 10:54guillermogilRelationship addedcauses 0034408
2016-11-07 12:28hgbotCheckin
2016-11-07 12:28hgbotNote Added: 0091197

Notes
(0088671)
hgbot   
2016-07-26 13:54   
Repository: retail/backports/3.0RR16Q3/org.openbravo.mobile.core
Changeset: 701f8f37413c72c9d87ef4b004524df7b1ab4c25
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Jul 26 17:23:26 2016 +0530
URL: http://code.openbravo.com/retail/backports/3.0RR16Q3/org.openbravo.mobile.core/rev/701f8f37413c72c9d87ef4b004524df7b1ab4c25 [^]

Fixes issue 33536 : Reset hqlquery offset if the model has multiple queries

- for a model which has multiple queries, hqlquery offset value has to be resetted if last query counted rows doesn't exceed the limit rows

---
M src/org/openbravo/mobile/core/process/ProcessHQLQuery.java
---
(0091197)
hgbot   
2016-11-07 12:28   
Repository: retail/backports/3.0RR16Q3.3/org.openbravo.mobile.core
Changeset: 7da8fb59bf9f44607f56b41bd415cce4dc617a71
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Mon Nov 07 15:38:46 2016 +0530
URL: http://code.openbravo.com/retail/backports/3.0RR16Q3.3/org.openbravo.mobile.core/rev/7da8fb59bf9f44607f56b41bd415cce4dc617a71 [^]

Fixes issue 34408 : Removed Unnessary code in ProcessHQLQuery

- Line should be removed in the issue 33536, but its not
- Removed line is unnecessary and it has to be removed in the changeset 701f8f37413c, but its not

---
M src/org/openbravo/mobile/core/process/ProcessHQLQuery.java
---