Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032406ModulesPayment Aging Balance Reportpublic2016-03-04 09:552016-05-04 18:52
Reporteryogaskarnik 
Assigned Tovmromanos 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Todmiguelez
Support ticket
OBNetwork customer
Regression introduced in release
Summary0032406: Aging Reports causing tomcat to crash
DescriptionAging Reports causing tomcat to crash in customers environment
Steps To ReproduceSteps to reproduce in customers environment:

1. login to ERP
2. Navigate to Application > Financial Management > Receivables and Payables > Analysis Tools > Receivables Aging Report / Payables Aging Report
3. Enter the mandatory fields
4. Press the Search button and the tomcat crashes

Note: contact support for customers environment access

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0024343 new AugustoMauch Openbravo ERP High volume of data selected in a business partner selector blocks the Browser 
blocks defect 0032174 closed markmm82 Openbravo ERP PDF Format of Receivables Aging Schedule showing details and doubtful debts crashes 
causes defect 0033278 closed markmm82 Modules To show "Supplier reference" functionality (if configured) has been lost during report's refactor 
Attached Filesdiff againg_refactor_draft.diff (45,739) 2016-04-07 12:12
https://issues.openbravo.com/file_download.php?file_id=9245&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-03-04 09:55yogaskarnikNew Issue
2016-03-04 09:55yogaskarnikAssigned To => Triage Finance
2016-03-04 09:55yogaskarnikModules => Core
2016-03-04 09:55yogaskarnikResolution time => 1459893600
2016-03-04 09:55yogaskarnikTriggers an Emergency Pack => No
2016-03-04 09:57yogaskarnikSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=11350#r11350
2016-04-05 12:08aferrazAssigned ToTriage Finance => AtulOpenbravo
2016-04-06 11:18aferrazAssigned ToAtulOpenbravo => vmromanos
2016-04-06 11:18aferrazTypedefect => design defect
2016-04-06 11:19aferrazNote Added: 0085464
2016-04-06 11:20vmromanosProjectOpenbravo ERP => Modules
2016-04-06 11:21vmromanosCategory09. Financial management => Payment Aging Balance Report
2016-04-07 12:12vmromanosFile Added: againg_refactor_draft.diff
2016-04-07 12:12vmromanosStatusnew => acknowledged
2016-04-20 10:12egoitzRelationship addedrelated to 0024343
2016-04-20 10:12egoitzRelationship addedblocks 0032174
2016-05-04 18:51hgbotCheckin
2016-05-04 18:51hgbotNote Added: 0086188
2016-05-04 18:51hgbotStatusacknowledged => resolved
2016-05-04 18:51hgbotResolutionopen => fixed
2016-05-04 18:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/f23883edecf463326bbea99872df577cf0f401e3 [^]
2016-05-04 18:52dmiguelezReview Assigned To => dmiguelez
2016-05-04 18:52dmiguelezNote Added: 0086189
2016-05-04 18:52dmiguelezStatusresolved => closed
2016-06-15 18:09aferrazRelationship addedcauses 0033278

Notes
(0085464)
aferraz   
2016-04-06 11:19   
We are currently working on it
(0086188)
hgbot   
2016-05-04 18:51   
Repository: erp/mods/org.openbravo.agingbalance
Changeset: f23883edecf463326bbea99872df577cf0f401e3
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed May 04 17:58:24 2016 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/f23883edecf463326bbea99872df577cf0f401e3 [^]

Fixes Issue 32406. Refactor to improve performance

Replaced HQL queries by complex SQL queries that return the data almost already processed.
Created some SQL functions to directly process the currency conversion and doubtful debt stuff directly in SQL instead of Java.
That might increase the time to run the query, but on the other hand it drastically reduces the number of records to be processed in Java and thus the time to process.
In several high volume instances, the time to get the report has been reduced by more than a third part.

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/agingbalance/ad_reports/AgingDao.java
M src/org/openbravo/agingbalance/ad_reports/AgingData.java
M src/org/openbravo/agingbalance/ad_reports/AgingProcess.java
A src-db/database/model/functions/AGING_INVOICECURRENCY_RATE.xml
A src-db/database/model/functions/AGING_ISDOUBTFULTDEBT.xml
A src-db/database/model/functions/AGING_PAYMENTCURRENCY_RATE.xml
A src-db/database/model/modifiedTables/FIN_DOUBTFUL_DEBT.xml
A src/org/openbravo/agingbalance/ad_reports/AgingDao_data.xsql
---
(0086189)
dmiguelez   
2016-05-04 18:52   
Code Review + Testing Ok