Openbravo Issue Tracking System - Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035531 | Modules | Payment Aging Balance Report | public | 2017-03-15 13:02 | 2017-04-12 10:25 |
|
| Reporter | egoitz | |
| Assigned To | markmm82 | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | aferraz |
| Support ticket | |
| OBNetwork customer | |
| Regression introduced in release | |
|
| Summary | 0035531: The browswer get stucked when printing the receivable aging schedule report showing details and having a lot of invoices pending |
| Description | After print the receivable aging schedule report on an environment with a lot of invoices pending to be paid, the browser get stucked.
The report takes more than 1 minute to be printed. Most of the time is consumed by chrome rendering the server response.
Once the tab is shown, if you try to go back to the filtering tab the chrome get stucked and it takes long to navigate to the tab.
|
| Steps To Reproduce | -Select and organization and a date where there are many invoices for many partners pending to be paid.
-Print the report in html.
-ONce the report is printed try to move to the previous tab.
*Chrome start consuming resources and an warning message is shown to kill the process or wait.
If you wait after some time (2 minutes) the new tab is opened. |
| Proposed Solution | Add pagination on both receivables and payable aging scheduling reports. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | design defect | 0034620 | | closed | rqueralta | Openbravo ERP | The ReportWarehouseControl report collapse the system | | related to | design defect | 0025186 | | closed | collazoandy4 | Openbravo ERP | Jave heap error accessing to the pending goods receipt window when there are 16000 lines for orders not receipt | | related to | defect | 0035764 | | closed | markmm82 | Openbravo ERP | The browswer get stucked when printing the receivable aging schedule report showing details and having a lot of invoices pending | | causes | defect | 0036173 | | closed | markmm82 | Modules | Performance problems in Aging reports returning "multiple" instead of "scrollable" queries. |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-03-15 13:02 | egoitz | New Issue | |
| 2017-03-15 13:02 | egoitz | Assigned To | => Triage Finance |
| 2017-03-15 13:02 | egoitz | Modules | => Core |
| 2017-03-15 13:02 | egoitz | Resolution time | => 1490738400 |
| 2017-03-15 13:02 | egoitz | Triggers an Emergency Pack | => No |
| 2017-03-31 12:15 | egoitz | Resolution time | 1490738400 => 1491775200 |
| 2017-03-31 12:25 | aferraz | Assigned To | Triage Finance => markmm82 |
| 2017-03-31 16:13 | markmm82 | Status | new => acknowledged |
| 2017-04-03 12:16 | aferraz | Note Added: 0095796 | |
| 2017-04-03 12:16 | aferraz | Relationship added | related to 0034620 |
| 2017-04-03 12:18 | aferraz | Relationship added | related to 0025186 |
| 2017-04-03 18:10 | markmm82 | Status | acknowledged => scheduled |
| 2017-04-04 22:40 | markmm82 | Note Added: 0095838 | |
| 2017-04-04 22:44 | markmm82 | Note Edited: 0095838 | bug_revision_view_page.php?bugnote_id=0095838#r14951 |
| 2017-04-05 17:21 | markmm82 | Note Added: 0095853 | |
| 2017-04-05 17:22 | markmm82 | Note Edited: 0095838 | bug_revision_view_page.php?bugnote_id=0095838#r14962 |
| 2017-04-11 17:06 | aferraz | Project | Openbravo ERP => Modules |
| 2017-04-11 17:08 | aferraz | Category | 07. Sales management => Payment Aging Balance Report |
| 2017-04-12 10:21 | hgbot | Checkin | |
| 2017-04-12 10:21 | hgbot | Note Added: 0095999 | |
| 2017-04-12 10:21 | hgbot | Status | scheduled => resolved |
| 2017-04-12 10:21 | hgbot | Resolution | open => fixed |
| 2017-04-12 10:21 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/230dcdc8045ca7643abe8a45fbaa2a2d4c58bada [^] |
| 2017-04-12 10:21 | aferraz | Note Added: 0096000 | |
| 2017-04-12 10:22 | aferraz | Note Deleted: 0096000 | |
| 2017-04-12 10:24 | aferraz | Relationship added | related to 0035764 |
| 2017-04-12 10:25 | hgbot | Checkin | |
| 2017-04-12 10:25 | hgbot | Note Added: 0096001 | |
| 2017-04-12 10:25 | aferraz | Review Assigned To | => aferraz |
| 2017-04-12 10:25 | aferraz | Note Added: 0096002 | |
| 2017-04-12 10:25 | aferraz | Status | resolved => closed |
| 2017-06-05 09:53 | aferraz | Relationship added | causes 0036173 |
|
Notes |
|
|
|
|
In order to reduce the memory usage, we should limit displayed data with the value of a preference. A warning should inform that data is being limited. |
|
|
|
(0095838)
|
|
markmm82
|
2017-04-04 22:40
(edited on: 2017-04-05 17:22) |
|
Test Plan 1:
As System Admin
- Go to Preference window
Edit "ReportLimit" preference and set "Value"=1
As F&B International Group Admin
- Go to Receivables Aging Schedule report window
Set F&B España, S.A org and "From Date"=04-04-2016 and click in HTML Format buttom
Check that a warning message is shown in both windows: showing selected filters and results:
"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 2. Please, use more selective filtering criteria and execute the report again."
Repeat the same steps but checking "Show details" option and notice the message is shown too.
|
|
|
|
|
Test Plan 2:
As System Admin
- Go to Preference window
Edit "ReportLimit" preference and set "Value"=1
As F&B International Group Admin
- Go to Payables Aging Schedule report window
Set F&B España, S.A org and "From Date"=04-04-2016 and click in HTML Format buttom
Check that a warning message is shown in both windows: showing selected filters and results:
"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 2. Please, use more selective filtering criteria and execute the report again."
Repeat the same steps but checking "Show details" option and notice the message is shown too. |
|
|
|
(0095999)
|
|
hgbot
|
|
2017-04-12 10:21
|
|
Repository: erp/mods/org.openbravo.agingbalance
Changeset: 230dcdc8045ca7643abe8a45fbaa2a2d4c58bada
Author: Mark <markmm82 <at> gmail.com>
Date: Fri Apr 07 20:27:08 2017 -0400
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/230dcdc8045ca7643abe8a45fbaa2a2d4c58bada [^]
Fixes issue 35531: Limit displayed data printing aging schedule reports
After printing the receivable/payable aging schedule report on an environment
with a lot of invoices pending to be paid, the report takes too long to be printed.
Most of the time was consumed by chrome rendering the server response.
In order to reduce the memory usage, was limited the displayed data with the value
of the "ReportsLimit" preference.
When record count exceeds this limit, is shown a warning informing that data is being
limited. As problem happens when the report runs in HTML format, data only will be
limited in this case and not when report runs in PDF or XLS formats.
To achieve this functionality the following changes were done:
-Adapted AgingDao_data and AgingDao to make possible to limit queries to PG and
Oracle databases.
-Adapted AgingProcess to limit data if report is created in
HTML format. If the data is limited it is stored as a session variable to make
it available to AgingDao methods. Then a warning message will be shown in the
affected reports if the limit is reached.
-Added a new "warning" parameter to AgingScheduleDetailHTML and AgingScheduleHTML
reports. It is linked to a hidden text that only will be displayed if the maximum
of records count defined in the preference to reports is reached.
---
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/agingbalance/ad_reports/AgingDao.java
M src/org/openbravo/agingbalance/ad_reports/AgingDao_data.xsql
M src/org/openbravo/agingbalance/ad_reports/AgingProcess.java
M src/org/openbravo/agingbalance/ad_reports/AgingScheduleDetailHTML.jrxml
M src/org/openbravo/agingbalance/ad_reports/AgingScheduleHTML.jrxml
---
|
|
|
|
(0096001)
|
|
hgbot
|
|
2017-04-12 10:25
|
|
|
|
|
|
|