Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0050860 | Retail Modules | Web POS | public | 2022-11-11 13:00 | 2022-12-01 07:22 |
|
| Reporter | ngarcia | |
| Assigned To | ranjith_qualiantech_com | |
| Priority | urgent | Severity | major | Reproducibility | random |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | RR23Q1 | |
| Merge Request Status | approved |
| Review Assigned To | |
| OBNetwork customer | Gold |
| Support ticket | 52430 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0050860: Query for retrieving the Discount Filter Characteristics take too long |
| Description | Query for retrieving the Discount Filter Characteristics take too long.
Error retrieving data for model DiscountFilterCharacteristic: Error: Failed to fetch; stackTrace: errorCallback (...);
MasterdataController.refreshMasterdata (...);
async MasterdataController.fullMasterdataRefresh (...) |
| Steps To Reproduce | In the customer instance, doing a full refresh, it finished with an error. Attached the query and its EXPLAIN ANALYZE |
| Proposed Solution | |
| Additional Information | |
| Tags | NOR |
| Relationships | | related to | defect | 0036175 | | closed | ebecerra | Perforamnce problems loading the master data for discounts. |
|
| Attached Files |  ExplainAnalyzeFilterChar (11,029) 2022-11-11 13:00
https://issues.openbravo.com/file_download.php?file_id=17811&type=bug
 queryFilterChar.txt (4,906) 2022-11-11 13:01
https://issues.openbravo.com/file_download.php?file_id=17812&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2022-11-11 13:00 | ngarcia | New Issue | |
| 2022-11-11 13:00 | ngarcia | Assigned To | => Retail |
| 2022-11-11 13:00 | ngarcia | File Added: ExplainAnalyzeFilterChar | |
| 2022-11-11 13:00 | ngarcia | OBNetwork customer | => No |
| 2022-11-11 13:00 | ngarcia | Support ticket | => 52430 |
| 2022-11-11 13:00 | ngarcia | Triggers an Emergency Pack | => No |
| 2022-11-11 13:01 | ngarcia | File Added: queryFilterChar.txt | |
| 2022-11-11 13:02 | ngarcia | OBNetwork customer | No => Gold |
| 2022-11-11 13:08 | ngarcia | Relationship added | related to 0036175 |
| 2022-11-23 11:49 | ranjith_qualiantech_com | Assigned To | Retail => ranjith_qualiantech_com |
| 2022-11-23 11:50 | ranjith_qualiantech_com | Status | new => scheduled |
| 2022-11-24 15:18 | sebastien_liron | Note Added: 0144109 | |
| 2022-11-24 15:19 | sebastien_liron | Issue Monitored: egoitz | |
| 2022-11-24 15:20 | sebastien_liron | Note Added: 0144110 | |
| 2022-11-24 15:20 | sebastien_liron | Tag Attached: NOR | |
| 2022-11-25 06:55 | hgbot | Merge Request Status | => open |
| 2022-11-25 06:55 | hgbot | Note Added: 0144133 | |
| 2022-11-30 12:26 | hgbot | Note Added: 0144245 | |
| 2022-11-30 13:35 | hgbot | Note Added: 0144251 | |
| 2022-12-01 07:21 | hgbot | Merge Request Status | open => approved |
| 2022-12-01 07:22 | hgbot | Note Added: 0144284 | |
| 2022-12-01 07:22 | hgbot | Resolution | open => fixed |
| 2022-12-01 07:22 | hgbot | Status | scheduled => closed |
| 2022-12-01 07:22 | hgbot | Fixed in Version | => RR23Q1 |
| 2022-12-01 07:22 | hgbot | Note Added: 0144285 | |
|
Notes |
|
|
(0144109)
|
|
sebastien_liron
|
|
2022-11-24 15:18
|
|
|
egoitz has done some analysis already and a temp fix is available |
|
|
|
(0144110)
|
|
sebastien_liron
|
|
2022-11-24 15:20
|
|
|
we change the date, as the subject has created a critical issue in a client prod today |
|
|
|
(0144133)
|
|
hgbot
|
|
2022-11-25 06:55
|
|
|
|
|
(0144245)
|
|
hgbot
|
|
2022-11-30 12:26
|
|
|
|
|
(0144251)
|
|
hgbot
|
|
2022-11-30 13:35
|
|
|
|
|
(0144284)
|
|
hgbot
|
|
2022-12-01 07:22
|
|
|
|
|
(0144285)
|
|
hgbot
|
|
2022-12-01 07:22
|
|
|