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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035871
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2017-04-27 17:502017-05-29 17:43
ReporteregoitzView Statuspublic 
Assigned Tocollazoandy4 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q3
StatusclosedFix in branchFixed in SCM revision5b9ef64d95b3
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035871: The product movement report collapses the system when there are thousands of result to be shown

DescriptionThe product movement report consumes a lot of memory when there are thousands of results.
The number of rows shown should be limited.
Steps To ReproduceExecute the report on an environment with thousands of product movements.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0034620 closedrqueralta The ReportWarehouseControl report collapse the system 

-  Notes
(0096404)
collazoandy4 (reporter)
2017-05-04 22:19

Test Plan
  As System admin:
    Edit the Forms Limit preference value to 10
  Log out and Log in
  As group admin role:
    Go to Product Movement Report window:
      From Date: 01-01-2015
      To Date: 01-01-2017
    Clic on HTML Format button and realize a warning message is shown
(0096413)
hgbot (developer)
2017-05-05 11:20

Repository: erp/devel/pi
Changeset: 5b9ef64d95b377d72cdc6e0c90f6e0f47e618812
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Thu May 04 16:06:19 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/5b9ef64d95b377d72cdc6e0c90f6e0f47e618812 [^]

Fixes issue 35871: Product Movement Report collapse the system

The data in report was limit to the LimitsReports preference value and a warning
is shown to inform that data is being limited.

---
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.java
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement_data.xsql
---
(0096414)
hgbot (developer)
2017-05-05 11:21

Repository: erp/devel/pi
Changeset: a624ea46456d49bb1f431b438e5591b6c3c926ab
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri May 05 09:50:29 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a624ea46456d49bb1f431b438e5591b6c3c926ab [^]

Related to issue 35871: Code review improvements

Don't read ReportsLimit preference when opening the report but just when running it.
Fix select query when running it in Oracle.

---
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.java
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement_data.xsql
---
(0096415)
aferraz (manager)
2017-05-05 11:24

Code review + Testing OK
(0096947)
hudsonbot (developer)
2017-05-29 17:43

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/1ee70113bdc4 [^]
Maturity status: Test
(0096948)
hudsonbot (developer)
2017-05-29 17:43

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/1ee70113bdc4 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2017-04-27 17:50 egoitz New Issue
2017-04-27 17:50 egoitz Assigned To => Triage Finance
2017-04-27 17:50 egoitz Modules => Core
2017-04-27 17:50 egoitz Resolution time => 1495058400
2017-04-27 17:50 egoitz Triggers an Emergency Pack => No
2017-04-27 17:50 egoitz Relationship added related to 0034620
2017-05-04 16:25 aferraz Assigned To Triage Finance => collazoandy4
2017-05-04 19:31 collazoandy4 Status new => scheduled
2017-05-04 22:19 collazoandy4 Note Added: 0096404
2017-05-05 11:20 hgbot Checkin
2017-05-05 11:20 hgbot Note Added: 0096413
2017-05-05 11:20 hgbot Status scheduled => resolved
2017-05-05 11:20 hgbot Resolution open => fixed
2017-05-05 11:20 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5b9ef64d95b377d72cdc6e0c90f6e0f47e618812 [^]
2017-05-05 11:21 hgbot Checkin
2017-05-05 11:21 hgbot Note Added: 0096414
2017-05-05 11:24 aferraz Review Assigned To => aferraz
2017-05-05 11:24 aferraz Note Added: 0096415
2017-05-05 11:24 aferraz Status resolved => closed
2017-05-05 11:24 aferraz Fixed in Version => 3.0PR17Q3
2017-05-29 17:43 hudsonbot Checkin
2017-05-29 17:43 hudsonbot Note Added: 0096947
2017-05-29 17:43 hudsonbot Checkin
2017-05-29 17:43 hudsonbot Note Added: 0096948


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker