Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021639Openbravo ERPA. Platformpublic2012-09-13 13:272012-10-10 16:35
Reporterjonalegriaesarte 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP16Fixed in Version3.0MP16 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021639: Product selector in purchase order takes a long time to load the data
DescriptionProduct selector in purchase order takes a long time to load the data
Steps To ReproduceWe can provide a database with enough data to reproduce the issue.
Proposed Solution
Additional Information
TagsPerformance
Relationships
has duplicate defect 00216433.0MP16 closed AugustoMauch The product selector collapses the server when there are many rows on the m_productprice and m_storage_detail tables 
related to design defect 0021952 new dmiguelez Product selector is not showing all the required information for high volume environments 
related to defect 00222713.0MP18 closed shankarb ON the ProductSimple selector the elements disapear when ordering them on grid view 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-09-13 13:27jonalegriaesarteNew Issue
2012-09-13 13:27jonalegriaesarteAssigned To => AugustoMauch
2012-09-13 13:27jonalegriaesarteModules => Core
2012-09-13 13:27jonalegriaesarteTag Attached: Performance
2012-09-13 18:26AugustoMauchRelationship addedhas duplicate 0021643
2012-09-14 09:41AugustoMauchAssigned ToAugustoMauch => dmiguelez
2012-09-28 12:04hgbotCheckin
2012-09-28 12:04hgbotNote Added: 0052860
2012-09-28 12:04hgbotStatusnew => resolved
2012-09-28 12:04hgbotResolutionopen => fixed
2012-09-28 12:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8d6028e7aba3801ec9dd283bb85cc59fbfa1d376 [^]
2012-09-28 12:05dmiguelezNote Added: 0052861
2012-10-01 08:36egoitzClosed by => egoitz
2012-10-01 08:36egoitzNote Added: 0052942
2012-10-01 08:36egoitzStatusresolved => closed
2012-10-01 08:36egoitzFixed in Version => 3.0MP16
2012-10-04 18:18hudsonbotCheckin
2012-10-04 18:18hudsonbotNote Added: 0053039
2012-10-10 16:35hudsonbotCheckin
2012-10-10 16:35hudsonbotNote Added: 0053212
2012-10-16 13:02plujanRelationship addedrelated to 0021952
2012-11-12 13:39egoitzRelationship addedrelated to 0022271

Notes
(0052860)
hgbot   
2012-09-28 12:04   
Repository: erp/devel/pi
Changeset: 8d6028e7aba3801ec9dd283bb85cc59fbfa1d376
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Sep 24 16:44:28 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8d6028e7aba3801ec9dd283bb85cc59fbfa1d376 [^]

Fixes issue 21639: Created new selector for managing large
amounts of data.

---
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
A src/org/openbravo/erpCommon/info/PriceListVersionFilterExpressionName.java
---
(0052861)
dmiguelez   
2012-09-28 12:05   
This Query can help to update quickly all the references to the previous selector to the new one:

update ad_column
set ad_reference_id='95E2A8B50A254B2AAE6774B8C2F28120', ad_reference_value_id='712D9821BE8246AC95E6C16D8BEEBE5E'
where ad_column_id in
(select c.ad_column_id
from ad_column c
join ad_table t using (ad_table_id)
join ad_window w on (t.ad_window_id=w.ad_window_id)
join ad_tab tab on (t.ad_table_id=tab.ad_table_id)
join ad_field f on (f.ad_column_id=c.ad_column_id)
where ad_reference_value_id='800060'
  and (f.isreadonly = 'N' or f.isreadonly is null)
  and (tab.isreadonly= 'N' or tab.isreadonly is null)
group by c.ad_column_id);
(0052942)
egoitz   
2012-10-01 08:36   
verified by RM
(0053039)
hudsonbot   
2012-10-04 18:18   
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/c067ea513614 [^]

Maturity status: Test
(0053212)
hudsonbot   
2012-10-10 16:35   
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/b088fe9dfe19 [^]

Maturity status: Test