Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037516Openbravo ERP02. Master data managementpublic2017-12-19 17:082018-02-22 18:18
ReporterJONHM 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q2 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket48552
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037516: Performance issue in Orders Awaiting Delivery Report
DescriptionThere is a performance issue in Orders Awaiting Delivery Report on environments with high amount of data.
Steps To ReproduceLogin on the environment provided by support:

- Open Orders Awaiting Delivery Report and set:
  * From date: 10-08-2017
  * To date: 13-09-2017
  * Org: BAPS Shayona - Robbinsville

It take about 90 seconds to finish
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0037515 closed AtulOpenbravo Performance issue in Orders Awaiting Invoice Report 
Attached Files? query.sql (18,898) 2017-12-19 17:19
https://issues.openbravo.com/file_download.php?file_id=11376&type=bug
? query_plan (16,463) 2017-12-19 17:19
https://issues.openbravo.com/file_download.php?file_id=11377&type=bug
txt 37516Final_QueryPlan.txt (37,303) 2018-01-15 09:52
https://issues.openbravo.com/file_download.php?file_id=11459&type=bug
Issue History
Date ModifiedUsernameFieldChange
2017-12-19 17:08JONHMNew Issue
2017-12-19 17:08JONHMAssigned To => Triage Finance
2017-12-19 17:08JONHMFile Added: query.sql
2017-12-19 17:08JONHMOBNetwork customer => Yes
2017-12-19 17:08JONHMModules => Core
2017-12-19 17:08JONHMSupport ticket => 48552
2017-12-19 17:08JONHMResolution time => 1515452400
2017-12-19 17:08JONHMTriggers an Emergency Pack => No
2017-12-19 17:08JONHMFile Added: query_plan
2017-12-19 17:11aferrazRelationship addedrelated to 0037515
2017-12-19 17:18JONHMSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=16481#r16481
2017-12-19 17:19JONHMSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=16482#r16482
2017-12-19 17:19JONHMFile Deleted: query.sql
2017-12-19 17:19JONHMFile Deleted: query_plan
2017-12-19 17:19JONHMFile Added: query.sql
2017-12-19 17:19JONHMFile Added: query_plan
2017-12-19 17:52dmiguelezAssigned ToTriage Finance => AtulOpenbravo
2017-12-19 18:23AtulOpenbravoStatusnew => scheduled
2017-12-20 09:51AtulOpenbravoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=16483#r16483
2018-01-15 09:48AtulOpenbravoNote Added: 0101688
2018-01-15 09:52AtulOpenbravoFile Added: 37516Final_QueryPlan.txt
2018-01-15 12:30hgbotCheckin
2018-01-15 12:30hgbotNote Added: 0101691
2018-01-15 12:30hgbotStatusscheduled => resolved
2018-01-15 12:31hgbotResolutionopen => fixed
2018-01-15 12:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/385dc5c1739659c2561e5eed7293aecb1a3a9ce3 [^]
2018-01-15 12:32dmiguelezReview Assigned To => dmiguelez
2018-01-15 12:32dmiguelezNote Added: 0101692
2018-01-15 12:32dmiguelezStatusresolved => closed
2018-01-15 12:32dmiguelezFixed in Version => 3.0PR18Q2
2018-02-22 18:18hudsonbotCheckin
2018-02-22 18:18hudsonbotNote Added: 0102656

Notes
(0101688)
AtulOpenbravo   
2018-01-15 09:48   
Login on the environment provided by support:

- Open Orders Awaiting Delivery Report and set:
  * From date: 10-08-2017
  * To date: 13-09-2017
  * Org: BAPS Shayona - Robbinsville

It take about ~ 2.5 seconds to finish
(0101691)
hgbot   
2018-01-15 12:30   
Repository: erp/devel/pi
Changeset: 385dc5c1739659c2561e5eed7293aecb1a3a9ce3
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Jan 12 02:12:24 2018 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/385dc5c1739659c2561e5eed7293aecb1a3a9ce3 [^]

Fixes Issue 0037516:Performance issue in Orders Awaiting Delivery Report

** Use a subquery to fetch qtyinstock, aum by respective queries
only once, add uomsymbol in inner select, aumsymbol in outer select
** Use isdelivered flag to avoid c_orderline exists clause which checks
undelivered orders line by line qtyordered against qtydelivered

---
M modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
---
(0101692)
dmiguelez   
2018-01-15 12:32   
Code Review + Testing Ok
(0102656)
hudsonbot   
2018-02-22 18:18   
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/980a6ad5bbf5 [^]
Maturity status: Test