Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0008321 | Openbravo ERP | 09. Financial management | public | 2009-03-26 19:15 | 2009-07-21 12:11 |
|
| Reporter | jpabloae | |
| Assigned To | dalsasua | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | Gentoo - 2.6.26 |
| Product Version | 2.40MP1 | |
| Target Version | | Fixed in Version | pi | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0008321: General ledger window takes a long time to load with many accounts |
| Description | The general ledger window takes around 5 minutes to be opened when there is a big amount of accounts (0000561:0008000). The problem is that the combo boxes include the 8000 elements in the HTML code, and the file is big (>1.4MB). |
| Steps To Reproduce | 1. Financial management -> Analysis tools -> General Ledger.
2. View the source of the HTML file.
3. All the accounts are included statically in the HTML file.
4. If you create thousands of accounts, this is more notable. |
| Proposed Solution | |
| Additional Information | |
| Tags | 250MP1, main, tictech |
| Relationships | | depends on | backport | 0008357 | | closed | dalsasua | General ledger window takes a long time to load with many accounts |
|
| Attached Files |  ERROR_ACCOUNT.PNG (159,434) 2009-04-25 11:55
https://issues.openbravo.com/file_download.php?file_id=1224&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2009-03-26 19:15 | jpabloae | New Issue | |
| 2009-03-26 19:15 | jpabloae | Assigned To | => rafaroda |
| 2009-03-26 19:15 | jpabloae | Regression testing | => No |
| 2009-03-26 19:16 | jpabloae | Tag Attached: tictech | |
| 2009-03-27 09:47 | rafaroda | Assigned To | rafaroda => dalsasua |
| 2009-03-31 11:26 | psarobe | Severity | critical => major |
| 2009-03-31 11:26 | psarobe | Status | new => scheduled |
| 2009-03-31 11:26 | psarobe | fix_in_branch | => pi |
| 2009-04-06 17:21 | psarobe | Priority | immediate => normal |
| 2009-04-06 17:21 | psarobe | fix_in_branch | pi => |
| 2009-04-07 16:08 | psarobe | Priority | normal => immediate |
| 2009-04-21 11:49 | hgbot | Checkin | |
| 2009-04-21 11:49 | hgbot | Note Added: 0015473 | |
| 2009-04-21 11:49 | hgbot | Status | scheduled => resolved |
| 2009-04-21 11:49 | hgbot | Resolution | open => fixed |
| 2009-04-21 11:49 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/5926054be1082f9fd0b4c462bd98e7e0328f5263 [^] |
| 2009-04-22 11:23 | psarobe | Tag Attached: main | |
| 2009-04-25 11:54 | psarobe | Status | resolved => new |
| 2009-04-25 11:54 | psarobe | Resolution | fixed => open |
| 2009-04-25 11:54 | psarobe | Note Added: 0015732 | |
| 2009-04-25 11:55 | psarobe | File Added: ERROR_ACCOUNT.PNG | |
| 2009-04-25 11:55 | psarobe | Tag Attached: 250MP1 | |
| 2009-04-25 11:58 | psarobe | Status | new => scheduled |
| 2009-04-25 11:58 | psarobe | Note Added: 0015733 | |
| 2009-04-25 11:58 | psarobe | fix_in_branch | => pi |
| 2009-04-27 11:00 | hgbot | Checkin | |
| 2009-04-27 11:00 | hgbot | Note Added: 0015756 | |
| 2009-04-27 11:00 | hgbot | Status | scheduled => resolved |
| 2009-04-27 11:00 | hgbot | Resolution | open => fixed |
| 2009-04-27 11:00 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/5926054be1082f9fd0b4c462bd98e7e0328f5263 [^] => http://code.openbravo.com/erp/devel/pi/rev/f0dcb59057ede14236f5d394b33be0ba5a4fdc26 [^] |
| 2009-04-28 19:24 | psarobe | Status | resolved => closed |
| 2009-04-29 00:00 | anonymous | sf_bug_id | 0 => 2783257 |
| 2009-07-03 13:13 | hgbot | Checkin | |
| 2009-07-03 13:13 | hgbot | Note Added: 0017849 | |
| 2009-07-03 13:13 | hgbot | Status | closed => resolved |
| 2009-07-03 13:13 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/f0dcb59057ede14236f5d394b33be0ba5a4fdc26 [^] => http://code.openbravo.com/erp/devel/pi/rev/433ab191caa52aa3171eaaf401ef612c9e766291 [^] |
| 2009-07-21 12:11 | sureshbabu | Status | resolved => closed |
| 2009-07-21 12:11 | sureshbabu | Note Added: 0018476 | |
| 2009-07-21 12:11 | sureshbabu | Fixed in Version | 2.50MP1 => pi |
|
Notes |
|
|
(0015473)
|
|
hgbot
|
|
2009-04-21 11:49
|
|
Repository: erp/devel/pi
Changeset: 5926054be1082f9fd0b4c462bd98e7e0328f5263
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Apr 21 11:46:09 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5926054be1082f9fd0b4c462bd98e7e0328f5263 [^]
Fixes bug 0008321: General ledger window takes a long time to load with many accounts
---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_SEARCH.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.html
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.xml
A src/org/openbravo/erpCommon/info/AccountElementValue.html
A src/org/openbravo/erpCommon/info/AccountElementValue.java
A src/org/openbravo/erpCommon/info/AccountElementValue.xml
A src/org/openbravo/erpCommon/info/AccountElementValue_data.xsql
---
|
|
|
|
|
Hi david,
When you click the selector to open the account selector you cannot do it because a message is shown. It seems to be a problem with the permissions but I'm logged as Openbravo Admin so I shouldn't face this problem
SEE ATTACH |
|
|
|
|
|
Please be carefully because it happens in 240 as well |
|
|
|
(0015756)
|
|
hgbot
|
|
2009-04-27 11:00
|
|
Repository: erp/devel/pi
Changeset: f0dcb59057ede14236f5d394b33be0ba5a4fdc26
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Apr 27 10:59:01 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f0dcb59057ede14236f5d394b33be0ba5a4fdc26 [^]
Fixes bug 0008321: General ledger window takes a long time to load with many accounts
---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
---
|
|
|
|
(0017849)
|
|
hgbot
|
|
2009-07-03 13:13
|
|
Repository: erp/devel/pi
Changeset: 433ab191caa52aa3171eaaf401ef612c9e766291
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Apr 27 10:59:01 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/433ab191caa52aa3171eaaf401ef612c9e766291 [^]
Fixes bug 0008321: General ledger window takes a long time to load with many accounts
---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
---
|
|
|
|
|
|
Tested able to run the report after the fix. |
|