Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025065Openbravo ERP07. Sales managementpublic2013-10-31 18:312013-11-19 19:07
Reporteregoitz 
Assigned Tocaristu 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP30Fixed in Version3.0MP30 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025065: Big combos on sales order and sales invoice windows
DescriptionThere are some tabledir columns causing performance problems on c_orderline and c_invoiceline tables. The column is m_offer_id on both tables.
Steps To ReproduceOn an environment with a lot of rows on M_offer table check the log:

 Warning: In the window Sales Invoice, in tab Lines the combo fields inpmOfferId 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 inpmOfferId 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-10-31 18:31egoitzNew Issue
2013-10-31 18:31egoitzAssigned To => caristu
2013-10-31 18:31egoitzModules => Core
2013-10-31 18:31egoitzOBNetwork customer => Yes
2013-10-31 18:31egoitzTriggers an Emergency Pack => No
2013-11-07 09:00hgbotCheckin
2013-11-07 09:00hgbotNote Added: 0062046
2013-11-07 09:00hgbotStatusnew => resolved
2013-11-07 09:00hgbotResolutionopen => fixed
2013-11-07 09:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/792f4a583b0ff0b1307ea01b52c41d8be1c78455 [^]
2013-11-15 09:09egoitzReview Assigned To => egoitz
2013-11-15 09:09egoitzNote Added: 0062134
2013-11-15 09:09egoitzStatusresolved => closed
2013-11-15 09:09egoitzFixed in Version => 3.0MP30
2013-11-19 19:07hudsonbotCheckin
2013-11-19 19:07hudsonbotNote Added: 0062241

Notes
(0062046)
hgbot   
2013-11-07 09:00   
Repository: erp/devel/pi
Changeset: 792f4a583b0ff0b1307ea01b52c41d8be1c78455
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Nov 06 14:01:19 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/792f4a583b0ff0b1307ea01b52c41d8be1c78455 [^]

fixes issue 25065: Big combos on sales order and sales invoice windows

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
---
(0062134)
egoitz   
2013-11-15 09:09   
verified
(0062241)
hudsonbot   
2013-11-19 19:07   
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/ab71e0273dc1 [^]

Maturity status: Test