Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0026701 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Payment Report | major | have not tried | 2014-05-27 10:04 | 2014-08-08 18:53 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 7079b464de92 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | shuehner | |||||||
| Regression introduced in release | ||||||||
| Summary | 0026701: High memory usage when executing the payment report | |||||||
| Description | High 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 Reproduce | Execute the payment report on an environment with a big amount of data for a big time interval | |||||||
| Proposed Solution | Change 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 [^] | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||
|
|||||||||||||||||
 Relationships |
|
Notes |
|
|
(0068047) rafaroda (manager) 2014-06-16 10:06 |
When fixing don't overwrite fix for issue https://issues.openbravo.com/view.php?id=26574 [^] |
|
(0068684) hgbot (developer) 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 (administrator) 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 (developer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-05-27 10:04 | egoitz | New Issue | |
| 2014-05-27 10:04 | egoitz | Assigned To | => mirurita |
| 2014-05-27 10:04 | egoitz | Resolution time | => 1401746400 |
| 2014-05-27 10:06 | jonalegriaesarte | Assigned To | mirurita => pramakrishnan |
| 2014-05-27 10:17 | egoitz | Proposed Solution updated | |
| 2014-05-27 11:11 | shuehner | Issue Monitored: shuehner | |
| 2014-05-27 11:38 | shuehner | Tag Attached: Performance | |
| 2014-05-29 11:43 | rafaroda | Assigned To | pramakrishnan => rafaroda |
| 2014-05-29 11:43 | rafaroda | Status | new => scheduled |
| 2014-06-16 10:06 | rafaroda | Note Added: 0068047 | |
| 2014-07-11 12:57 | dmitry_mezentsev | Relationship added | has duplicate 0024967 |
| 2014-07-16 19:41 | hgbot | Checkin | |
| 2014-07-16 19:41 | hgbot | Note Added: 0068684 | |
| 2014-07-16 19:41 | hgbot | Status | scheduled => resolved |
| 2014-07-16 19:41 | hgbot | Resolution | open => fixed |
| 2014-07-16 19:41 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/7079b464de921b9d5774b11175e7b13f77f262b6 [^] |
| 2014-07-16 20:31 | shuehner | Review Assigned To | => shuehner |
| 2014-07-16 20:31 | shuehner | Note Added: 0068685 | |
| 2014-07-16 20:31 | shuehner | Status | resolved => closed |
| 2014-08-08 18:53 | hudsonbot | Checkin | |
| 2014-08-08 18:53 | hudsonbot | Note Added: 0069176 | |
| 2017-05-03 12:47 | aferraz | Relationship added | related to 0035872 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |