Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0055118 | Openbravo ERP | I. Performance | public | 2024-04-08 10:41 | 2024-04-24 09:27 |
|
| Reporter | malsasua | |
| Assigned To | aferraz | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | PR24Q3 | |
| Merge Request Status | approved |
| Review Assigned To | |
| OBNetwork customer | Gold |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0055118: Index by c_order.Cancelledorder_id is missing |
| Description | in big environments, the search by the column c_order.cancelledorder_id is very slow.
Index is missing for this column |
| Steps To Reproduce | n/a |
| Proposed Solution | create index:
<index name="EM_CCFLDS_ORDER_CANCELLEDORDER" unique="false">
<index-column name="CANCELLEDORDER_ID"/>
</index>
|
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2024-04-08 10:41 | malsasua | New Issue | |
| 2024-04-08 10:41 | malsasua | Assigned To | => Triage Platform Base |
| 2024-04-08 10:41 | malsasua | OBNetwork customer | => Gold |
| 2024-04-08 10:41 | malsasua | Modules | => Core |
| 2024-04-08 10:41 | malsasua | Triggers an Emergency Pack | => No |
| 2024-04-22 07:44 | alostale | Assigned To | Triage Platform Base => Triage Omni OMS |
| 2024-04-22 14:42 | aferraz | Note Added: 0163533 | |
| 2024-04-22 14:42 | aferraz | Status | new => feedback |
| 2024-04-22 14:42 | aferraz | Assigned To | Triage Omni OMS => malsasua |
| 2024-04-22 17:48 | aferraz | Assigned To | malsasua => Triage Omni OMS |
| 2024-04-22 17:48 | aferraz | Status | feedback => new |
| 2024-04-23 14:07 | hgbot | Merge Request Status | => open |
| 2024-04-23 14:07 | hgbot | Note Added: 0163606 | |
| 2024-04-23 14:07 | aferraz | Assigned To | Triage Omni OMS => aferraz |
| 2024-04-23 22:06 | hgbot | Merge Request Status | open => approved |
| 2024-04-24 09:27 | hgbot | Resolution | open => fixed |
| 2024-04-24 09:27 | hgbot | Status | new => closed |
| 2024-04-24 09:27 | hgbot | Fixed in Version | => PR24Q3 |
| 2024-04-24 09:27 | hgbot | Note Added: 0163640 | |
| 2024-04-24 09:27 | hgbot | Note Added: 0163641 | |