Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033519
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorsometimes2016-07-21 11:202016-12-16 13:41
ReportermarvintmView Statuspublic 
Assigned Toranjith_qualiantech_com 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionc8dfc96d4a92
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression levelProduction - Confirmed Stable
Regression date2015-04-30
Regression introduced in releaseRR15Q2
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/a950157be0006f2e3f023f64d8ab1e9a9b2bb99a [^]
Triggers an Emergency PackNo
Summary

0033519: Masterdata loading fails when pagination is used

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, for example products or business partners). 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0033524RR16Q2.2 closedranjith_qualiantech_com Masterdata loading fails when pagination happens 
depends on backport 0033536RR16Q3 closedranjith_qualiantech_com Masterdata loading fails when pagination happens 
caused by defect 0028428RR15Q3 closedaaroncalero Improve master data loading of WebPOS 
causes defect 0034669RR17Q1 closedmigueldejuana ProcessHQLQuery returns duplicates causing errors when inserting data and really slow login with many products 

-  Notes
(0088663)
hgbot (developer)
2016-07-26 11:27

 Repository: erp/pmods/org.openbravo.mobile.core
Changeset: c8dfc96d4a92aad6486c6241410effa49a14d6a8
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Jul 26 14:57:12 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/c8dfc96d4a92aad6486c6241410effa49a14d6a8 [^]

Fixes issue 33519 : 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
---
(0092495)
hgbot (developer)
2016-12-16 13:41

 Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 6151c54f767b65b8c90ea1cdc324a15a40f27055
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Thu Dec 15 13:55:25 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/6151c54f767b65b8c90ea1cdc324a15a40f27055 [^]

Related to issue 0033519 and related to issue 0034669

Backed out changeset c8dfc96d4a92

- This changeset is not needed, offset is not needed to update in non-masterdata queries. In fact it breaks recalculation of limit using totalRows instead of queryRows

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

- Issue History
Date Modified Username Field Change
2016-07-21 11:20 marvintm New Issue
2016-07-21 11:20 marvintm Assigned To => Retail
2016-07-21 11:20 marvintm Triggers an Emergency Pack => No
2016-07-21 11:21 marvintm Status new => acknowledged
2016-07-21 12:38 Orekaria Status acknowledged => scheduled
2016-07-21 12:38 Orekaria Status scheduled => acknowledged
2016-07-25 11:11 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2016-07-25 11:12 ranjith_qualiantech_com Status acknowledged => scheduled
2016-07-26 09:30 marvintm Status scheduled => acknowledged
2016-07-26 09:30 marvintm Status acknowledged => scheduled
2016-07-26 11:27 hgbot Checkin
2016-07-26 11:27 hgbot Note Added: 0088663
2016-07-26 11:27 hgbot Status scheduled => resolved
2016-07-26 11:27 hgbot Resolution open => fixed
2016-07-26 11:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/c8dfc96d4a92aad6486c6241410effa49a14d6a8 [^]
2016-07-26 11:58 marvintm Summary Masterdata loading fails when pagination happens => Masterdata loading fails when pagination is used
2016-07-26 11:58 marvintm Steps to Reproduce Updated View Revisions
2016-07-26 12:01 marvintm Regression level => Production - Confirmed Stable
2016-07-26 12:01 marvintm Regression date => 2015-04-30
2016-07-26 12:01 marvintm Regression introduced in release => RR15Q2
2016-07-26 12:01 marvintm Regression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/a950157be0006f2e3f023f64d8ab1e9a9b2bb99a [^]
2016-07-26 12:18 dmitry_mezentsev Relationship added caused by 0028428
2016-08-04 11:59 marvintm Review Assigned To => marvintm
2016-08-04 11:59 marvintm Status resolved => closed
2016-12-01 16:38 mtaal Relationship added causes 0034669
2016-12-16 13:41 hgbot Checkin
2016-12-16 13:41 hgbot Note Added: 0092495

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker