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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0030992
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2015-08-28 12:532015-09-30 16:37
ReporteregoitzView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision775d878816b2
ProjectionnoneETAnoneTarget Version3.0PR15Q3.2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0030992: The ReportInvoiceDiscountJR report consume many resources when printing big amount of data.

DescriptionWhen executing the report for a period of time where a big amount of data is printed, the report takes long to finish, but could cause also the server to crash due to the high memory usage.
Steps To Reproduce-Execute the report for a period of time where big amount of data is managed by the report
Proposed SolutionUse scrollable results on the _xsql file.
http://wiki.openbravo.com/wiki/SQLC#Scrollable_Queries_.28memory-efficient.29 [^]
24430
TagsApproved
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0030694 closedAtulOpenbravo The ReportInvoiceDiscountJR report consume many resources when printing big amount of data. 

-  Notes
(0080756)
hgbot (developer)
2015-09-30 16:36

 Repository: erp/backports/3.0PR15Q3.2
Changeset: 775d878816b2e480461422dd51633dee3dd0491b
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Sep 01 08:41:30 2015 +0530
URL: http://code.openbravo.com/erp/backports/3.0PR15Q3.2/rev/775d878816b2e480461422dd51633dee3dd0491b [^]

Fixes Issue 30992:The ReportInvoiceDiscountJR report consume many resources
when printing big amount of data.

Scrollable xsql is used to enhance report performance.

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscount_data.xsql
---

- Issue History
Date Modified Username Field Change
2015-09-30 16:34 vmromanos Type defect => backport
2015-09-30 16:34 vmromanos Target Version => 3.0PR15Q3.2
2015-09-30 16:36 vmromanos Tag Attached: Approved
2015-09-30 16:36 hgbot Checkin
2015-09-30 16:36 hgbot Note Added: 0080756
2015-09-30 16:36 hgbot Status scheduled => resolved
2015-09-30 16:36 hgbot Resolution open => fixed
2015-09-30 16:36 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/02af2e9e4fd936f56595e463855d8076747066c6 [^] => http://code.openbravo.com/erp/backports/3.0PR15Q3.2/rev/775d878816b2e480461422dd51633dee3dd0491b [^]
2015-09-30 16:37 vmromanos Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker