Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023733Openbravo ERP07. Sales managementpublic2013-05-06 09:552013-08-27 10:54
Reporteregoitz 
Assigned Tonaiaramartinez 
PriorityhighSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Togorkaion
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2012-11-26
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/47aa2660c919 [^]
Triggers an Emergency PackYes
Summary0023733: A computed column on M_inouttable causing performance problems.
DescriptionThe computed column added on m_inout table causes a performance problem when loading the goods shipment window.
Steps To Reproduce-On an environment with a big amount of data on m_inout table and m_inoutline table open the goodshipment window
*It takes long to show the data
Proposed Solution
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-05-06 09:55egoitzNew Issue
2013-05-06 09:55egoitzAssigned To => dmiguelez
2013-05-06 09:55egoitzModules => Core
2013-05-06 09:55egoitzTriggers an Emergency Pack => No
2013-05-06 09:55egoitzTag Attached: Performance
2013-05-06 10:01egoitzRegression level => Production - Confirmed Stable
2013-05-06 10:01egoitzRegression date => 2012-11-26
2013-05-06 10:01egoitzRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/47aa2660c919 [^]
2013-05-06 10:01egoitzTriggers an Emergency PackNo => Yes
2013-05-06 10:02egoitzAssigned Todmiguelez => naiaramartinez
2013-05-08 18:11hgbotCheckin
2013-05-08 18:11hgbotNote Added: 0058509
2013-05-08 18:11hgbotStatusnew => resolved
2013-05-08 18:11hgbotResolutionopen => fixed
2013-05-08 18:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c01c1ba1956a5c35633068ad86b82191cfdbf5e6 [^]
2013-05-08 18:15gorkaionReview Assigned To => gorkaion
2013-05-08 18:15gorkaionStatusresolved => closed
2013-05-09 19:21hgbotCheckin
2013-05-09 19:21hgbotNote Added: 0058531
2013-05-10 11:53naiaramartinezStatusclosed => new
2013-05-10 11:53naiaramartinezResolutionfixed => open
2013-05-10 11:53naiaramartinezStatusnew => scheduled
2013-05-10 11:53naiaramartinezfix_in_branch => pi
2013-05-10 12:07hgbotCheckin
2013-05-10 12:07hgbotNote Added: 0058544
2013-05-10 12:07hgbotStatusscheduled => resolved
2013-05-10 12:07hgbotResolutionopen => fixed
2013-05-10 12:07hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/c01c1ba1956a5c35633068ad86b82191cfdbf5e6 [^] => http://code.openbravo.com/erp/devel/pi/rev/0e7d3a929b461f612b336e357f642c9b35586149 [^]
2013-05-10 15:24hgbotCheckin
2013-05-10 15:24hgbotNote Added: 0058565
2013-05-13 15:22naiaramartinezNote Added: 0058619
2013-05-13 15:22naiaramartinezStatusresolved => closed
2013-05-13 17:29naiaramartinezStatusclosed => new
2013-05-13 17:29naiaramartinezResolutionfixed => open
2013-05-13 17:30naiaramartinezPriorityimmediate => high
2013-05-13 17:30naiaramartinezfix_in_branchpi =>
2013-05-23 01:32hudsonbotCheckin
2013-05-23 01:32hudsonbotNote Added: 0058780
2013-05-23 01:32hudsonbotCheckin
2013-05-23 01:32hudsonbotNote Added: 0058787
2013-05-23 01:32hudsonbotCheckin
2013-05-23 01:32hudsonbotNote Added: 0058794
2013-05-23 01:32hudsonbotCheckin
2013-05-23 01:32hudsonbotNote Added: 0058797
2013-08-27 10:54jonalegriaesarteNote Added: 0060783
2013-08-27 10:54jonalegriaesarteStatusnew => closed
2013-08-27 10:54jonalegriaesarteResolutionopen => no change required

Notes
(0058509)
hgbot   
2013-05-08 18:11   
Repository: erp/devel/pi
Changeset: c01c1ba1956a5c35633068ad86b82191cfdbf5e6
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Wed May 08 18:09:52 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c01c1ba1956a5c35633068ad86b82191cfdbf5e6 [^]

fixed bug 23733: A computed column on M_inout table causing performance problems.

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0058531)
hgbot   
2013-05-09 19:21   
Repository: erp/devel/pi
Changeset: 01fcd3b1e098708d3312f17ccd075d09dcbcbfbc
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Thu May 09 19:21:21 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/01fcd3b1e098708d3312f17ccd075d09dcbcbfbc [^]

Related to issue 23733: revert the changeset

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0058544)
hgbot   
2013-05-10 12:07   
Repository: erp/devel/pi
Changeset: 0e7d3a929b461f612b336e357f642c9b35586149
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Fri May 10 12:02:36 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0e7d3a929b461f612b336e357f642c9b35586149 [^]

fixed bug 23733 fixed bug 23775: computed columns performance in c_order and m_inout

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-canvas.js
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0058565)
hgbot   
2013-05-10 15:24   
Repository: erp/devel/pi
Changeset: 2af4fa4502daa9b1023db3d1ab2f19e6ad13fe5a
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Fri May 10 15:22:06 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2af4fa4502daa9b1023db3d1ab2f19e6ad13fe5a [^]

related to issue 23733 related to issue 23775: backout for enabling integration

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-canvas.js
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0058619)
naiaramartinez   
2013-05-13 15:22   
A fix is not going to be done. There wiki is going to be updated to inform that performance can be affected, and if that happens, the field(invoice status) will have to be deactivated/deleted.
(0058780)
hudsonbot   
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
(0058787)
hudsonbot   
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
(0058794)
hudsonbot   
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
(0058797)
hudsonbot   
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
(0060783)
jonalegriaesarte   
2013-08-27 10:54   
This issue is going to be closed, becuase no change is required. In this case, the wiki has been changed. In the future, platform team will review this functionality to change the way of calculating this type of columns.