Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0030992 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 09. Financial management | major | always | 2015-08-28 12:53 | 2015-09-30 16:37 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 775d878816b2 | ||||
| Projection | none | ETA | none | Target Version | 3.0PR15Q3.2 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | dmiguelez | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | 38059 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0030992: The ReportInvoiceDiscountJR report consume many resources when printing big amount of data. | |||||||
| Description | When 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 Solution | Use scrollable results on the _xsql file. http://wiki.openbravo.com/wiki/SQLC#Scrollable_Queries_.28memory-efficient.29 [^] 24430 | |||||||
| Tags | Approved | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
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 --- |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |