Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034620
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 04. Warehouse managementmajoralways2016-11-24 18:132017-03-15 20:18
ReporteregoitzView Statuspublic 
Assigned Torqueralta 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q2
StatusclosedFix in branchFixed in SCM revision8508f2e8710d
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarkmm82
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034620: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0025186 closedcollazoandy4 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 closedAtulOpenbravo Openbravo ERP Performance of Warehouse Control Report 
related to defect 0035531 closedmarkmm82 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 closedcollazoandy4 Openbravo ERP The product movement report collapses the system when there are thousands of result to be shown 
related to defect 0039619 closedAtulOpenbravo Openbravo ERP ReportMaterialTransactionEditionJR consumes a lot of memory and produces a system crash 

-  Notes
(0092471)
aferraz (manager)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2017-01-04 18:20

 Code review + Testing OK
(0093285)
hgbot (developer)
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 (developer)
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 (developer)
2017-01-13 16:21

 Code Review + Testing OK
(0095065)
hudsonbot (developer)
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 (developer)
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 (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2016-11-24 18:13 egoitz New Issue
2016-11-24 18:13 egoitz Assigned To => Triage Finance
2016-11-24 18:13 egoitz Modules => Core
2016-11-24 18:13 egoitz Resolution time => 1482102000
2016-11-24 18:13 egoitz Triggers an Emergency Pack => No
2016-11-25 09:46 aferraz Assigned To Triage Finance => AtulOpenbravo
2016-12-09 13:26 AtulOpenbravo Status new => scheduled
2016-12-16 09:59 aferraz Relationship added related to 0025186
2016-12-16 11:14 aferraz Note Added: 0092471
2016-12-16 11:14 aferraz Type defect => design defect
2016-12-16 11:19 aferraz Assigned To AtulOpenbravo => collazoandy4
2016-12-16 16:37 markmm82 Assigned To collazoandy4 => rqueralta
2016-12-20 12:45 rqueralta Note Added: 0092851
2017-01-04 18:15 hgbot Checkin
2017-01-04 18:15 hgbot Note Added: 0093200
2017-01-04 18:15 hgbot Status scheduled => resolved
2017-01-04 18:15 hgbot Resolution open => fixed
2017-01-04 18:15 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6edf67f27c254fb40fb0140d3090cf76b51a0958 [^]
2017-01-04 18:15 hgbot Checkin
2017-01-04 18:15 hgbot Note Added: 0093201
2017-01-04 18:20 markmm82 Review Assigned To => markmm82
2017-01-04 18:20 markmm82 Note Added: 0093203
2017-01-04 18:20 markmm82 Status resolved => closed
2017-01-04 18:20 markmm82 Fixed in Version => 3.0PR17Q1
2017-01-09 20:16 markmm82 Fixed in Version 3.0PR17Q1 => 3.0PR17Q2
2017-01-09 20:42 hgbot Checkin
2017-01-09 20:42 hgbot Note Added: 0093285
2017-01-10 09:48 vmromanos Status closed => new
2017-01-10 09:48 vmromanos Resolution fixed => open
2017-01-10 09:48 vmromanos Fixed in Version 3.0PR17Q2 =>
2017-01-10 09:51 vmromanos Resolution time 1482102000 =>
2017-01-13 16:19 hgbot Checkin
2017-01-13 16:19 hgbot Note Added: 0093554
2017-01-13 16:19 hgbot Status new => resolved
2017-01-13 16:19 hgbot Resolution open => fixed
2017-01-13 16:19 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/6edf67f27c254fb40fb0140d3090cf76b51a0958 [^] => http://code.openbravo.com/erp/devel/pi/rev/8508f2e8710df204504a3372a4ea8042521763c1 [^]
2017-01-13 16:21 markmm82 Note Added: 0093555
2017-01-13 16:21 markmm82 Status resolved => closed
2017-01-13 16:21 markmm82 Fixed in Version => 3.0PR17Q2
2017-03-15 20:18 hudsonbot Checkin
2017-03-15 20:18 hudsonbot Note Added: 0095065
2017-03-15 20:18 hudsonbot Checkin
2017-03-15 20:18 hudsonbot Note Added: 0095066
2017-03-15 20:18 hudsonbot Checkin
2017-03-15 20:18 hudsonbot Note Added: 0095073
2017-03-15 20:18 hudsonbot Checkin
2017-03-15 20:18 hudsonbot Note Added: 0095097
2017-04-03 12:16 aferraz Relationship added related to 0035531
2017-04-27 17:50 egoitz Relationship added related to 0035871
2017-12-13 18:05 AtulOpenbravo Relationship added related to 0037336
2017-12-14 09:58 dmiguelez Relationship replaced has duplicate 0037336
2018-11-15 17:15 Sandrahuguet Relationship added related to 0039619

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker