Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037765Openbravo ERP03. Procurement managementpublic2018-01-29 09:412018-01-31 08:48
Reporteregoitz 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR17Q4.1Fixed in Version3.0PR18Q2 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037765: Return Material pick and execute take more that 4 minutes to be loaed on an environment with thousands of orders.
DescriptionOpening the return material window takes too much.
After 5 minutes the popup is loaded.
Steps To ReproduceOpen the window on an environment with thousands of orders/orderlines.
Proposed SolutionChange the datable to use a hql query instead of a database view.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0037742 closed dmiguelez Return Material pick and execute take more that 4 minutes to be loaed on an environment with thousands of orders. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-01-30 10:54dmiguelezTypedefect => backport
2018-01-30 10:54dmiguelezTarget Version => 3.0PR17Q4.1
2018-01-31 08:46hgbotCheckin
2018-01-31 08:46hgbotNote Added: 0102078
2018-01-31 08:46hgbotStatusscheduled => resolved
2018-01-31 08:46hgbotResolutionopen => fixed
2018-01-31 08:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR17Q4.1/rev/018323fa0ae3db264368f657b9f0f1ef8a09f34e [^]
2018-01-31 08:48dmiguelezReview Assigned To => dmiguelez
2018-01-31 08:48dmiguelezNote Added: 0102079
2018-01-31 08:48dmiguelezStatusresolved => closed
2018-01-31 08:48dmiguelezFixed in Version => 3.0PR18Q2

Notes
(0102078)
hgbot   
2018-01-31 08:46   
Repository: erp/backports/3.0PR17Q4.1
Changeset: 018323fa0ae3db264368f657b9f0f1ef8a09f34e
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jan 29 11:38:22 2018 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR17Q4.1/rev/018323fa0ae3db264368f657b9f0f1ef8a09f34e [^]

Fixes Issue 37765. Fixes performance in Return Material Receipt P&E

In view m_rm_receipt_pick_edit a new column has been added with the
Business Partner from the Order.

This new column is used in the filter of the Return Material P&E Tab.
By doing so, additional cross joins with OrderLine and Order Tables
are avoided.
Also, the planner in Postgres is able to properly use the Business
Partner index.

---
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_TAB.xml
---
(0102079)
dmiguelez   
2018-01-31 08:48   
Code Review + Testing Ok