Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033320Openbravo ERP07. Sales managementpublic2016-06-20 18:472016-08-11 18:40
Reporteregoitz 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q4 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033320: On environment whit big volumnes the create from process takes long to print the popup.
DescriptionWhen do you want to deliver a order creating the shipment using the create from process, the popup takes minutes to be printed on environment with big amount of orders,shipements and invoices.

The alernative is to use the create shipments from order window but has also performance problems:

https://issues.openbravo.com/view.php?id=33319 [^]
Steps To Reproduce-On an environment with thousends of invoices, orders and shipment, create a shipment header, and click on the create from button.
It takes long to show the popup.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0033319 closed AtulOpenbravo The generate shipment from orders form takes long to print the data with a lot of orders pending to be deliver 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-06-20 18:47egoitzNew Issue
2016-06-20 18:47egoitzAssigned To => Triage Finance
2016-06-20 18:47egoitzModules => Core
2016-06-20 18:47egoitzResolution time => 1436565600
2016-06-20 18:47egoitzTriggers an Emergency Pack => No
2016-06-20 18:47egoitzTag Attached: Performance
2016-06-20 18:47egoitzRelationship addedrelated to 0033319
2016-06-21 10:21aferrazResolution time1436565600 => 1468188000
2016-06-21 13:42aferrazAssigned ToTriage Finance => markmm82
2016-07-06 17:37vmromanosAssigned Tomarkmm82 => AtulOpenbravo
2016-07-19 22:19AtulOpenbravoStatusnew => scheduled
2016-07-20 10:06hgbotCheckin
2016-07-20 10:06hgbotNote Added: 0088593
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/734222ff0bdd35a2ab8948a6f5dd366cdd97c3e7 [^]
2016-07-20 10:07aferrazReview Assigned To => aferraz
2016-07-20 10:07aferrazNote Added: 0088595
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: 0089023

Notes
(0088593)
hgbot   
2016-07-20 10:06   
Repository: erp/devel/pi
Changeset: 734222ff0bdd35a2ab8948a6f5dd366cdd97c3e7
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Jul 19 20:20:24 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/734222ff0bdd35a2ab8948a6f5dd366cdd97c3e7 [^]

Fixes Issue 33320: Performance problems in Create Lines From process

Problem was with loading invoices and orders in the respective combos.
Changed both queries to improve the performance.

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
---
(0088595)
aferraz   
2016-07-20 10:07   
Code review + Testing OK
(0089023)
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