Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039284Openbravo ERP02. Master data managementpublic2018-09-13 16:272018-12-11 20:22
ReporterJONHM 
Assigned ToSandrahuguet 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q1 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket4445
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039284: Return Material pick and execute take more that 5 minutes to be loaded on an environment with thousands of orders
DescriptionOpening 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'
Steps To ReproduceOpen Return Material Receipt window and run 'Pick/Edit' process.
Proposed Solution
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-09-13 16:27JONHMNew Issue
2018-09-13 16:27JONHMAssigned To => Triage Finance
2018-09-13 16:27JONHMOBNetwork customer => Yes
2018-09-13 16:27JONHMModules => Core
2018-09-13 16:27JONHMSupport ticket => 4445
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