Openbravo Issue Tracking System - Openbravo ERP | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0052072 | Openbravo ERP | A. Platform | public | 2023-04-05 14:40 | 2023-06-13 17:32 |
Reporter | malsasua | ||||
Assigned To | AugustoMauch | ||||
Priority | high | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | OS | 5 | OS Version | ||
Product Version | |||||
Target Version | Fixed in Version | PR23Q3 | |||
Merge Request Status | |||||
Review Assigned To | |||||
OBNetwork customer | |||||
Web browser | |||||
Modules | Core | ||||
Support ticket | |||||
Regression level | |||||
Regression date | |||||
Regression introduced in release | |||||
Regression introduced by commit | |||||
Triggers an Emergency Pack | No | ||||
Summary | 0052072: Heavy query is executed in Sales Order window | ||||
Description | when the access is done to one record in the Sales Order window, if the record contains one id in the column cancelledorder_id but does not exist a c_order with this ID, it is executed this query: SELECT td0.C_Order_ID AS ID, COALESCE(TO_CHAR(COALESCE(TO_CHAR(td0.DocumentNo),'')),'')) AS NAME, '' AS DESCRIPTION FROM C_Order td0 WHERE (td0.isActive = 'Y' OR td0.C_Order_ID = ($1) ) AND td0.C_Order_ID = $2 with big data, this query takes several hours | ||||
Steps To Reproduce | . connect to database . in one c_order record, set the cancelledorder_id to one ID that it does not exists in c_order table. In my example, Im updating the column to '12341234123412341234123412341234' for the c_order with id "B6E14AC1552B4F8FA03B74851DAAE71C": update c_order set cancelledorder_id='12341234123412341234123412341234' where c_order_id='B6E14AC1552B4F8FA03B74851DAAE71C'; . configure the log in postgres to print all queries . go to Sales Order window for the previous record updated: http://localhost:8080/openbravo/?tabId=186&recordId=B6E14AC1552B4F8FA03B74851DAAE71C [^] the query is displayed in the log | ||||
Proposed Solution | |||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | |||||
Issue History | |||||
Date Modified | Username | Field | Change | ||
2023-04-05 14:40 | malsasua | New Issue | |||
2023-04-05 14:40 | malsasua | Assigned To | => Triage Platform Base | ||
2023-04-05 14:40 | malsasua | Modules | => Core | ||
2023-04-05 14:40 | malsasua | Triggers an Emergency Pack | => No | ||
2023-04-05 15:06 | gorkaion | Issue Monitored: gorkaion | |||
2023-05-07 23:52 | hgbot | Note Added: 0149398 | |||
2023-05-15 00:19 | AugustoMauch | Note Added: 0149666 | |||
2023-05-29 12:27 | hgbot | Note Added: 0150407 | |||
2023-05-29 15:54 | hgbot | Note Added: 0150433 | |||
2023-05-29 16:16 | AugustoMauch | Note Deleted: 0149398 | |||
2023-05-29 16:16 | AugustoMauch | Note Deleted: 0149666 | |||
2023-05-29 16:16 | AugustoMauch | Note Deleted: 0150407 | |||
2023-06-13 17:29 | AugustoMauch | Assigned To | Triage Platform Base => AugustoMauch | ||
2023-06-13 17:30 | AugustoMauch | Status | new => scheduled | ||
2023-06-13 17:32 | hgbot | Resolution | open => fixed | ||
2023-06-13 17:32 | hgbot | Status | scheduled => closed | ||
2023-06-13 17:32 | hgbot | Fixed in Version | => PR23Q3 | ||
2023-06-13 17:32 | hgbot | Note Added: 0151125 | |||
2023-06-13 17:32 | hgbot | Note Added: 0151126 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|