Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032032Openbravo ERPI. Performancepublic2016-01-27 22:572016-06-17 19:38
Reporterfmolina 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Version3.0PR15Q2.1 
Target VersionFixed in Version3.0PR16Q3 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesOrders Awaiting Delivery
Support ticket38134
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032032: Performance problem in Orders Awaiting Delivery Report
DescriptionOrders Awaiting Delivery Report query takes a very large amount of time even when must return few records. The query is built in class ReportOrderNotShippedData.
Steps To ReproduceI can provide credentials to specific environment where problem is reproducible
Proposed Solution  
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0034071 closed Triage Omni OMS Performance problems on the Orders Awaiting Delivery Report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-01-27 22:57fmolinaNew Issue
2016-01-27 22:57fmolinaAssigned To => platform
2016-01-27 22:57fmolinaOBNetwork customer => No
2016-01-27 22:57fmolinaWeb browser => Google Chrome
2016-01-27 22:57fmolinaModules => Orders Awaiting Delivery
2016-01-27 22:57fmolinaSupport ticket => 38134
2016-01-27 22:57fmolinaTriggers an Emergency Pack => No
2016-01-28 07:49alostaleAssigned Toplatform => Triage Finance
2016-04-28 10:06egoitzOBNetwork customerNo => Yes
2016-04-28 10:06egoitzWeb browserGoogle Chrome => Google Chrome
2016-04-28 10:06egoitzResolution time => 1465509600
2016-05-09 11:08aferrazAssigned ToTriage Finance => AtulOpenbravo
2016-05-19 07:49AtulOpenbravoStatusnew => scheduled
2016-05-19 16:51rbianchiniIssue Monitored: rbianchini
2016-06-03 15:41hgbotCheckin
2016-06-03 15:41hgbotNote Added: 0086993
2016-06-03 15:41hgbotStatusscheduled => resolved
2016-06-03 15:41hgbotResolutionopen => fixed
2016-06-03 15:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/083683ac003829294a2b3aa6d6128e31c3b331d0 [^]
2016-06-03 15:41hgbotCheckin
2016-06-03 15:41hgbotNote Added: 0086994
2016-06-03 16:00aferrazReview Assigned To => aferraz
2016-06-03 16:00aferrazNote Added: 0086996
2016-06-03 16:00aferrazStatusresolved => closed
2016-06-03 16:00aferrazFixed in Version => 3.0PR16Q3
2016-06-17 19:38hudsonbotCheckin
2016-06-17 19:38hudsonbotNote Added: 0087593
2016-06-17 19:38hudsonbotCheckin
2016-06-17 19:38hudsonbotNote Added: 0087594
2016-09-23 12:23aferrazRelationship addedhas duplicate 0034071

Notes
(0086993)
hgbot   
2016-06-03 15:41   
Repository: erp/devel/pi
Changeset: 083683ac003829294a2b3aa6d6128e31c3b331d0
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed May 25 00:58:03 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/083683ac003829294a2b3aa6d6128e31c3b331d0 [^]

Fixes issue 32032: ReportOrderNotShipped report query improved

-Replace IN clause for locator using EXISTS
-Remove unwanted C_Order from subquery which compares quantities
-Rearrange the query
-Get stock from m_storage_detail using subquery instead of left join

---
M modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
---
(0086994)
hgbot   
2016-06-03 15:41   
Repository: erp/devel/pi
Changeset: a68ba952787ab038c904bfe8af2814fd2a5a08bf
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Jun 03 14:56:32 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a68ba952787ab038c904bfe8af2814fd2a5a08bf [^]

Related to issue 32032: Code review improvements

---
M modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
---
(0086996)
aferraz   
2016-06-03 16:00   
Code review + Testing OK
(0087593)
hudsonbot   
2016-06-17 19:38   
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/0dc7be081b1c [^]
Maturity status: Test
(0087594)
hudsonbot   
2016-06-17 19:38   
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/0dc7be081b1c [^]
Maturity status: Test