Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047577Retail ModulesWeb POSpublic2021-08-05 17:482021-08-24 07:29
Reportermalsasua 
Assigned Toranjith_qualiantech_com 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR21Q2.2Fixed in VersionRR21Q2.2 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerOBPS
Support ticket26373
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0047577: in 21Q2, incremental refresh process is slower in 21Q2 than previous releases
DescriptionIn 21Q2, the incremental refresh process is slower than previous releases
Steps To Reproducesame data
. in 19Q3:
- [BO] update 7000 products
- [POS] execute incremental refresh process:
Product model takes less than 3 segs (see internal note- video1)

. in 21Q2:
- [BO] update 7000 products
- [POS] execute incremental refresh process:
Product model takes less than 150 segs (see internal note- video2)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0047510 closed ranjith_qualiantech_com in 21Q2, incremental refresh process is slower in 21Q2 than previous releases 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-08-20 13:15marvintmTypedefect => backport
2021-08-20 13:15marvintmTarget Version => RR21Q2.2
2021-08-23 12:05hgbotNote Added: 0131263
2021-08-24 07:29hgbotMerge Request Statusopen => approved
2021-08-24 07:29hgbotResolutionopen => fixed
2021-08-24 07:29hgbotStatusscheduled => closed
2021-08-24 07:29hgbotFixed in Version => RR21Q2.2
2021-08-24 07:29hgbotNote Added: 0131275
2021-08-24 07:29hgbotNote Added: 0131276

Notes
(0131263)
hgbot   
2021-08-23 12:05   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/276 [^]
(0131275)
hgbot   
2021-08-24 07:29   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core [^]
Changeset: 2a54bc81a5798b6df14903ca2ba6e812cfba8ef9
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 2021-08-23T14:38:59+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/2a54bc81a5798b6df14903ca2ba6e812cfba8ef9 [^]

Fixed ISSUE-47577: Updated incremental refresh batch update process
* Executes all records updates in a single IndexedDB model in one transaction instead using one transaction for each record.
* Use writeBatch in putIncrementalMasterdata() and create new function updateMasterData()
* Move cache update to the end of the IndexedDB transaction

---
M web/org.openbravo.mobile.core/app/model/masterdata/MasterdataController.js
M web/org.openbravo.mobile.core/app/model/persistence/indexeddb/IndexedDBController.js
---
(0131276)
hgbot   
2021-08-24 07:29   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/276 [^]