Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030694Openbravo ERP09. Financial managementpublic2015-08-28 12:532015-09-30 16:35
Reporteregoitz 
Assigned ToAtulOpenbravo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket38059
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030694: 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
TagsNo tags attached.
Relationships
related to design defect 0024430 closed eduardo_Argal Openbravo ERP The ReportGeneralLedger report take long to be printed with big amount of data and consumes a lot of resources 
depends on backport 00309923.0PR15Q3.2 closed AtulOpenbravo Openbravo ERP The ReportInvoiceDiscountJR report consume many resources when printing big amount of data. 
related to defect 0031170 closed vmromanos Modules The legacy module depends on a previous release of import data module 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-08-28 12:53egoitzNew Issue
2015-08-28 12:53egoitzAssigned To => Triage Finance
2015-08-28 12:53egoitzOBNetwork customer => Yes
2015-08-28 12:53egoitzModules => Core
2015-08-28 12:53egoitzSupport ticket => 38059
2015-08-28 12:53egoitzResolution time => 1440972000
2015-08-28 12:53egoitzTriggers an Emergency Pack => No
2015-08-28 12:53egoitzRelationship addedrelated to 0024430
2015-08-31 11:37AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2015-09-01 07:38AtulOpenbravoStatusnew => scheduled
2015-09-01 07:47AtulOpenbravoNote Added: 0079985
2015-09-02 16:53hgbotCheckin
2015-09-02 16:53hgbotNote Added: 0080024
2015-09-02 16:53hgbotStatusscheduled => resolved
2015-09-02 16:53hgbotResolutionopen => fixed
2015-09-02 16:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/02af2e9e4fd936f56595e463855d8076747066c6 [^]
2015-09-02 16:53dmiguelezReview Assigned To => dmiguelez
2015-09-02 16:53dmiguelezNote Added: 0080025
2015-09-02 16:53dmiguelezStatusresolved => closed
2015-09-03 23:47hudsonbotCheckin
2015-09-03 23:47hudsonbotNote Added: 0080061
2015-09-30 16:34vmromanosNote Added: 0080755
2015-09-30 16:34vmromanosStatusclosed => new
2015-09-30 16:34vmromanosResolutionfixed => open
2015-09-30 16:34vmromanosStatusnew => scheduled
2015-09-30 16:35vmromanosStatusscheduled => resolved
2015-09-30 16:35vmromanosResolutionopen => fixed
2015-09-30 16:35vmromanosStatusresolved => closed
2015-11-19 17:16vmromanosRelationship addedrelated to 0031170

Notes
(0079985)
AtulOpenbravo   
2015-09-01 07:47   
Test Plan
- Execute the Discount Invoice Report for Start Date: 01/01/2012, End date: Today
(0080024)
hgbot   
2015-09-02 16:53   
Repository: erp/devel/pi
Changeset: 02af2e9e4fd936f56595e463855d8076747066c6
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Sep 01 08:41:30 2015 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/02af2e9e4fd936f56595e463855d8076747066c6 [^]

Fixes Issue 30694: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
---
(0080025)
dmiguelez   
2015-09-02 16:53   
Code Review + Testing Ok
(0080061)
hudsonbot   
2015-09-03 23:47   
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/772e57843a9e [^]
Maturity status: Test
(0080755)
vmromanos   
2015-09-30 16:34   
Set to new again to schedule the backport