Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035871 | Openbravo ERP | 04. Warehouse management | public | 2017-04-27 17:50 | 2017-05-29 17:43 |
|
| Reporter | egoitz | |
| Assigned To | collazoandy4 | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q3 | |
| Merge Request Status | |
| Review Assigned To | aferraz |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 46485 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0035871: The product movement report collapses the system when there are thousands of result to be shown |
| Description | The product movement report consumes a lot of memory when there are thousands of results.
The number of rows shown should be limited. |
| Steps To Reproduce | Execute the report on an environment with thousands of product movements. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | design defect | 0034620 | | closed | rqueralta | The ReportWarehouseControl report collapse the system |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-04-27 17:50 | egoitz | New Issue | |
| 2017-04-27 17:50 | egoitz | Assigned To | => Triage Finance |
| 2017-04-27 17:50 | egoitz | OBNetwork customer | => Yes |
| 2017-04-27 17:50 | egoitz | Modules | => Core |
| 2017-04-27 17:50 | egoitz | Support ticket | => 46485 |
| 2017-04-27 17:50 | egoitz | Resolution time | => 1495058400 |
| 2017-04-27 17:50 | egoitz | Triggers an Emergency Pack | => No |
| 2017-04-27 17:50 | egoitz | Relationship added | related to 0034620 |
| 2017-05-04 16:25 | aferraz | Assigned To | Triage Finance => collazoandy4 |
| 2017-05-04 19:31 | collazoandy4 | Status | new => scheduled |
| 2017-05-04 22:19 | collazoandy4 | Note Added: 0096404 | |
| 2017-05-05 11:20 | hgbot | Checkin | |
| 2017-05-05 11:20 | hgbot | Note Added: 0096413 | |
| 2017-05-05 11:20 | hgbot | Status | scheduled => resolved |
| 2017-05-05 11:20 | hgbot | Resolution | open => fixed |
| 2017-05-05 11:20 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/5b9ef64d95b377d72cdc6e0c90f6e0f47e618812 [^] |
| 2017-05-05 11:21 | hgbot | Checkin | |
| 2017-05-05 11:21 | hgbot | Note Added: 0096414 | |
| 2017-05-05 11:24 | aferraz | Review Assigned To | => aferraz |
| 2017-05-05 11:24 | aferraz | Note Added: 0096415 | |
| 2017-05-05 11:24 | aferraz | Status | resolved => closed |
| 2017-05-05 11:24 | aferraz | Fixed in Version | => 3.0PR17Q3 |
| 2017-05-29 17:43 | hudsonbot | Checkin | |
| 2017-05-29 17:43 | hudsonbot | Note Added: 0096947 | |
| 2017-05-29 17:43 | hudsonbot | Checkin | |
| 2017-05-29 17:43 | hudsonbot | Note Added: 0096948 | |
|
Notes |
|
|
(0096404)
|
|
collazoandy4
|
|
2017-05-04 22:19
|
|
Test Plan
As System admin:
Edit the Forms Limit preference value to 10
Log out and Log in
As group admin role:
Go to Product Movement Report window:
From Date: 01-01-2015
To Date: 01-01-2017
Clic on HTML Format button and realize a warning message is shown |
|
|
|
(0096413)
|
|
hgbot
|
|
2017-05-05 11:20
|
|
Repository: erp/devel/pi
Changeset: 5b9ef64d95b377d72cdc6e0c90f6e0f47e618812
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Thu May 04 16:06:19 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/5b9ef64d95b377d72cdc6e0c90f6e0f47e618812 [^]
Fixes issue 35871: Product Movement Report collapse the system
The data in report was limit to the LimitsReports preference value and a warning
is shown to inform that data is being limited.
---
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.java
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement_data.xsql
---
|
|
|
|
(0096414)
|
|
hgbot
|
|
2017-05-05 11:21
|
|
Repository: erp/devel/pi
Changeset: a624ea46456d49bb1f431b438e5591b6c3c926ab
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri May 05 09:50:29 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a624ea46456d49bb1f431b438e5591b6c3c926ab [^]
Related to issue 35871: Code review improvements
Don't read ReportsLimit preference when opening the report but just when running it.
Fix select query when running it in Oracle.
---
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.java
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement_data.xsql
---
|
|
|
|
|
|
|
|
|
|
|
|
|
|