Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0030146 | Retail Modules | Web POS | public | 2015-06-10 12:17 | 2024-02-08 14:44 |
| Reporter | Orekaria | ||||
| Assigned To | Retail | ||||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | out of date | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0030146: Oracle takes too much time to complete a query | ||||
| Description | Oracle takes too much time to complete a query In local, the time required is around 30 seconds | ||||
| Steps To Reproduce | This issue was detected thanks to these tests: - CashUpGroupingWithDifferentsBP - CashUpNoGroupingWithDifferentsBP The specific query taking too much time could be this one: "SELECT c_invoice.documentno as c_invoice_documentno, c_order.documentno as c_order_documentno, fin_payment_schedule.fin_payment_schedule_id, c_invoice.ispaid as c_invoice_paymentcomplete, fin_payment_schedule.amount as fin_pmnt_schle_expectedamount, fin_payment_schedule.paidamt as fin_pmnt_schle_receivedamount, c_invoice.grandtotal as c_invoice_grandtotal, c_invoice.totalpaid as c_invoice_totalpaid, c_invoice.outstandingamt as c_invoice_outstandingamt, c_invoice.finalsettlement as c_invoice_finalsettlement, c_invoiceline.line, c_invoice.c_bpartner_id, c_invoiceline.linenetamt, c_invoiceline.line_gross_amount FROM c_invoiceline INNER JOIN c_invoice ON c_invoiceline.c_invoice_id = c_invoice.c_invoice_id LEFT JOIN fin_payment_schedule ON c_invoice.c_invoice_id = fin_payment_schedule.c_invoice_id INNER JOIN c_orderline ON c_invoiceline.c_orderline_id = c_orderline.c_orderline_id INNER JOIN c_order ON c_orderline.c_order_id = c_order.c_order_id WHERE c_invoice.documentno IN ( SELECT c_invoice.documentno FROM c_invoiceline INNER JOIN c_invoice ON c_invoiceline.c_invoice_id = c_invoice.c_invoice_id INNER JOIN c_orderline ON c_invoiceline.c_orderline_id = c_orderline.c_orderline_id INNER JOIN c_order ON c_orderline.c_order_id = c_order.c_order_id WHERE c_order.documentno = 'VBS1001/0000005') ORDER BY c_order_documentno ASC, c_invoiceline.line" | ||||
| Proposed Solution | maybe "the inner select can go away as it seems that most info is already joined in on the main from clause" | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2015-06-10 12:17 | Orekaria | New Issue | |||
| 2015-06-10 12:17 | Orekaria | Assigned To | => Retail | ||
| 2015-06-10 12:17 | Orekaria | OBNetwork customer | => No | ||
| 2015-06-10 12:17 | Orekaria | Triggers an Emergency Pack | => No | ||
| 2015-06-10 12:23 | Orekaria | Description Updated | bug_revision_view_page.php?rev_id=8797#r8797 | ||
| 2015-06-10 12:24 | Orekaria | Proposed Solution updated | |||
| 2015-06-10 13:06 | hgbot | Checkin | |||
| 2015-06-10 13:06 | hgbot | Note Added: 0078174 | |||
| 2016-02-19 16:33 | Orekaria | Status | new => acknowledged | ||
| 2024-02-08 14:44 | shuehner | Status | acknowledged => scheduled | ||
| 2024-02-08 14:44 | shuehner | Note Added: 0160454 | |||
| 2024-02-08 14:44 | shuehner | Status | scheduled => closed | ||
| 2024-02-08 14:44 | shuehner | Resolution | open => out of date | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||