Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034620Openbravo ERP04. Warehouse managementpublic2016-11-24 18:132017-03-15 20:18
Reporteregoitz 
Assigned Torqueralta 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Tomarkmm82
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034620: The ReportWarehouseControl report collapse the system
DescriptionThe execution of the report ReportWarehouseControl produces a huge memory usage on environments with big amount of data.
Steps To ReproduceExecute the report on an environment with big amount of data.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0025186 closed collazoandy4 Openbravo ERP Jave heap error accessing to the pending goods receipt window when there are 16000 lines for orders not receipt 
has duplicate defect 0037336 closed AtulOpenbravo Openbravo ERP Performance of Warehouse Control Report 
related to defect 0035531 closed markmm82 Modules The browswer get stucked when printing the receivable aging schedule report showing details and having a lot of invoices pending 
related to defect 0035871 closed collazoandy4 Openbravo ERP The product movement report collapses the system when there are thousands of result to be shown 
related to defect 0039619 closed AtulOpenbravo Openbravo ERP ReportMaterialTransactionEditionJR consumes a lot of memory and produces a system crash 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-11-24 18:13egoitzNew Issue
2016-11-24 18:13egoitzAssigned To => Triage Finance
2016-11-24 18:13egoitzModules => Core
2016-11-24 18:13egoitzResolution time => 1482102000
2016-11-24 18:13egoitzTriggers an Emergency Pack => No
2016-11-25 09:46aferrazAssigned ToTriage Finance => AtulOpenbravo
2016-12-09 13:26AtulOpenbravoStatusnew => scheduled
2016-12-16 09:59aferrazRelationship addedrelated to 0025186
2016-12-16 11:14aferrazNote Added: 0092471
2016-12-16 11:14aferrazTypedefect => design defect
2016-12-16 11:19aferrazAssigned ToAtulOpenbravo => collazoandy4
2016-12-16 16:37markmm82Assigned Tocollazoandy4 => rqueralta
2016-12-20 12:45rqueraltaNote Added: 0092851
2017-01-04 18:15hgbotCheckin
2017-01-04 18:15hgbotNote Added: 0093200
2017-01-04 18:15hgbotStatusscheduled => resolved
2017-01-04 18:15hgbotResolutionopen => fixed
2017-01-04 18:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6edf67f27c254fb40fb0140d3090cf76b51a0958 [^]
2017-01-04 18:15hgbotCheckin
2017-01-04 18:15hgbotNote Added: 0093201
2017-01-04 18:20markmm82Review Assigned To => markmm82
2017-01-04 18:20markmm82Note Added: 0093203
2017-01-04 18:20markmm82Statusresolved => closed
2017-01-04 18:20markmm82Fixed in Version => 3.0PR17Q1
2017-01-09 20:16markmm82Fixed in Version3.0PR17Q1 => 3.0PR17Q2
2017-01-09 20:42hgbotCheckin
2017-01-09 20:42hgbotNote Added: 0093285
2017-01-10 09:48vmromanosStatusclosed => new
2017-01-10 09:48vmromanosResolutionfixed => open
2017-01-10 09:48vmromanosFixed in Version3.0PR17Q2 =>
2017-01-10 09:51vmromanosResolution time1482102000 =>
2017-01-13 16:19hgbotCheckin
2017-01-13 16:19hgbotNote Added: 0093554
2017-01-13 16:19hgbotStatusnew => resolved
2017-01-13 16:19hgbotResolutionopen => fixed
2017-01-13 16:19hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6edf67f27c254fb40fb0140d3090cf76b51a0958 [^] => http://code.openbravo.com/erp/devel/pi/rev/8508f2e8710df204504a3372a4ea8042521763c1 [^]
2017-01-13 16:21markmm82Note Added: 0093555
2017-01-13 16:21markmm82Statusresolved => closed
2017-01-13 16:21markmm82Fixed in Version => 3.0PR17Q2
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095065
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095066
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095073
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095097
2017-04-03 12:16aferrazRelationship addedrelated to 0035531
2017-04-27 17:50egoitzRelationship addedrelated to 0035871
2017-12-13 18:05AtulOpenbravoRelationship addedrelated to 0037336
2017-12-14 09:58dmiguelezRelationship replacedhas duplicate 0037336
2018-11-15 17:15SandrahuguetRelationship addedrelated to 0039619

Notes
(0092471)
aferraz   
2016-12-16 11:14   
Moved to design defect:
- Query should not be launched when opening the report: vars.commandIn("DEFAULT").
- In order to reduce the memory usage, we should limit displayed data with the value of a preference. A warning should inform that data is being limited (see issue 0025186).
(0092851)
rqueralta   
2016-12-20 12:45   
Test plan:

As System Admin
  - Go to Preference window
    Edit "ReportLimit" preference and set "Value"=10

As F&B International Group Admin

  - Go to Warehouse Control Report window
    Set "From Date"=01-01-2010 and click in HTML Format buttom
    Check that a warning message is shown.
(0093200)
hgbot   
2017-01-04 18:15   
Repository: erp/devel/pi
Changeset: 6edf67f27c254fb40fb0140d3090cf76b51a0958
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Mon Dec 19 13:22:02 2016 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/6edf67f27c254fb40fb0140d3090cf76b51a0958 [^]

Fixed issue 34620: The ReportWarehouseControl report collapse the system

For a better performance, the data was limit with the value of a preference.
And a warning is shown to inform that data is being limited. Besides the query does
not be launched when opening the report

---
M src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl.java
M src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl_data.xsql
---
(0093201)
hgbot   
2017-01-04 18:15   
Repository: erp/devel/pi
Changeset: e7d951326bc3b353359547067b8af00a52b31e88
Author: Mark <markmm82 <at> gmail.com>
Date: Wed Dec 21 12:11:17 2016 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/e7d951326bc3b353359547067b8af00a52b31e88 [^]

Related to issue 34620: Code review improvements

Removed ORDER BY clause, it is not relevant due this method is used to retrieve the record count.

---
M src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl_data.xsql
---
(0093203)
markmm82   
2017-01-04 18:20   
Code review + Testing OK
(0093285)
hgbot   
2017-01-09 20:42   
Repository: erp/devel/pi
Changeset: b7eb116a1922ff93322efa70a1883905c8ba8ad4
Author: Mark <markmm82 <at> gmail.com>
Date: Mon Jan 09 14:36:47 2017 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/b7eb116a1922ff93322efa70a1883905c8ba8ad4 [^]

Related to issue 34620: Backed out changeset 6edf67f27c25

---
M src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl.java
M src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl_data.xsql
---
(0093554)
hgbot   
2017-01-13 16:19   
Repository: erp/devel/pi
Changeset: 8508f2e8710df204504a3372a4ea8042521763c1
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Mon Jan 09 22:24:16 2017 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/8508f2e8710df204504a3372a4ea8042521763c1 [^]

Fixed issue 34620: The ReportWarehouseControl report collapse the system

For a better performance, the data was limit with the value of a preference.
And a warning is shown to inform that data is being limited. Besides the query does
not be launched when opening the report

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl.java
M src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl_data.xsql
---
(0093555)
markmm82   
2017-01-13 16:21   
Code Review + Testing OK
(0095065)
hudsonbot   
2017-03-15 20: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/54e102bef53e [^]
Maturity status: Test
(0095066)
hudsonbot   
2017-03-15 20: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/54e102bef53e [^]
Maturity status: Test
(0095073)
hudsonbot   
2017-03-15 20: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/54e102bef53e [^]
Maturity status: Test
(0095097)
hudsonbot   
2017-03-15 20: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/54e102bef53e [^]
Maturity status: Test