Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029647Openbravo ERP09. Financial managementpublic2015-04-21 11:012015-05-27 00:39
ReporterioritzCia 
Assigned Toeduardo_Argal 
PriorityhighSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS30OS VersionUbuntu 14.04
Product Version3.0PR15Q1 
Target Version3.0PR15Q3Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029647: Trial Balance Report is sometimes really slow
DescriptionThere is sometimes where the trial balance report takes more than two minutes to execute.

You can find attached two times that happened in the log with the parameters used. It is not strange to find this query in the log taking more than 2 minutes.

We have a clone of the instance.
Steps To ReproduceExecute the query with similar parameters in the clone instance.
Proposed Solution
Additional Information
TagsPerformance
Relationships
Attached Fileslog TrialBalance.log (15,185) 2015-04-21 11:01
https://issues.openbravo.com/file_download.php?file_id=8012&type=bug
Issue History
Date ModifiedUsernameFieldChange
2015-04-21 11:01ioritzCiaNew Issue
2015-04-21 11:01ioritzCiaAssigned To => Triage Finance
2015-04-21 11:01ioritzCiaFile Added: TrialBalance.log
2015-04-21 11:01ioritzCiaWeb browser => Google Chrome
2015-04-21 11:01ioritzCiaModules => Core
2015-04-21 11:01ioritzCiaTriggers an Emergency Pack => No
2015-04-21 11:05ioritzCiaTag Attached: Performance
2015-04-22 10:19jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2015-04-22 10:19jonalegriaesarteResolution time => 1432072800
2015-04-22 10:19jonalegriaesarteTarget Version => 3.0PR15Q3
2015-04-28 15:53shuehnerIssue Monitored: shuehner
2015-05-04 19:12ngarciaIssue Monitored: ngarcia
2015-05-14 11:51eduardo_ArgalAssigned ToTriage Finance => eduardo_Argal
2015-05-14 11:51eduardo_ArgalStatusnew => scheduled
2015-05-26 10:19hgbotCheckin
2015-05-26 10:19hgbotNote Added: 0077744
2015-05-26 10:19hgbotStatusscheduled => resolved
2015-05-26 10:19hgbotResolutionopen => fixed
2015-05-26 10:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c1e975b2a1cb3dbe10a016bfa30ab01b1271ef56 [^]
2015-05-26 10:19vmromanosReview Assigned To => vmromanos
2015-05-26 10:19vmromanosNote Added: 0077745
2015-05-26 10:19vmromanosStatusresolved => closed
2015-05-27 00:39hudsonbotCheckin
2015-05-27 00:39hudsonbotNote Added: 0077778

Notes
(0077744)
hgbot   
2015-05-26 10:19   
Repository: erp/devel/pi
Changeset: c1e975b2a1cb3dbe10a016bfa30ab01b1271ef56
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu May 14 20:09:22 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c1e975b2a1cb3dbe10a016bfa30ab01b1271ef56 [^]

Fixes issue 29647: Trial Balance Report is sometimes really slow Query refactored to improve performance

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0077745)
vmromanos   
2015-05-26 10:19   
Code review + testing OK
(0077778)
hudsonbot   
2015-05-27 00:39   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/2ac0a8fe23d2 [^]
Maturity status: Test