Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033319Openbravo ERP07. Sales managementpublic2016-06-20 18:432016-09-12 18:41
Reporteregoitz 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q4 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket42526
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033319: The generate shipment from orders form takes long to print the data with a lot of orders pending to be deliver
DescriptionWhen 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.
Steps To Reproduce-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.
Proposed Solution
Additional Information
TagsPerformance
Relationships
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-06-20 18:43egoitzNew Issue
2016-06-20 18:43egoitzAssigned To => Triage Finance
2016-06-20 18:43egoitzOBNetwork customer => Yes
2016-06-20 18:43egoitzModules => Core
2016-06-20 18:43egoitzSupport ticket => 42526
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