Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0022795Openbravo ERP09. Financial managementpublic2013-01-14 18:282013-02-04 16:45
jonalegriaesarte 
jecharri 
highmajoralways
closedfixed 
5
 
3.0MP203.0MP21 
jonalegriaesarte
Core
No
0022795: G/L Journal lines window takes long time to load due to two combo boxes with a huge amount of data
G/L Journal lines window takes long time to load due to two combo boxes with a huge amount of data
- Using a database with a big amount of products and payments, try to load the tab lines in G/L journal window. The error in logs is:

Warning: In the window G/L Journal, in tab Lines the combo fields inpfinPaymentId,inpmProductId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo.
No tags attached.
Issue History
2013-01-14 18:28jonalegriaesarteNew Issue
2013-01-14 18:28jonalegriaesarteAssigned To => jonalegriaesarte
2013-01-14 18:28jonalegriaesarteModules => Core
2013-01-14 18:28jonalegriaesarteTriggers an Emergency Pack => No
2013-01-23 16:50jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2013-01-24 10:45hgbotCheckin
2013-01-24 10:45hgbotNote Added: 0055796
2013-01-24 10:45hgbotStatusnew => resolved
2013-01-24 10:45hgbotResolutionopen => fixed
2013-01-24 10:45hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3e42b5ba12daa0874edb53957e050a9b63c561bf [^]
2013-01-24 21:40hudsonbotCheckin
2013-01-24 21:40hudsonbotNote Added: 0055823
2013-01-31 09:47jecharriNote Added: 0055988
2013-02-04 16:45jonalegriaesarteReview Assigned To => jonalegriaesarte
2013-02-04 16:45jonalegriaesarteNote Added: 0056134
2013-02-04 16:45jonalegriaesarteStatusresolved => closed
2013-02-04 16:45jonalegriaesarteFixed in Version => 3.0MP21

Notes
(0055796)
hgbot   
2013-01-24 10:45   
Repository: erp/devel/pi
Changeset: 3e42b5ba12daa0874edb53957e050a9b63c561bf
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Jan 24 10:44:35 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3e42b5ba12daa0874edb53957e050a9b63c561bf [^]

Fixes issue 22795: G/L Journal lines window takes long time
to load due to two combo boxes with a huge amount of data

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
---
(0055823)
hudsonbot   
2013-01-24 21:40   
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/fbbe21bdfeff [^]

Maturity status: Test
(0055988)
jecharri   
2013-01-31 09:47   
Test cases:
-verify the steps to reproduce.
-verify that the product selector is working as it expected. You can see all the product that you have access
(0056134)
jonalegriaesarte   
2013-02-04 16:45   
Verified