Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026701ModulesPayment Reportpublic2014-05-27 10:042014-08-08 18:53
Reporteregoitz 
Assigned Torafaroda 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toshuehner
Support ticket
OBNetwork customer
Regression introduced in release
Summary0026701: High memory usage when executing the payment report
DescriptionHigh memory usage when executing the payment report.
This produces a high usage of the garbage collector and bad performance of the application while the report is executed.

Steps To ReproduceExecute the payment report on an environment with a big amount of data for a big time interval
Proposed SolutionChange the execution of the queries and criterias to use scrollableresults instead of .list method.

http://wiki.openbravo.com/wiki/Data_Access_Layer_Performance#Mass_read.2C_clearing_the_session [^]
Additional Information
TagsPerformance
Relationships
has duplicate design defect 0024967 closed jecharri Openbravo ERP Payment Report has performance problems 
related to defect 0035872 closed markmm82 Openbravo ERP Payment Report has performance problems if expiration date is not set 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-05-27 10:04egoitzNew Issue
2014-05-27 10:04egoitzAssigned To => mirurita
2014-05-27 10:04egoitzResolution time => 1401746400
2014-05-27 10:06jonalegriaesarteAssigned Tomirurita => pramakrishnan
2014-05-27 10:17egoitzProposed Solution updated
2014-05-27 11:11shuehnerIssue Monitored: shuehner
2014-05-27 11:38shuehnerTag Attached: Performance
2014-05-29 11:43rafarodaAssigned Topramakrishnan => rafaroda
2014-05-29 11:43rafarodaStatusnew => scheduled
2014-06-16 10:06rafarodaNote Added: 0068047
2014-07-11 12:57dmitry_mezentsevRelationship addedhas duplicate 0024967
2014-07-16 19:41hgbotCheckin
2014-07-16 19:41hgbotNote Added: 0068684
2014-07-16 19:41hgbotStatusscheduled => resolved
2014-07-16 19:41hgbotResolutionopen => fixed
2014-07-16 19:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7079b464de921b9d5774b11175e7b13f77f262b6 [^]
2014-07-16 20:31shuehnerReview Assigned To => shuehner
2014-07-16 20:31shuehnerNote Added: 0068685
2014-07-16 20:31shuehnerStatusresolved => closed
2014-08-08 18:53hudsonbotCheckin
2014-08-08 18:53hudsonbotNote Added: 0069176
2017-05-03 12:47aferrazRelationship addedrelated to 0035872

Notes
(0068047)
rafaroda   
2014-06-16 10:06   
When fixing don't overwrite fix for issue https://issues.openbravo.com/view.php?id=26574 [^]
(0068684)
hgbot   
2014-07-16 19:41   
Repository: erp/devel/pi
Changeset: 7079b464de921b9d5774b11175e7b13f77f262b6
Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com>
Date: Wed Jul 16 19:40:47 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7079b464de921b9d5774b11175e7b13f77f262b6 [^]

Fixes issue 26701 Rebuild of Payment Report for improving performance

---
M modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MESSAGE.xml
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReport.java
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
---
(0068685)
shuehner   
2014-07-16 20:31   
Closing: Review was splitted and done earlier between rafa & me already and code is running already for quite a while in a production env.
(0069176)
hudsonbot   
2014-08-08 18:53   
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/4450016dee64 [^]
Maturity status: Test