Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0043738 | Openbravo ERP | 07. Sales management | public | 2020-04-15 10:48 | 2020-05-08 12:40 |
|
| Reporter | egoitz | |
| Assigned To | inigo_lerga | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | PR20Q3 | |
| Merge Request Status | |
| Review Assigned To | dmiguelez |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 15622 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0043738: Offers report can product a system crash due to OufOfMemory |
| Description | Executing the offers report on an environment with thousands of partners and hundreds of offers that applied to all the partners comsumes a lot of memory and end on an OutOfMemory error. |
| Steps To Reproduce | ON an environment with thousands of partners (26k) and many offers (100) that applies to all the partners. Defined as exclude partners selected and no one selected, execute the report for a date period that includes most of the offers.
-- The report is not shown and and OutOfMemory happens. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2020-04-15 10:48 | egoitz | New Issue | |
| 2020-04-15 10:48 | egoitz | Assigned To | => Triage Finance |
| 2020-04-15 10:48 | egoitz | OBNetwork customer | => OBPS |
| 2020-04-15 10:48 | egoitz | Modules | => Core |
| 2020-04-15 10:48 | egoitz | Resolution time | => 1589493600 |
| 2020-04-15 10:48 | egoitz | Triggers an Emergency Pack | => No |
| 2020-04-15 10:51 | Practics | Issue Monitored: Practics | |
| 2020-04-15 11:29 | ngarcia | Support ticket | => 15622 |
| 2020-05-04 08:50 | inigo_lerga | Assigned To | Triage Finance => inigo_lerga |
| 2020-05-04 08:50 | inigo_lerga | Status | new => scheduled |
| 2020-05-05 10:13 | inigo_lerga | Note Added: 0119548 | |
| 2020-05-08 12:38 | dmiguelez | Note Added: 0119692 | |
| 2020-05-08 12:39 | hgbot | Checkin | |
| 2020-05-08 12:39 | hgbot | Note Added: 0119693 | |
| 2020-05-08 12:39 | hgbot | Status | scheduled => resolved |
| 2020-05-08 12:39 | hgbot | Resolution | open => fixed |
| 2020-05-08 12:39 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/a6ee2cf16b1c7465c13d3d69a8a20b5d42c21241 [^] |
| 2020-05-08 12:40 | dmiguelez | Review Assigned To | => dmiguelez |
| 2020-05-08 12:40 | dmiguelez | Note Added: 0119694 | |
| 2020-05-08 12:40 | dmiguelez | Status | resolved => closed |
| 2020-05-08 12:40 | dmiguelez | Fixed in Version | => 3.0PR20Q3 |
|
Notes |
|
|
(0119548)
|
|
inigo_lerga
|
|
2020-05-05 10:13
|
|
--Test Plan Mantis--
As The White Valley Group Admin role:
- Go to the Offers Report window. Fill the desired fields and press the
HTML Format button.
#In this moment the modified code is executed. In case of having more
records than the amount the report is set to display, the warning message
will show up# |
|
|
|
|
Test Plan
With Retail modules installed, log in as The White Valley Group Admin role:
Go to Offers Report window and filter by:
* From Date: 10-05-2016
* To Date: Today
Click on the button and check that results are shown.
Log in as System Administrator
Go to Preference Window and filter by the Attribute 'ReportsLimit'
Change the value to 10
Log in as The White Valley Group Admin role:
Go to Offers Report window and filter by:
* From Date: 10-05-2016
* To Date: Today
Click on the button and check that no results are shown and there is a warning message: 'The filtering criteria you have specified for this report return a number of rows that exceeds the maximum allowed. The limit of rows to display in a report is 101. Please, use more selective filtering criteria and execute the report again.' |
|
|
|
(0119693)
|
|
hgbot
|
|
2020-05-08 12:39
|
|
Repository: erp/devel/pi
Changeset: a6ee2cf16b1c7465c13d3d69a8a20b5d42c21241
Author: Iñigo Lerga <inigo.lerga <at> openbravo.com>
Date: Tue May 05 10:37:06 2020 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a6ee2cf16b1c7465c13d3d69a8a20b5d42c21241 [^]
fixes BUG-43738:Warning added when report exceeds limit of records
---
M src/org/openbravo/erpCommon/ad_reports/ReportOffer.java
M src/org/openbravo/erpCommon/ad_reports/ReportOffer_data.xsql
---
|
|
|
|
|
|