Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008321
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-03-26 19:152009-07-21 12:11
ReporterjpabloaeView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revision433ab191caa5
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version1.6.0_11
OS VersionGentoo - 2.6.26Database version11gAnt version1.7.0
Product Version2.40MP1SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008321: General ledger window takes a long time to load with many accounts

DescriptionThe 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 Reproduce1. 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.
Tags250MP1, main, tictech
Attached Filespng file icon ERROR_ACCOUNT.PNG [^] (159,434 bytes) 2009-04-25 11:55

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0008357 closeddalsasua General ledger window takes a long time to load with many accounts 

-  Notes
(0015473)
hgbot (developer)
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
---
(0015732)
psarobe (manager)
2009-04-25 11:54

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
(0015733)
psarobe (manager)
2009-04-25 11:58

Please be carefully because it happens in 240 as well
(0015756)
hgbot (developer)
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 (developer)
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
---
(0018476)
sureshbabu (reporter)
2009-07-21 12:11

Tested able to run the report after the fix.

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker