Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0037835 | Openbravo ERP | 02. Master data management | public | 2018-02-05 16:01 | 2018-02-22 18:19 |
|
| Reporter | JONHM | |
| Assigned To | collazoandy4 | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR18Q2 | |
| Merge Request Status | |
| Review Assigned To | dmiguelez |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 50770 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0037835: Performance issue in Generate Invoices process |
| Description | Generate Invoices process takes too long to load in environments with high amount of data |
| Steps To Reproduce | - Run "Generate Invoices" process from the backend
It takes 2531974.042 ms to load |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  generate_invoice.sql (12,894) 2018-02-05 16:24
https://issues.openbravo.com/file_download.php?file_id=11529&type=bug
generate_invoices_query_plan (7,879) 2018-02-05 16:24
https://issues.openbravo.com/file_download.php?file_id=11530&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2018-02-05 16:01 | JONHM | New Issue | |
| 2018-02-05 16:01 | JONHM | Assigned To | => Triage Finance |
| 2018-02-05 16:01 | JONHM | File Added: generate_invoices.sql | |
| 2018-02-05 16:01 | JONHM | OBNetwork customer | => Yes |
| 2018-02-05 16:01 | JONHM | Modules | => Core |
| 2018-02-05 16:01 | JONHM | Support ticket | => 50770 |
| 2018-02-05 16:01 | JONHM | Resolution time | => 1519599600 |
| 2018-02-05 16:01 | JONHM | Triggers an Emergency Pack | => No |
| 2018-02-05 16:02 | JONHM | File Added: generate_invoices_test_plan | |
| 2018-02-05 16:12 | jfrances | Issue Monitored: jfrances | |
| 2018-02-05 16:24 | JONHM | File Deleted: generate_invoices.sql | |
| 2018-02-05 16:24 | JONHM | File Deleted: generate_invoices_test_plan | |
| 2018-02-05 16:24 | JONHM | File Added: generate_invoice.sql | |
| 2018-02-05 16:24 | JONHM | File Added: generate_invoices_query_plan | |
| 2018-02-06 11:20 | dmiguelez | Assigned To | Triage Finance => collazoandy4 |
| 2018-02-06 22:22 | collazoandy4 | Status | new => scheduled |
| 2018-02-12 17:09 | collazoandy4 | Note Added: 0102338 | |
| 2018-02-15 17:45 | collazoandy4 | Note Added: 0102447 | |
| 2018-02-16 17:19 | collazoandy4 | Note Edited: 0102447 | bug_revision_view_page.php?bugnote_id=0102447#r16731 |
| 2018-02-20 09:55 | hgbot | Checkin | |
| 2018-02-20 09:55 | hgbot | Note Added: 0102517 | |
| 2018-02-20 09:55 | hgbot | Status | scheduled => resolved |
| 2018-02-20 09:55 | hgbot | Resolution | open => fixed |
| 2018-02-20 09:55 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/b13652428b1cd2b3d8a8c491933e1a7cb5e50c1e [^] |
| 2018-02-20 09:56 | dmiguelez | Review Assigned To | => dmiguelez |
| 2018-02-20 09:56 | dmiguelez | Note Added: 0102518 | |
| 2018-02-20 09:56 | dmiguelez | Status | resolved => closed |
| 2018-02-20 09:56 | dmiguelez | Fixed in Version | => 3.0PR18Q2 |
| 2018-02-22 18:19 | hudsonbot | Checkin | |
| 2018-02-22 18:19 | hudsonbot | Note Added: 0102778 | |
|
Notes |
|
|
(0102338)
|
|
collazoandy4
|
|
2018-02-12 17:09
|
|
Test Plan
Open Generate Invoices window and check the business partner field is empty
Go to Sales Order and create three new records:
1. Business Partner: Alimentos y Supermercados, S.A, Invoice Terms: Immediate, Product: Agua sin Gas 1L, Ordered Quantity: 5
2. Business Partner: Hoteles Buenas Noches, S.A., Invoice Terms: After Delivery, Product: Zumo de Pera 0,5L, Ordered Quantity: 6
3. Business Partner: Restaurantes Luna Llena, S.A., Invoice Terms: After Order Delivered, Product: Zumo de Piña 0,5L, Ordered Quantity: 7
Go to Goods Shipment window and create a new record:
Business Partner: Hoteles Buenas Noches, S.A.
Create Lines From the previous order created
Edit the line created Movement Quantity: 3
Complete the shipment
Create another record in Header tab:
Business Partner: Restaurantes Luna Llena, S.A.
Create Lines From the previous order created
Complete the shipment
Open Generate Invoices window and check the business partner shows 3 records (The three partners created) |
|
|
|
(0102447)
|
|
collazoandy4
|
2018-02-15 17:45
(edited on: 2018-02-16 17:19) |
|
With the changes made the execution query cost was reduce from 105544030.57 to 838264.07
|
|
|
|
(0102517)
|
|
hgbot
|
|
2018-02-20 09:55
|
|
Repository: erp/devel/pi
Changeset: b13652428b1cd2b3d8a8c491933e1a7cb5e50c1e
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Fri Feb 09 18:44:25 2018 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/b13652428b1cd2b3d8a8c491933e1a7cb5e50c1e [^]
Fixes issue 37835: Performance issue in Generate Invoices process
Generate Invoices process takes too long to load in environments with high amount
of data
The query to get all the business partner with pending sales order to invoice was
changed using the index created to minimize the time that the process take to load
---
M src-db/database/model/tables/C_ORDERLINE.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
|
|
|
|
|
|
|
|
|
|