Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035563Openbravo ERP09. Financial managementpublic2017-03-17 16:412017-04-18 09:45
Reporteregoitz 
Assigned Tovmromanos 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket45781
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035563: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate design defect 0031740 new dmiguelez Report trial balance report is slow with high number of transactions 
related to design defect 0036070 acknowledged Triage Omni OMS Performance problems on the journal entries report. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-03-17 16:41egoitzNew Issue
2017-03-17 16:41egoitzAssigned To => Triage Finance
2017-03-17 16:41egoitzOBNetwork customer => Yes
2017-03-17 16:41egoitzModules => Core
2017-03-17 16:41egoitzSupport ticket => 45781
2017-03-17 16:41egoitzResolution time => 1491516000
2017-03-17 16:41egoitzTriggers an Emergency Pack => No
2017-03-20 19:25markmm82Assigned ToTriage Finance => AtulOpenbravo
2017-03-27 10:12vmromanosAssigned ToAtulOpenbravo => vmromanos
2017-03-27 10:12vmromanosStatusnew => acknowledged
2017-04-18 09:45vmromanosResolution time1491516000 =>
2017-04-18 09:45vmromanosNote Added: 0096048
2017-04-18 09:45vmromanosTypedefect => design defect
2017-04-18 09:45vmromanosRelationship addedhas duplicate 0031740
2017-06-02 12:39aferrazRelationship addedrelated to 0036070

Notes
(0096048)
vmromanos   
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