Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035531
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Payment Aging Balance Reportmajoralways2017-03-15 13:022017-04-12 10:25
ReporteregoitzView Statuspublic 
Assigned Tomarkmm82 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision230dcdc8045c
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
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

DescriptionAfter 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 SolutionAdd pagination on both receivables and payable aging scheduling reports.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0034620 closedrqueralta Openbravo ERP The ReportWarehouseControl report collapse the system 
related to design defect 0025186 closedcollazoandy4 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 closedmarkmm82 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 closedmarkmm82 Modules Performance problems in Aging reports returning "multiple" instead of "scrollable" queries. 

-  Notes
(0095796)
aferraz (manager)
2017-04-03 12:16

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 (developer)
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.

(0095853)
markmm82 (developer)
2017-04-05 17:21

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 (developer)
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 (developer)
2017-04-12 10:25

Repository: erp/mods/org.openbravo.agingbalance
Changeset: e3094d5baac65aad3fe3819e4e8e20fb74175937
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Apr 12 10:06:31 2017 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/e3094d5baac65aad3fe3819e4e8e20fb74175937 [^]

Related to issue 35531: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0096002)
aferraz (manager)
2017-04-12 10:25

Code review + Testing OK

- 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 View Revisions
2017-04-05 17:21 markmm82 Note Added: 0095853
2017-04-05 17:22 markmm82 Note Edited: 0095838 View Revisions
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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker