Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0055118Openbravo ERPI. Performancepublic2024-04-08 10:412024-04-24 09:27
Reportermalsasua 
Assigned Toaferraz 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR24Q3 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0055118: Index by c_order.Cancelledorder_id is missing
Descriptionin big environments, the search by the column c_order.cancelledorder_id is very slow.

Index is missing for this column
Steps To Reproducen/a
Proposed Solutioncreate index:
      <index name="EM_CCFLDS_ORDER_CANCELLEDORDER" unique="false">
        <index-column name="CANCELLEDORDER_ID"/>
      </index>
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2024-04-08 10:41malsasuaNew Issue
2024-04-08 10:41malsasuaAssigned To => Triage Platform Base
2024-04-08 10:41malsasuaModules => Core
2024-04-08 10:41malsasuaTriggers an Emergency Pack => No
2024-04-22 07:44alostaleAssigned ToTriage Platform Base => Triage Omni OMS
2024-04-22 14:42aferrazNote Added: 0163533
2024-04-22 14:42aferrazStatusnew => feedback
2024-04-22 14:42aferrazAssigned ToTriage Omni OMS => malsasua
2024-04-22 17:48aferrazAssigned Tomalsasua => Triage Omni OMS
2024-04-22 17:48aferrazStatusfeedback => new
2024-04-23 14:07hgbotNote Added: 0163606
2024-04-23 14:07aferrazAssigned ToTriage Omni OMS => aferraz
2024-04-24 09:27hgbotResolutionopen => fixed
2024-04-24 09:27hgbotStatusnew => closed
2024-04-24 09:27hgbotFixed in Version => PR24Q3
2024-04-24 09:27hgbotNote Added: 0163640
2024-04-24 09:27hgbotNote Added: 0163641

Notes
(0163533)
aferraz   
2024-04-22 14:42   
You should provide the query that needs this index and indicate where it is executed from.
(0163606)
hgbot   
2024-04-23 14:07   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1212 [^]
(0163640)
hgbot   
2024-04-24 09:27   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: e28ff24d6acb192b528dc42e5146aca9b397daa4
Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com>
Date: 24-04-2024 07:27:16
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/e28ff24d6acb192b528dc42e5146aca9b397daa4 [^]

Fixes ISSUE-55118: Add index in C_ORDER.CANCELLEDORDER_ID column

---
M src-db/database/model/tables/C_ORDER.xml
---
(0163641)
hgbot   
2024-04-24 09:27   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1212 [^]