Openbravo Issue Tracking System - Openbravo ERP
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0037742||Openbravo ERP||03. Procurement management||public||2018-01-29 09:41||2018-02-22 18:18|
|Assigned To||dmiguelez|| |
|Product Version|| |
|Target Version||Fixed in Version||3.0PR18Q2|| |
|Merge Request Status|
|Review Assigned To||vmromanos|
|Regression introduced in release|
|Regression introduced by commit|
|Triggers an Emergency Pack||No|
|Summary||0037742: Return Material pick and execute take more that 4 minutes to be loaed on an environment with thousands of orders.|
|Description||Opening the return material window takes too much.|
After 5 minutes the popup is loaded.
|Steps To Reproduce||Open the window on an environment with thousands of orders/orderlines.|
|Proposed Solution||Change the datable to use a hql query instead of a database view.|
|Tags||No tags attached.|
|depends on ||backport ||0037764||3.0PR18Q1 ||closed ||dmiguelez ||Return Material pick and execute take more that 4 minutes to be loaed on an environment with thousands of orders. |
|depends on ||backport ||0037765||3.0PR17Q4.1 ||closed ||dmiguelez ||Return Material pick and execute take more that 4 minutes to be loaed on an environment with thousands of orders. |
|2018-01-29 09:41||egoitz||New Issue|
|2018-01-29 09:41||egoitz||Assigned To|| => Triage Finance|
|2018-01-29 09:41||egoitz||Modules|| => Core|
|2018-01-29 09:41||egoitz||Triggers an Emergency Pack|| => No|
|2018-01-29 09:42||egoitz||Proposed Solution updated|
|2018-01-29 12:39||maite||Resolution time|| => 1518994800|
|2018-01-29 13:09||dmiguelez||Assigned To||Triage Finance => dmiguelez|
|2018-01-29 13:09||dmiguelez||Status||new => scheduled|
|2018-01-30 09:24||dmiguelez||Note Added: 0102042|
|2018-01-30 10:54||dmiguelez||Status||scheduled => acknowledged|
|2018-01-30 10:54||dmiguelez||Status||acknowledged => scheduled|
|2018-01-30 16:28||hgbot||Note Added: 0102062|
|2018-01-30 16:28||hgbot||Status||scheduled => resolved|
|2018-01-30 16:28||hgbot||Resolution||open => fixed|
|2018-01-30 16:28||hgbot||Fixed in SCM revision|| => http://code.openbravo.com/erp/devel/pi/rev/c05369b231390eaf33c5207a9f2c6ac7cb233d1b [^]|
|2018-01-30 16:31||dmiguelez||Review Assigned To|| => vmromanos|
|2018-01-30 16:31||dmiguelez||Note Added: 0102063|
|2018-01-30 16:31||dmiguelez||Status||resolved => closed|
|2018-01-30 16:31||dmiguelez||Fixed in Version|| => 3.0PR18Q2|
|2018-02-22 18:18||hudsonbot||Note Added: 0102696|
Test that the Return From Customer is working as it was working before:
Create a new Sales Order and a Goods Shipment for that Sales Order (using Create Lines From)
Any Business Partner and any stocked Product should be ok. Quantity must be greater than zero.
Create a new Return From Customer for the previous Goods Shipment and return all the quantity.
Create a new Return Material Receipt for the same Business Partner.
Open the Pick/Edit Lines pop up and realize that the previous Return From Customer is shown in the grid.
Close the Pop Up and select a different Business Partner.
Check that the previous Return From Customer is not shown in the grid.
Close the Pop Up and select the previous Business Partner and complete the Return.
Improvement in performance has been tested with Client's data.
It has improved from 4 minutes to around 250 ms.
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jan 29 11:38:22 2018 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c05369b231390eaf33c5207a9f2c6ac7cb233d1b [^]
Fixes Issue 37742. 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
Also, the planner in Postgres is able to properly use the Business
Code Review by Victor Martínez, testing by David Miguélez and the client Ok