Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0056549 | Retail Modules | Multi UPC/EAN for Product | public | 2024-09-25 12:30 | 2024-10-18 13:04 |
|
| Reporter | malsasua | |
| Assigned To | SABARINATH P | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | 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 | 0056549: after incremental refresh process, the first scan is slow |
| Description | With big volume of data (40K products), after incremental refresh process is executed, the first scan is slow:
https://drive.google.com/file/d/1HtPo4wiPDht52Dt3tueyMlRRlQwKminp/view?usp=sharing [^]
This issue is caused because a search is triggered by the MultiUpc module, but the database is busy "Loading cache for Model." Until the database completes the cache loading process, the MultiUpc query is not executed.
The query is executed in this line:
https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/blob/master/web/org.openbravo.retail.multiupc/js/extendUPCSearch.js?ref_type=heads#L71 [^]
|
| Steps To Reproduce | . in environment with 40K products, install multiupc module
. execute incremental refresh
. scan a product
|
| Proposed Solution | . if the database is executing the cache loading process, then execute the product search as remote |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2024-09-25 12:30 | malsasua | New Issue | |
| 2024-09-25 12:30 | malsasua | Assigned To | => Retail |
| 2024-09-25 12:30 | malsasua | Triggers an Emergency Pack | => No |
| 2024-09-25 12:44 | Practics | Issue Monitored: Practics | |
| 2024-09-27 10:59 | guillermogil | Status | new => acknowledged |
| 2024-10-01 07:29 | SABARINATH P | Assigned To | Retail => SABARINATH P |
| 2024-10-01 07:29 | SABARINATH P | Status | acknowledged => scheduled |
| 2024-10-18 09:02 | hgbot | Note Added: 0170558 | |
| 2024-10-18 13:04 | hgbot | Note Added: 0170567 | |
| 2024-10-18 13:04 | hgbot | Resolution | open => fixed |
| 2024-10-18 13:04 | hgbot | Status | scheduled => closed |
| 2024-10-18 13:04 | hgbot | Note Added: 0170568 | |