Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0054996 | Retail Modules | Web POS | public | 2024-03-19 19:00 | 2024-03-19 19:01 |
| Reporter | nicola_uva | ||||
| Assigned To | Retail | ||||
| Priority | high | Severity | major | Reproducibility | sometimes |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| Target Version | pi | Fixed in Version | |||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0054996: DiscountFilterProduct process: the query is very slow when there are a lot of data to be retrievied | ||||
| Description | During the login the process to retrieve the PricingAdjustmentProduct is failing in case there are a lot of data to be retrieved. | ||||
| Steps To Reproduce | 1. configure in the backoffice a promo with a lot of products 2. login in pos (vbs-2) 3. DiscountFilterProduct process will fail with QueryTimeoutException error (see log in attached) | ||||
| Proposed Solution | Note: for another customer was implemented a change in this filter, so that it didn't filter by the assortment/pricelist/ Futhermore, make sense these filters configurable like we have in other cases like the Product masterdata query. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files |  discountProduct.log (3,896) 2024-03-19 19:00https://issues.openbravo.com/file_download.php?file_id=19565&type=bug | ||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2024-03-19 19:00 | nicola_uva | New Issue | |||
| 2024-03-19 19:00 | nicola_uva | Assigned To | => Retail | ||
| 2024-03-19 19:00 | nicola_uva | File Added: discountProduct.log | |||
| 2024-03-19 19:00 | nicola_uva | Triggers an Emergency Pack | => No | ||
| 2024-03-19 19:01 | nicola_uva | Proposed Solution updated | |||
| There are no notes attached to this issue. |