Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023540Openbravo ERPA. Platformpublic2013-04-12 11:202013-04-25 01:50
Reporterjonalegriaesarte 
Assigned Topramakrishnan 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP23Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket20577
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023540: Several combo boxes are causing performance issues because they are loading a huge amount of data
DescriptionSeveral combo boxes are causing performance issues because they are loading a huge amount of data. Log got:

 Warning: In the window User, in tab User the combo fields inpsupervisorId
 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.
 fff0bb6f 2013-04-11 10:02:27,691 [ajp-8809-9] WARN
 org.openbravo.client.application.window.FormInitializationComponent -
 Warning: In the window User, in tab User Roles the combo fields inpadUserId
 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.
 Warning: In the window Process Monitor, in tab Process Execution the combo
 fields inpadProcessRequestId,inpadUserId 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
 Warning: In the window Sales Order, in tab Lines the combo fields
 inpmInoutlineId 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.
 Warning: In the window RFC Order Pick / Edit Lines, in tab Pick / Edit Lines
 the combo fields inpreturnorderid,inpcOrderlineId 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
Steps To Reproduce- Window user, tab user, reference of supervisor should be moved to selector.
- Window user, tab user roles, reference of user should be moved to selector.
- Window sales order, tab Lines, reference of mInoutlineId should be moved to selector.
- Window RFC Order Pick / Edit Lines, tab Pick / Edit Lines, reference of returnorderid should be moved to selector.
- Window RFC Order Pick / Edit Lines, tab Pick / Edit Lines, reference of cOrderlineId should be moved to selector.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 00226893.0MP21 closed ioritzCia Openbravo ERP Dropdown with more than 1000 fire a warning in the log. 
related to defect 0025388 closed caristu Modules Performance issue in payment selector 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-04-12 11:20jonalegriaesarteNew Issue
2013-04-12 11:20jonalegriaesarteAssigned To => AugustoMauch
2013-04-12 11:20jonalegriaesarteModules => Core
2013-04-12 11:20jonalegriaesarteOBNetwork customer => Yes
2013-04-12 11:20jonalegriaesarteSupport ticket => 20577
2013-04-12 11:20jonalegriaesarteTriggers an Emergency Pack => No
2013-04-12 11:55alostaleTag Attached: Performance
2013-04-15 13:02AugustoMauchDescription Updatedbug_revision_view_page.php?rev_id=4571#r4571
2013-04-15 13:02AugustoMauchSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4573#r4573
2013-04-15 13:02AugustoMauchDescription Updatedbug_revision_view_page.php?rev_id=4574#r4574
2013-04-15 13:22AugustoMauchSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4577#r4577
2013-04-15 13:24AugustoMauchSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4578#r4578
2013-04-15 13:29AugustoMauchRelationship addedrelated to 0022689
2013-04-16 15:40AugustoMauchAssigned ToAugustoMauch => dmiguelez
2013-04-17 18:56jonalegriaesarteNote Added: 0058001
2013-04-17 18:56jonalegriaesarteTarget Version => 3.0MP23
2013-04-18 05:30pramakrishnanAssigned Todmiguelez => pramakrishnan
2013-04-18 05:31pramakrishnanStatusnew => scheduled
2013-04-18 05:31pramakrishnanfix_in_branch => pi
2013-04-18 06:51pramakrishnanNote Added: 0058002
2013-04-23 17:49hgbotCheckin
2013-04-23 17:49hgbotNote Added: 0058146
2013-04-23 17:49hgbotStatusscheduled => resolved
2013-04-23 17:49hgbotResolutionopen => fixed
2013-04-23 17:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/98249a01fff06f34cb2cdbbf4af5f0145e95e99b [^]
2013-04-23 17:50dmiguelezNote Added: 0058147
2013-04-23 17:50dmiguelezStatusresolved => closed
2013-04-25 01:50hudsonbotCheckin
2013-04-25 01:50hudsonbotNote Added: 0058200
2014-04-07 18:05caristuRelationship addedrelated to 0025388

Notes
(0058001)
jonalegriaesarte   
2013-04-17 18:56   
A new one:

17ed39e2 12:57:31 [TP-Processor12] WARN
org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window
Goods Shipment, in tab Lines the combo fields inpcanceledInoutlineId 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.
(0058002)
pramakrishnan   
2013-04-18 06:51   
Test Plan:
Login as Openbravo/openbravo
Navigate to User window
Notice that the supervisor field is changed to selector reference
(0058146)
hgbot   
2013-04-23 17:49   
Repository: erp/devel/pi
Changeset: 98249a01fff06f34cb2cdbbf4af5f0145e95e99b
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Thu Apr 18 10:17:54 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/98249a01fff06f34cb2cdbbf4af5f0145e95e99b [^]

Fixes Issue 23540: Combo boxes that load huge data are causing performance issue

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0058147)
dmiguelez   
2013-04-23 17:50   
Code Review + Testing Ok
(0058200)
hudsonbot   
2013-04-25 01:50   
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/9fa1ecafd560 [^]

Maturity status: Test