Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0057873 | Openbravo ERP | I. Performance | public | 2025-02-05 13:18 | 2025-03-29 08:07 |
| Reporter | sofidossant | ||||
| Assigned To | AugustoMauch | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | duplicate | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | PR20Q3.4 | ||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | Gold | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | 110115 | ||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0057873: Performance error with Assortment | ||||
| Description | We got the error: The query took longer than expected and has been canceled. Please enter a more restrictive criteria to try to make the query faster When we want to filter the tab “Product” in the Assortment. It is by the amount of products that the assortment has loaded but cannot filter the product. Part of the problem is the number of read organizations that this role has access to. With fewer organizations (e.g. 5), an index is used. But for example, at 10 or more, no index is used. Then adding the index is most likely useless, because it seems that there is already another one that can be used in other conditions. | ||||
| Steps To Reproduce | 1 - The error is reproduced if we have many organizations and the role we use has access to them. 2 - Search for a product in an assortment relationship with an organization that is a parent of many organizations. | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2025-02-05 13:18 | sofidossant | New Issue | |||
| 2025-02-05 13:18 | sofidossant | Assigned To | => Triage Platform Base | ||
| 2025-02-05 13:18 | sofidossant | OBNetwork customer | => Gold | ||
| 2025-02-05 13:18 | sofidossant | Modules | => Core | ||
| 2025-02-05 13:18 | sofidossant | Support ticket | => 110115 | ||
| 2025-02-05 13:18 | sofidossant | Triggers an Emergency Pack | => No | ||
| 2025-02-21 10:03 | AugustoMauch | Assigned To | Triage Platform Base => AugustoMauch | ||
| 2025-02-21 10:03 | AugustoMauch | Status | new => acknowledged | ||
| 2025-03-29 08:07 | AugustoMauch | Status | acknowledged => scheduled | ||
| 2025-03-29 08:07 | AugustoMauch | Note Added: 0177697 | |||
| 2025-03-29 08:07 | AugustoMauch | Status | scheduled => closed | ||
| 2025-03-29 08:07 | AugustoMauch | Resolution | open => duplicate | ||
| Notes | |||||
|
|
|||||
|
|
||||