Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0033319Openbravo ERP07. Sales managementpublic2016-06-20 18:432016-09-12 18:41
egoitz 
AtulOpenbravo 
urgentmajoralways
closedfixed 
5
 
3.0PR16Q4 
aferraz
Core
No
0033319: The generate shipment from orders form takes long to print the data with a lot of orders pending to be deliver
When there are thousand of orders pending to be delivered, the form where you select the order u orders that you want to create shipments from, takes long to be printed.
-On an environment with thousand of order pending to be deliver, open the create shipments from order form.
*It takes minutes to show the form.
Performance
related to defect 0033320 closed AtulOpenbravo On environment whit big volumnes the create from process takes long to print the popup. 
related to defect 0033956 closed AtulOpenbravo The generate invoic takes long with big amount of data 
Issue History
2016-06-20 18:43egoitzNew Issue
2016-06-20 18:43egoitzAssigned To => Triage Finance
2016-06-20 18:43egoitzModules => Core
2016-06-20 18:43egoitzResolution time => 1468188000
2016-06-20 18:43egoitzTriggers an Emergency Pack => No
2016-06-20 18:47egoitzRelationship addedrelated to 0033320
2016-06-20 18:47egoitzTag Attached: Performance
2016-06-21 13:42aferrazAssigned ToTriage Finance => markmm82
2016-07-06 17:33vmromanosAssigned Tomarkmm82 => AtulOpenbravo
2016-07-19 22:19AtulOpenbravoStatusnew => scheduled
2016-07-20 10:06hgbotCheckin
2016-07-20 10:06hgbotNote Added: 0088592
2016-07-20 10:06hgbotStatusscheduled => resolved
2016-07-20 10:06hgbotResolutionopen => fixed
2016-07-20 10:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/92fe35392dd6dddb58533ad4c074a71a486b3e87 [^]
2016-07-20 10:07aferrazReview Assigned To => aferraz
2016-07-20 10:07aferrazNote Added: 0088594
2016-07-20 10:07aferrazStatusresolved => closed
2016-07-20 10:07aferrazFixed in Version => 3.0PR16Q4
2016-08-11 18:40hudsonbotCheckin
2016-08-11 18:40hudsonbotNote Added: 0089022
2016-09-12 18:41egoitzIssue cloned0033956
2016-09-12 18:41egoitzRelationship addedrelated to 0033956

Notes
(0088592)
hgbot   
2016-07-20 10:06   
Repository: erp/devel/pi
Changeset: 92fe35392dd6dddb58533ad4c074a71a486b3e87
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Jul 19 19:51:14 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/92fe35392dd6dddb58533ad4c074a71a486b3e87 [^]

Fixes issue 33319: Performance problems in Create Shipments from Orders process

Problem was with use of view m_inout_candidate_v in the query.
Fix implements the data fetching logic in query itself.

---
M src/org/openbravo/erpCommon/ad_forms/GenerateShipmentsmanual_data.xsql
---
(0088594)
aferraz   
2016-07-20 10:07   
Code review + Testing OK
(0089022)
hudsonbot   
2016-08-11 18:40   
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/edaa05b1fb18 [^]
Maturity status: Test