Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022795Openbravo ERP09. Financial managementpublic2013-01-14 18:282013-02-04 16:45
Reporterjonalegriaesarte 
Assigned Tojecharri 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP20Fixed in Version3.0MP21 
Merge Request Status
Review Assigned Tojonalegriaesarte
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022795: G/L Journal lines window takes long time to load due to two combo boxes with a huge amount of data
DescriptionG/L Journal lines window takes long time to load due to two combo boxes with a huge amount of data
Steps To Reproduce- 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-01-14 18:28jonalegriaesarteNew Issue
2013-01-14 18:28jonalegriaesarteAssigned To => jonalegriaesarte
2013-01-14 18:28jonalegriaesarteModules => Core
2013-01-14 18:28jonalegriaesarteOBNetwork customer => Yes
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