Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030992Openbravo ERP09. Financial managementpublic2015-08-28 12:532015-09-30 16:37
Reporteregoitz 
Assigned ToAtulOpenbravo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q3.2Fixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030992: 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
Additional Information
TagsApproved
Relationships
blocks defect 0030694 closed AtulOpenbravo The ReportInvoiceDiscountJR report consume many resources when printing big amount of data. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-09-30 16:34vmromanosTypedefect => backport
2015-09-30 16:34vmromanosTarget Version => 3.0PR15Q3.2
2015-09-30 16:36vmromanosTag Attached: Approved
2015-09-30 16:36hgbotCheckin
2015-09-30 16:36hgbotNote Added: 0080756
2015-09-30 16:36hgbotStatusscheduled => resolved
2015-09-30 16:36hgbotResolutionopen => fixed
2015-09-30 16:36hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/02af2e9e4fd936f56595e463855d8076747066c6 [^] => http://code.openbravo.com/erp/backports/3.0PR15Q3.2/rev/775d878816b2e480461422dd51633dee3dd0491b [^]
2015-09-30 16:37vmromanosStatusresolved => closed

Notes
(0080756)
hgbot   
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
---