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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0023540
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2013-04-12 11:202013-04-25 01:50
ReporterjonalegriaesarteView Statuspublic 
Assigned Topramakrishnan 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision98249a01fff0
ProjectionnoneETAnoneTarget Version3.0MP23
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023540: 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.
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00226893.0MP21 closedioritzCia Openbravo ERP Dropdown with more than 1000 fire a warning in the log. 
related to defect 0025388 closedcaristu Modules Performance issue in payment selector 

-  Notes
(0058001)
jonalegriaesarte (reporter)
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 (developer)
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 (developer)
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 (developer)
2013-04-23 17:50

 Code Review + Testing Ok
(0058200)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2013-04-12 11:20 jonalegriaesarte New Issue
2013-04-12 11:20 jonalegriaesarte Assigned To => AugustoMauch
2013-04-12 11:20 jonalegriaesarte Modules => Core
2013-04-12 11:20 jonalegriaesarte Triggers an Emergency Pack => No
2013-04-12 11:55 alostale Tag Attached: Performance
2013-04-15 13:02 AugustoMauch Description Updated View Revisions
2013-04-15 13:02 AugustoMauch Steps to Reproduce Updated View Revisions
2013-04-15 13:02 AugustoMauch Description Updated View Revisions
2013-04-15 13:22 AugustoMauch Steps to Reproduce Updated View Revisions
2013-04-15 13:24 AugustoMauch Steps to Reproduce Updated View Revisions
2013-04-15 13:29 AugustoMauch Relationship added related to 0022689
2013-04-16 15:40 AugustoMauch Assigned To AugustoMauch => dmiguelez
2013-04-17 18:56 jonalegriaesarte Note Added: 0058001
2013-04-17 18:56 jonalegriaesarte Target Version => 3.0MP23
2013-04-18 05:30 pramakrishnan Assigned To dmiguelez => pramakrishnan
2013-04-18 05:31 pramakrishnan Status new => scheduled
2013-04-18 05:31 pramakrishnan fix_in_branch => pi
2013-04-18 06:51 pramakrishnan Note Added: 0058002
2013-04-23 17:49 hgbot Checkin
2013-04-23 17:49 hgbot Note Added: 0058146
2013-04-23 17:49 hgbot Status scheduled => resolved
2013-04-23 17:49 hgbot Resolution open => fixed
2013-04-23 17:49 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/98249a01fff06f34cb2cdbbf4af5f0145e95e99b [^]
2013-04-23 17:50 dmiguelez Note Added: 0058147
2013-04-23 17:50 dmiguelez Status resolved => closed
2013-04-25 01:50 hudsonbot Checkin
2013-04-25 01:50 hudsonbot Note Added: 0058200
2014-04-07 18:05 caristu Relationship added related to 0025388

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker