Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025354Openbravo ERPA. Platformpublic2013-12-17 17:522014-01-03 01:22
Reporteregoitz 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP31Fixed in Version3.0MP31 
Merge Request Status
Review Assigned Tojonalegriaesarte
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025354: Takes long to show the create from invoices popup
DescriptionThe popup shown after click on create from button on the invoices windows takes long to be load
Steps To Reproduce-Open the popup on an environment with a big volume of orders, invoices and M_MATCHINV records
Proposed SolutionCreate the following index:

CREATE INDEX m_matchinv_inout
ON m_matchinv
USING btree
( m_inoutline_id );
Additional Information
TagsPerformance
Relationships
has duplicate defect 00252563.0PR14Q2 closed jonalegriaesarte Create lines from takes too long to load the first time, when the volume of data is high 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-12-17 17:52egoitzNew Issue
2013-12-17 17:52egoitzAssigned To => AugustoMauch
2013-12-17 17:52egoitzModules => Core
2013-12-17 17:52egoitzResolution time => 1389135600
2013-12-17 17:52egoitzTriggers an Emergency Pack => No
2013-12-17 17:53egoitzProposed Solution updated
2013-12-17 17:53egoitzTag Attached: Performance
2013-12-18 09:15alostaleAssigned ToAugustoMauch => dmiguelez
2014-01-02 08:41hgbotCheckin
2014-01-02 08:41hgbotNote Added: 0063162
2014-01-02 08:41hgbotStatusnew => resolved
2014-01-02 08:41hgbotResolutionopen => fixed
2014-01-02 08:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6d69e73928dbcfa082d5a5d4e9a6d25aa18642fc [^]
2014-01-02 09:28hgbotCheckin
2014-01-02 09:28hgbotNote Added: 0063163
2014-01-02 10:14jonalegriaesarteReview Assigned To => jonalegriaesarte
2014-01-02 10:14jonalegriaesarteNote Added: 0063164
2014-01-02 10:14jonalegriaesarteStatusresolved => closed
2014-01-02 10:14jonalegriaesarteFixed in Version => 3.0MP31
2014-01-03 01:21hudsonbotCheckin
2014-01-03 01:21hudsonbotNote Added: 0063220
2014-01-03 01:22hudsonbotCheckin
2014-01-03 01:22hudsonbotNote Added: 0063221
2014-02-03 13:42jonalegriaesarteRelationship addedhas duplicate 0025256

Notes
(0063162)
hgbot   
2014-01-02 08:41   
Repository: erp/devel/pi
Changeset: 6d69e73928dbcfa082d5a5d4e9a6d25aa18642fc
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Thu Jan 02 08:40:39 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/6d69e73928dbcfa082d5a5d4e9a6d25aa18642fc [^]

Fixed issue 0025354: Long time tol load CreateFrom Invoices popup

---
M src-db/database/model/tables/M_MATCHINV.xml
M src/org/openbravo/dal/security/EntityAccessChecker.java
---
(0063163)
hgbot   
2014-01-02 09:28   
Repository: erp/devel/pi
Changeset: 92cf70aa1c129ec42de6c026f32ae8adfef87ec8
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Thu Jan 02 09:27:38 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/92cf70aa1c129ec42de6c026f32ae8adfef87ec8 [^]

Related with issue 0025354: Remove an incorrect change

---
M src/org/openbravo/dal/security/EntityAccessChecker.java
---
(0063164)
jonalegriaesarte   
2014-01-02 10:14   
Verfied and working fine
(0063220)
hudsonbot   
2014-01-03 01:21   
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/7a908443c43a [^]

Maturity status: Test
(0063221)
hudsonbot   
2014-01-03 01:22   
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/7a908443c43a [^]

Maturity status: Test