Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047475Retail ModulesWeb POSpublic2021-07-30 08:582021-08-03 11:10
Reportermalsasua 
Assigned Toprakashmurugesan88 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0047475: In 21Q2, some promotions are not applied when a lot of promotions are configured
Description. environment with a lot of promotions (more than 50K lines in m_offer_product table)
. with 56698 records actives in m_offer_product, the promotion is applied
. with 56699 products actives in m_offer_product, the promotion is not applied
Steps To Reproduce. environment with more than 50k lines in m_offer_product
. it happens randomly
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0045522 closed prakashmurugesan88 10.000 hardcoded limitation on records evaluated by the Promo Engine 
Attached Filespng DiscountCacheBackoffice.png (132,749) 2021-08-02 14:24
https://issues.openbravo.com/file_download.php?file_id=16058&type=bug
png

png DiscountCacheTerminal.png (151,839) 2021-08-02 14:24
https://issues.openbravo.com/file_download.php?file_id=16059&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2021-07-30 08:58malsasuaNew Issue
2021-07-30 08:58malsasuaAssigned To => Retail
2021-07-30 08:58malsasuaResolution time => 1628028000
2021-07-30 08:58malsasuaTriggers an Emergency Pack => No
2021-07-30 09:40adrianromeroStatusnew => acknowledged
2021-07-30 09:41PracticsIssue Monitored: Practics
2021-07-30 11:17adrianromeroAssigned ToRetail => pradeepvarma
2021-07-30 11:18adrianromeroAssigned Topradeepvarma => prakashmurugesan88
2021-07-30 11:18adrianromeroStatusacknowledged => scheduled
2021-08-02 14:24prakashmurugesan88Note Added: 0130932
2021-08-02 14:24prakashmurugesan88File Added: DiscountCacheBackoffice.png
2021-08-02 14:24prakashmurugesan88File Added: DiscountCacheTerminal.png
2021-08-02 14:41adrianromeroReview Assigned To => adrianromero
2021-08-02 14:41adrianromeroStatusscheduled => closed
2021-08-02 14:41adrianromeroResolutionopen => no change required
2021-08-03 11:10adrianromeroRelationship addedrelated to 0045522

Notes
(0130932)
prakashmurugesan88   
2021-08-02 14:24   
DiscountsProductFilter are not loaded to the rule because corresponding product's entry is missed due to limit
https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/blob/master/web/org.openbravo.retail.discounts/app/model/business-logic/discounts-engine/interface/discount-posinterface.js#L503 [^]

https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/blob/master/web/org.openbravo.retail.discounts/app/model/business-logic/discounts-engine/interface/discount-posinterface.js#L406 [^]

This can be fixed by setting the preference 'Discounts cache size' in Backoffice.

Please refer attached images,
DiscountCacheBackoffice and DiscountCacheTerminal