Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029647 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | sometimes | 2015-04-21 11:01 | 2015-05-27 00:39 | |||
| Reporter | ioritzCia | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | c1e975b2a1cb | ||||
| Projection | none | ETA | none | Target Version | 3.0PR15Q3 | |||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 6 | |||
| OS Version | Ubuntu 14.04 | Database version | 9.3 | Ant version | ||||
| Product Version | 3.0PR15Q1 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | vmromanos | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | Google Chrome | |||||||
| Modules | Core | |||||||
| Support ticket | 35761 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0029647: Trial Balance Report is sometimes really slow | |||||||
| Description | There 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 Reproduce | Execute the query with similar parameters in the clone instance. | |||||||
| Tags | Performance | |||||||
| Attached Files |  TrialBalance.log [^] (15,185 bytes) 2015-04-21 11:01 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0077744) hgbot (developer) 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 (viewer) 2015-05-26 10:19 |
Code review + testing OK |
|
(0077778) hudsonbot (viewer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-04-21 11:01 | ioritzCia | New Issue | |
| 2015-04-21 11:01 | ioritzCia | Assigned To | => Triage Finance |
| 2015-04-21 11:01 | ioritzCia | File Added: TrialBalance.log | |
| 2015-04-21 11:01 | ioritzCia | OBNetwork customer | => Yes |
| 2015-04-21 11:01 | ioritzCia | Web browser | => Google Chrome |
| 2015-04-21 11:01 | ioritzCia | Modules | => Core |
| 2015-04-21 11:01 | ioritzCia | Triggers an Emergency Pack | => No |
| 2015-04-21 11:05 | ioritzCia | Tag Attached: Performance | |
| 2015-04-22 10:19 | jonalegriaesarte | Web browser | Google Chrome => Google Chrome |
| 2015-04-22 10:19 | jonalegriaesarte | Support ticket | => 35761 |
| 2015-04-22 10:19 | jonalegriaesarte | Resolution time | => 1432072800 |
| 2015-04-22 10:19 | jonalegriaesarte | Target Version | => 3.0PR15Q3 |
| 2015-04-28 15:53 | shuehner | Issue Monitored: shuehner | |
| 2015-05-04 19:12 | ngarcia | Issue Monitored: ngarcia | |
| 2015-05-14 11:51 | eduardo_Argal | Assigned To | Triage Finance => eduardo_Argal |
| 2015-05-14 11:51 | eduardo_Argal | Status | new => scheduled |
| 2015-05-26 10:19 | hgbot | Checkin | |
| 2015-05-26 10:19 | hgbot | Note Added: 0077744 | |
| 2015-05-26 10:19 | hgbot | Status | scheduled => resolved |
| 2015-05-26 10:19 | hgbot | Resolution | open => fixed |
| 2015-05-26 10:19 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/c1e975b2a1cb3dbe10a016bfa30ab01b1271ef56 [^] |
| 2015-05-26 10:19 | vmromanos | Review Assigned To | => vmromanos |
| 2015-05-26 10:19 | vmromanos | Note Added: 0077745 | |
| 2015-05-26 10:19 | vmromanos | Status | resolved => closed |
| 2015-05-27 00:39 | hudsonbot | Checkin | |
| 2015-05-27 00:39 | hudsonbot | Note Added: 0077778 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |