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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035563
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 09. Financial managementmajorhave not tried2017-03-17 16:412017-04-18 09:45
ReporteregoitzView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035563: Trial Balance report takes long to be printed on xls.

DescriptionThe Trial Balance report takes few minutes to be printed on envirionment with big amount of data even when printing only 1 month.
Steps To Reproduce-Execute the trial report balance in excel on an environment with big amount of data.
It takes more than 10 minutes to print 1 month of data.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate design defect 0031740 newdmiguelez Report trial balance report is slow with high number of transactions 
related to design defect 0036070 acknowledgedTriage Finance Performance problems on the journal entries report. 

-  Notes
(0096048)
vmromanos (developer)
2017-04-18 09:45

Moved to design defect.

Problem is to calculate the initial balance, which requires a seq. scan over the fact_acct table to get data from the very beginning to the first date in range.

We have tried a query redesign with some new indexes and the performance is improved but not enough to assume the risk for the fix.

This issue requires a full refactor in trial balance, using aggregated data to easily get the initial balance, as explained in 0031740

- Issue History
Date Modified Username Field Change
2017-03-17 16:41 egoitz New Issue
2017-03-17 16:41 egoitz Assigned To => Triage Finance
2017-03-17 16:41 egoitz Modules => Core
2017-03-17 16:41 egoitz Triggers an Emergency Pack => No
2017-03-20 19:25 markmm82 Assigned To Triage Finance => AtulOpenbravo
2017-03-27 10:12 vmromanos Assigned To AtulOpenbravo => vmromanos
2017-03-27 10:12 vmromanos Status new => acknowledged
2017-04-18 09:45 vmromanos Note Added: 0096048
2017-04-18 09:45 vmromanos Type defect => design defect
2017-04-18 09:45 vmromanos Relationship added has duplicate 0031740
2017-06-02 12:39 aferraz Relationship added related to 0036070


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker