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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0023643
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performancemajorhave not tried2013-04-25 16:582013-05-27 17:07
ReporterumartirenaView Statuspublic 
Assigned Toshankarb 
PrioritynormalResolutionfixedFixed in Version3.0MP24
StatusclosedFix in branchFixed in SCM revision5ca23b222c63
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023643: List of Dropdowns with more than 1000 fire a warning in the log.

DescriptionThis is a list of Dropdowns with more than 1000 fire a warning in the log:
 - In the window Organization, in tab Information the combo fields inpadUserId
 - In the window Stock Reservation, in tab Stock the combo fields inpmReservationId
 - In the window Process Request, in tab Process Request the combo fields inpadUserId
 - In the window Sales Order, in tab Reserved Stock the combo fields inpmReservationId,inpmReservationStockId,inpcOrderlineId
 - In the window Role, in tab Field Access the combo fields inpadTabAccessId
 - In the window Sales Invoice, in tab Line Tax the combo fields inpcInvoiceId
 - n the window Sales Order Line, in tab Sales Order Line the combo fields inpmProductUomId
Steps To ReproduceThis messages are shown in the log when this combos had more than 1000 values
Proposed SolutionChange the reference of this columns from table or tabledir, depending on the case, to selectors, existing ones or new ones.
TagsNo tags attached.
Attached Filesdiff file icon Fix23643.diff [^] (25,067 bytes) 2013-05-06 05:42 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 00262673.0PR14Q3 closedshankarb Re-implement combos (table and tableDir) to use datasources 

-  Notes
(0058465)
umartirena (reporter)
2013-05-06 10:53

 One more warning found in another table, AD_COLUMN:

WARN org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window Tables and Columns, in tab Column the combo fields inpadElementId 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.
(0058467)
hgbot (developer)
2013-05-06 12:03

 Repository: erp/devel/pi
Changeset: ee1b12fcabead6e56883dad13d0da83c9a473091
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Thu May 02 19:30:15 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/ee1b12fcabead6e56883dad13d0da83c9a473091 [^]

Fixes Issue 23643: List of Dropdowns with more than 1000 fire a warning in the log

Changed reference types to selectors to remove warning in the log.

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0058568)
hgbot (developer)
2013-05-11 17:32

 Repository: erp/devel/pi
Changeset: 355c1d0f60640f86007e28d1a01deb8ae4956f17
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Sat May 11 21:01:08 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/355c1d0f60640f86007e28d1a01deb8ae4956f17 [^]

Related to Issue 23721 : Backout changeset d17e521df335

Backedout changeset as it is related to issue 23643

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0058569)
hgbot (developer)
2013-05-11 18:39

 Repository: erp/devel/pi
Changeset: 9e840b9d34961e84014f2df472853992e333ec73
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Sat May 11 21:30:40 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/9e840b9d34961e84014f2df472853992e333ec73 [^]

Related to Issue 0023643 : Added selector for element

Added selector for element field in ad_column table.

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0058728)
AugustoMauch (manager)
2013-05-21 16:21

 UOM combo in the Lines tab of the Sales Order window is not working. This HQL where clause is wrong: https://code.openbravo.com/erp/devel/pi/rev/ee1b12fcabead6e56883dad13d0da83c9a473091#l3.15 [^]
(0058737)
hgbot (developer)
2013-05-22 08:52

 Repository: erp/devel/pi
Changeset: 5ca23b222c6307cc96e5a06e1ca6adca1ab58833
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Wed May 22 12:05:58 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/5ca23b222c6307cc96e5a06e1ca6adca1ab58833 [^]

Fixes Issue 23643 : Changed hqlWhereClause of product uom selector

The whereclause was comparing BaseOBObject with the current product id. Modified that to compare id with current product id.

---
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0058767)
hudsonbot (developer)
2013-05-23 01:32

 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/97c7f6256af7 [^]

Maturity status: Test
(0058800)
hudsonbot (developer)
2013-05-23 01:32

 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/97c7f6256af7 [^]

Maturity status: Test
(0058801)
hudsonbot (developer)
2013-05-23 01:32

 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/97c7f6256af7 [^]

Maturity status: Test
(0058848)
hudsonbot (developer)
2013-05-23 01:34

 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/97c7f6256af7 [^]

Maturity status: Test
(0058972)
AugustoMauch (manager)
2013-05-27 17:07

 Code reviewed and verified in pi@20388faf6420

- Issue History
Date Modified Username Field Change
2013-04-25 16:58 umartirena New Issue
2013-04-25 16:58 umartirena Assigned To => AugustoMauch
2013-04-25 16:58 umartirena Modules => Core
2013-04-25 16:58 umartirena Triggers an Emergency Pack => No
2013-05-02 15:52 shankarb Assigned To AugustoMauch => shankarb
2013-05-06 05:41 shankarb Status new => scheduled
2013-05-06 05:41 shankarb fix_in_branch => pi
2013-05-06 05:42 shankarb File Added: Fix23643.diff
2013-05-06 10:53 umartirena Note Added: 0058465
2013-05-06 12:01 shankarb Review Assigned To => AugustoMauch
2013-05-06 12:01 shankarb fix_in_branch pi =>
2013-05-06 12:02 shankarb Issue Monitored: AugustoMauch
2013-05-06 12:03 hgbot Checkin
2013-05-06 12:03 hgbot Note Added: 0058467
2013-05-06 12:03 hgbot Status scheduled => resolved
2013-05-06 12:03 hgbot Resolution open => fixed
2013-05-06 12:03 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ee1b12fcabead6e56883dad13d0da83c9a473091 [^]
2013-05-11 17:32 hgbot Checkin
2013-05-11 17:32 hgbot Note Added: 0058568
2013-05-11 18:39 hgbot Checkin
2013-05-11 18:39 hgbot Note Added: 0058569
2013-05-21 16:21 AugustoMauch Note Added: 0058728
2013-05-21 16:21 AugustoMauch Status resolved => new
2013-05-21 16:21 AugustoMauch Resolution fixed => open
2013-05-22 08:52 hgbot Checkin
2013-05-22 08:52 hgbot Note Added: 0058737
2013-05-22 08:52 hgbot Status new => resolved
2013-05-22 08:52 hgbot Resolution open => fixed
2013-05-22 08:52 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/ee1b12fcabead6e56883dad13d0da83c9a473091 [^] => http://code.openbravo.com/erp/devel/pi/rev/5ca23b222c6307cc96e5a06e1ca6adca1ab58833 [^]
2013-05-23 01:32 hudsonbot Checkin
2013-05-23 01:32 hudsonbot Note Added: 0058767
2013-05-23 01:32 hudsonbot Checkin
2013-05-23 01:32 hudsonbot Note Added: 0058800
2013-05-23 01:32 hudsonbot Checkin
2013-05-23 01:32 hudsonbot Note Added: 0058801
2013-05-23 01:34 hudsonbot Checkin
2013-05-23 01:34 hudsonbot Note Added: 0058848
2013-05-27 17:07 AugustoMauch Note Added: 0058972
2013-05-27 17:07 AugustoMauch Status resolved => closed
2013-05-27 17:07 AugustoMauch Fixed in Version => 3.0MP24
2014-05-09 10:25 alostale Relationship added related to 0026267

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker