Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0025065Openbravo ERP07. Sales managementpublic2013-10-31 18:312013-11-19 19:07
egoitz 
caristu 
immediatemajoralways
closedfixed 
5
pi 
3.0MP303.0MP30 
egoitz
Core
No
0025065: Big combos on sales order and sales invoice windows
There are some tabledir columns causing performance problems on c_orderline and c_invoiceline tables. The column is m_offer_id on both tables.
On 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
No tags attached.
Issue History
2013-10-31 18:31egoitzNew Issue
2013-10-31 18:31egoitzAssigned To => caristu
2013-10-31 18:31egoitzModules => Core
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