Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033524Retail ModulesWeb POSpublic2016-07-21 11:202016-08-04 12:00
Reportermarvintm 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR16Q2.2Fixed 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
Summary0033524: Masterdata loading fails when pagination happens
DescriptionThe 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.
Steps To ReproduceThere 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0033519 closed ranjith_qualiantech_com Masterdata loading fails when pagination is used 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-07-21 12:38OrekariaTypedefect => backport
2016-07-21 12:38OrekariaTarget Version => RR16Q2.2
2016-07-26 11:54ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2016-07-26 13:01hgbotCheckin
2016-07-26 13:01hgbotNote Added: 0088666
2016-07-26 13:01hgbotStatusscheduled => resolved
2016-07-26 13:01hgbotResolutionopen => fixed
2016-07-26 13:01hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR16Q2.2/org.openbravo.mobile.core/rev/990ac1cac5e0b5bf33b4454ff68b709409aa94e5 [^]
2016-08-04 12:00marvintmReview Assigned To => marvintm
2016-08-04 12:00marvintmStatusresolved => closed

Notes
(0088666)
hgbot   
2016-07-26 13:01   
Repository: retail/backports/3.0RR16Q2.2/org.openbravo.mobile.core
Changeset: 990ac1cac5e0b5bf33b4454ff68b709409aa94e5
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Jul 26 16:27:23 2016 +0530
URL: http://code.openbravo.com/retail/backports/3.0RR16Q2.2/org.openbravo.mobile.core/rev/990ac1cac5e0b5bf33b4454ff68b709409aa94e5 [^]

Fixes issue 33524 : 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
---