Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047510Retail ModulesWeb POSpublic2021-08-05 17:482021-10-27 11:03
Reportermalsasua 
Assigned Toranjith_qualiantech_com 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR21Q4 
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
Summary0047510: 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
TagsNOR
Relationships
related to defect 0047468 closed ranjith_qualiantech_com in 21Q2, performance problem executing full refresh 
depends on backport 0047576RR21Q3.1 closed ranjith_qualiantech_com in 21Q2, incremental refresh process is slower in 21Q2 than previous releases 
depends on backport 0047577RR21Q2.2 closed ranjith_qualiantech_com in 21Q2, incremental refresh process is slower in 21Q2 than previous releases 
related to defect 0047423 closed ranjith_qualiantech_com Slow incremental refresh of products 
causes defect 0047622 closed ranjith_qualiantech_com incremental refresh removes rows instead of updating them for models without "active" field 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-08-05 17:48malsasuaNew Issue
2021-08-05 17:48malsasuaAssigned To => Retail
2021-08-05 17:48malsasuaOBNetwork customer => OBPS
2021-08-05 17:48malsasuaSupport ticket => 26373
2021-08-05 17:48malsasuaResolution time => 1628719200
2021-08-05 17:48malsasuaTriggers an Emergency Pack => No
2021-08-05 18:26PracticsIssue Monitored: Practics
2021-08-05 18:35adrianromeroRelationship addedrelated to 0047468
2021-08-06 11:28adrianromeroStatusnew => acknowledged
2021-08-06 12:20adrianromeroRelationship addedrelated to 0047433
2021-08-06 12:25adrianromeroRelationship deletedrelated to 0047433
2021-08-06 12:25adrianromeroRelationship addedrelated to 0047423
2021-08-09 13:29hgbotMerge Request Status => open
2021-08-09 13:29hgbotNote Added: 0131039
2021-08-17 12:18hgbotNote Added: 0131155
2021-08-20 07:40ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2021-08-20 07:41ranjith_qualiantech_comStatusacknowledged => scheduled
2021-08-20 13:15marvintmStatusscheduled => acknowledged
2021-08-20 13:15marvintmStatusacknowledged => scheduled
2021-08-23 08:40hgbotMerge Request Statusopen => approved
2021-08-23 08:40hgbotResolutionopen => fixed
2021-08-23 08:40hgbotStatusscheduled => closed
2021-08-23 08:40hgbotNote Added: 0131245
2021-08-23 08:40hgbotFixed in Version => RR21Q4
2021-08-23 08:40hgbotNote Added: 0131246
2021-08-23 08:40hgbotNote Added: 0131247
2021-08-23 08:40hgbotNote Added: 0131248
2021-08-23 08:40hgbotNote Added: 0131249
2021-08-23 08:40hgbotNote Added: 0131250
2021-09-02 14:26alostaleRelationship addedcauses 0047622
2021-10-27 11:03rafarodaTag Attached: NOR

Notes
(0131039)
hgbot   
2021-08-09 13:29   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/268 [^]
(0131155)
hgbot   
2021-08-17 12:18   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.loyalty.programs/-/merge_requests/18 [^]
(0131245)
hgbot   
2021-08-23 08:40   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/268 [^]
(0131246)
hgbot   
2021-08-23 08:40   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core [^]
Changeset: c7fc5ebdf8554bab23c5dbd5aa396fbb561ed5e7
Author: Adrián Romero <adrian.romero@openbravo.com>
Date: 2021-08-23T05:26:48+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/c7fc5ebdf8554bab23c5dbd5aa396fbb561ed5e7 [^]

Fixes ISSUE-0047510: in 21Q2, incremental refresh process is slower in 21Q2 than previous releases
* Executes all records updates in a single IndexedDB model in one transaction instead using one transaction for each record.

---
M web/org.openbravo.mobile.core/app/model/masterdata/MasterdataController.js
M web/org.openbravo.mobile.core/app/model/persistence/indexeddb/IndexedDBController.js
---
(0131247)
hgbot   
2021-08-23 08:40   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core [^]
Changeset: c517f0bbdc7f60098384b8cd06c4a8358d70894b
Author: Adrián Romero <adrian.romero@openbravo.com>
Date: 2021-08-23T05:26:48+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/c517f0bbdc7f60098384b8cd06c4a8358d70894b [^]

Related to ISSUE-0047510: in 21Q2, incremental refresh process is slower in 21Q2 than previous releases
* Use writeBatch in putIncrementalMasterdata() and create new function updateMasterData()

---
M web/org.openbravo.mobile.core/app/model/masterdata/MasterdataController.js
---
(0131248)
hgbot   
2021-08-23 08:40   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core [^]
Changeset: c8d2a3c16aeb053f7b69e5bbe687a590f6c5d5aa
Author: Adrián Romero <adrian.romero@openbravo.com>
Date: 2021-08-23T05:26:48+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/c8d2a3c16aeb053f7b69e5bbe687a590f6c5d5aa [^]

Related to ISSUE-0047510: in 21Q2, incremental refresh process is slower in 21Q2 than previous releases
* Move cache update to the end of the IndexedDB transaction

---
M web/org.openbravo.mobile.core/app/model/masterdata/MasterdataController.js
---
(0131249)
hgbot   
2021-08-23 08:40   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.loyalty.programs [^]
Changeset: 089626066418801204cd9e57ca70d563996e1bd6
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 2021-08-17T12:37:27+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.loyalty.programs/-/commit/089626066418801204cd9e57ca70d563996e1bd6 [^]

Related to ISSUE-47510: Renamed isactive property with active property

---
M src/org/openbravo/retail/loyalty/programs/master/LoyaltySubscriptionsProperties.java
M src/org/openbravo/retail/loyalty/programs/process/GetSubscriptionInformationPollingHandler.java
M src/org/openbravo/retail/loyalty/programs/term/LoyaltyProgramProperties.java
M web/org.openbravo.retail.loyalty.programs/app/model/masterdata/LoyaltySubscriptionsModel.js
M web/org.openbravo.retail.loyalty.programs/js/component/program-selection-popup.js
M web/org.openbravo.retail.loyalty.programs/js/component/subscription-icon.js
M web/org.openbravo.retail.loyalty.programs/js/hooks/obrlp_postBarcodeAction.js
M web/org.openbravo.retail.loyalty.programs/js/model/loyaltysubscriptions.js
M web/org.openbravo.retail.loyalty.programs/js/utils/obrlputils.js
M web/org.openbravo.retail.loyalty.programs/js/view/addpoints-popup.js
M web/org.openbravo.retail.loyalty.programs/js/view/customeredit-fields.js
M web/org.openbravo.retail.loyalty.programs/js/view/manageLoyalty.js
M web/org.openbravo.retail.loyalty.programs/js/view/subscription-create-form.js
---
(0131250)
hgbot   
2021-08-23 08:40   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.loyalty.programs/-/merge_requests/18 [^]