Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0034308 | Openbravo ERP | 09. Financial management | public | 2016-10-26 22:03 | 2016-12-16 18:39 |
|
| Reporter | egoitz | |
| Assigned To | AtulOpenbravo | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q1 | |
| Merge Request Status | |
| Review Assigned To | aferraz |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 44101 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0034308: low performance when Opening the Balance Sheet and P&L infraestructure |
| Description | The filter page to execute the balance sheet and p&l infrestructure takes long to be loaded . |
| Steps To Reproduce | Open the filter window on an environment with a concrete amount of data.
CONTACT SUPPORT(ECA) FOR A TESTING ENVIRONMENT. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2016-10-26 22:03 | egoitz | New Issue | |
| 2016-10-26 22:03 | egoitz | Assigned To | => Triage Finance |
| 2016-10-26 22:03 | egoitz | OBNetwork customer | => Yes |
| 2016-10-26 22:03 | egoitz | Modules | => Core |
| 2016-10-26 22:03 | egoitz | Support ticket | => 44101 |
| 2016-10-26 22:03 | egoitz | Resolution time | => 1478041200 |
| 2016-10-26 22:03 | egoitz | Triggers an Emergency Pack | => No |
| 2016-10-27 00:52 | aferraz | Assigned To | Triage Finance => AtulOpenbravo |
| 2016-11-24 09:54 | AtulOpenbravo | Status | new => scheduled |
| 2016-11-24 14:14 | aferraz | Type | defect => design defect |
| 2016-11-24 14:24 | aferraz | Note Added: 0091784 | |
| 2016-11-24 17:53 | AtulOpenbravo | Note Added: 0091793 | |
| 2016-12-15 10:03 | hgbot | Checkin | |
| 2016-12-15 10:03 | hgbot | Note Added: 0092402 | |
| 2016-12-15 10:03 | hgbot | Status | scheduled => resolved |
| 2016-12-15 10:03 | hgbot | Resolution | open => fixed |
| 2016-12-15 10:03 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/9129ff0ef02271675de7a77d873ffd6f273a9004 [^] |
| 2016-12-15 10:05 | aferraz | Review Assigned To | => aferraz |
| 2016-12-15 10:05 | aferraz | Note Added: 0092404 | |
| 2016-12-15 10:05 | aferraz | Status | resolved => closed |
| 2016-12-15 10:05 | aferraz | Fixed in Version | => 3.0PR17Q1 |
| 2016-12-15 10:13 | aferraz | Note Added: 0092405 | |
| 2016-12-16 18:39 | hudsonbot | Checkin | |
| 2016-12-16 18:39 | hudsonbot | Note Added: 0092719 | |
|
Notes |
|
|
|
|
Moved to design defect as window behavior should be changed: Organization and Year combo values should be loaded when changing Accounting Report and Organization combo values respectively, instead of loading them when opening the window. |
|
|
|
|
Test Plan
- Login as F&B International Group Admin
- Open Balance Sheet and P&L Structure
- Check General Ledger is set with default value, Accounting Report, Organisation and Year Combo is blank.
- Select value in Accounting Report, check that Organisation combo has values in it. Check that Year combo is blank.
- Select value in Organisation combo, check that year combo is loaded with values in it.
- Set Accounting Report combo blank, check that Organisation and year combo are blank. |
|
|
|
(0092402)
|
|
hgbot
|
|
2016-12-15 10:03
|
|
Repository: erp/devel/pi
Changeset: 9129ff0ef02271675de7a77d873ffd6f273a9004
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Nov 23 22:45:47 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/9129ff0ef02271675de7a77d873ffd6f273a9004 [^]
Fixes issue 34308: Performance issue in Opening Balance Sheet and P&L Structure
Problem is with loading Organization and Year combo in default method. Now
this Org combos is loaded on change in accounting report and general ledger.
Year combo is loaded on change in Organization selection.
---
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.html
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.java
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
---
|
|
|
|
|
|
|
|
|
Cost of two problematic queries has been reduced:
selectOrgsDouble: before: 5652.76 - after: 254.55
selectYearsDouble: before: 1571.85 - after: 31.64 |
|
|
|
|
|