Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0039284Openbravo ERP02. Master data managementpublic2018-09-13 16:272018-12-11 20:22
JONHM 
Sandrahuguet 
urgentmajoralways
closedfixed 
5
 
3.0PR19Q1 
dmiguelez
Core
No
0039284: Return Material pick and execute take more that 5 minutes to be loaded on an environment with thousands of orders
Opening the return material window takes too much time to load.
The view is taking about 5 minutes to show data, because of that, a timeout on the P&E window shows message 'No items to show'
Open Return Material Receipt window and run 'Pick/Edit' process.
Performance
Issue History
2018-09-13 16:27JONHMNew Issue
2018-09-13 16:27JONHMAssigned To => Triage Finance
2018-09-13 16:27JONHMModules => Core
2018-09-13 16:27JONHMResolution time => 1538517600
2018-09-13 16:27JONHMTriggers an Emergency Pack => No
2018-09-14 13:20SandrahuguetAssigned ToTriage Finance => markmm82
2018-09-14 18:00markmm82Statusnew => scheduled
2018-09-17 13:39SandrahuguetTag Attached: Performance
2018-09-26 21:33markmm82Note Added: 0107044
2018-10-17 15:31hgbotCheckin
2018-10-17 15:31hgbotNote Added: 0107367
2018-10-17 15:31hgbotStatusscheduled => resolved
2018-10-17 15:31hgbotResolutionopen => fixed
2018-10-17 15:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/92a8e3505111ecdab23209ba9d02eb8070a69dce [^]
2018-10-17 15:31hgbotCheckin
2018-10-17 15:31hgbotNote Added: 0107368
2018-10-17 15:31hgbotCheckin
2018-10-17 15:31hgbotNote Added: 0107369
2018-10-17 15:31hgbotCheckin
2018-10-17 15:31hgbotNote Added: 0107370
2018-10-17 15:32SandrahuguetReview Assigned To => dmiguelez
2018-10-17 15:32SandrahuguetAssigned Tomarkmm82 => Sandrahuguet
2018-10-22 11:25dmiguelezNote Added: 0107471
2018-10-22 11:25dmiguelezStatusresolved => closed
2018-10-22 11:25dmiguelezFixed in Version => 3.0PR19Q1
2018-12-11 20:22hudsonbotCheckin
2018-12-11 20:22hudsonbotNote Added: 0108434
2018-12-11 20:22hudsonbotCheckin
2018-12-11 20:22hudsonbotNote Added: 0108435
2018-12-11 20:22hudsonbotCheckin
2018-12-11 20:22hudsonbotNote Added: 0108436

Notes
(0107044)
markmm82   
2018-09-26 21:33   
Testing on client's environment.

Before fix:
Cost=5737411.29 Time=207724.781 ms

After fix:
Cost=90944.03 Time=68.869 ms

Have been highly improved the cost as well as the execution time.
(0107367)
hgbot   
2018-10-17 15:31   
Repository: erp/devel/pi
Changeset: 92a8e3505111ecdab23209ba9d02eb8070a69dce
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon Oct 15 21:29:18 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/92a8e3505111ecdab23209ba9d02eb8070a69dce [^]

Fixed issue 39284 new returnline column to improve performance

New returnline column to improve performance in M_RM_RECEIPT_PICK_EDIT view

testCostingR10 modified to use a copy of return from customer document instead
a copy of order document.

---
M src-db/database/model/tables/C_ORDERLINE.xml
M src-db/database/model/triggers/C_DOCTYPE_TRG.xml
M src-db/database/model/triggers/C_ORDERLINE_TRG.xml
M src-db/database/model/triggers/C_ORDERLINE_TRG2.xml
M src-db/database/model/triggers/C_ORDER_TRG.xml
M src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-test/src/org/openbravo/test/costing/utils/TestCostingConstants.java
M src-test/src/org/openbravo/test/costing/utils/TestCostingUtils.java
---
(0107368)
hgbot   
2018-10-17 15:31   
Repository: erp/devel/pi
Changeset: 33a73969f588fd713f6a13147cb69d707e87bca7
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon Oct 15 21:49:50 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/33a73969f588fd713f6a13147cb69d707e87bca7 [^]

related to issue 39284 sampletada changes related to testCostingR10 changes

---
M referencedata/sampledata/QA_Testing/AD_PINSTANCE.xml
M referencedata/sampledata/QA_Testing/AD_PROCESS_REQUEST.xml
M referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml
M referencedata/sampledata/QA_Testing/C_ORDER.xml
M referencedata/sampledata/QA_Testing/C_ORDERLINE.xml
M referencedata/sampledata/QA_Testing/C_ORDERLINETAX.xml
M referencedata/sampledata/QA_Testing/C_ORDERTAX.xml
M referencedata/sampledata/QA_Testing/M_PRODUCT.xml
M referencedata/sampledata/QA_Testing/M_STORAGE_PENDING.xml
M src-test/src/org/openbravo/test/costing/utils/TestCostingConstants.java
---
(0107369)
hgbot   
2018-10-17 15:31   
Repository: erp/devel/pi
Changeset: 329f562353f5f1abe996ca89accdb09df656926a
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Oct 17 10:30:06 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/329f562353f5f1abe996ca89accdb09df656926a [^]

related to issue 39284 modulescript to fill new returnline column

---
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateReturnLineInOrderLine.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateReturnLineInOrderLineData.class
A src-util/modulescript/src/org/openbravo/modulescript/UpdateReturnLineInOrderLine.java
A src-util/modulescript/src/org/openbravo/modulescript/UpdateReturnLineInOrderLine_data.xsql
---
(0107370)
hgbot   
2018-10-17 15:31   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 23a96d19c6f1636517876e64284e7685591aec29
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon Oct 01 08:39:10 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/23a96d19c6f1636517876e64284e7685591aec29 [^]

related to issue 39284 set new returnline column in orderloader

---
M src/org/openbravo/retail/posterminal/OrderLoader.java
---
(0107471)
dmiguelez   
2018-10-22 11:25   
Code Review + Testing Ok
(0108434)
hudsonbot   
2018-12-11 20:22   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/470e3cd384c5 [^]
Maturity status: Test
(0108435)
hudsonbot   
2018-12-11 20:22   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/470e3cd384c5 [^]
Maturity status: Test
(0108436)
hudsonbot   
2018-12-11 20:22   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/470e3cd384c5 [^]
Maturity status: Test