Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033398Openbravo ERP09. Financial managementpublic2016-06-30 19:072016-08-17 17:36
Reportermaite 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q4 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket42323
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033398: "selectDocumentsDates" does not finish in case huge number of organizations and opened period control
DescriptionselectDocumentsDates does not finish in case huge number of organizations and opened period control
Steps To Reproduce"selectDocumentsDates" needs to be refactored to improve performance

NOTE: I can provide client's environment where problem is reproducible
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-06-30 19:07maiteNew Issue
2016-06-30 19:07maiteAssigned To => Triage Finance
2016-06-30 19:07maiteOBNetwork customer => Yes
2016-06-30 19:07maiteModules => Core
2016-06-30 19:07maiteSupport ticket => 42323
2016-06-30 19:07maiteResolution time => 1468879200
2016-06-30 19:07maiteTriggers an Emergency Pack => No
2016-06-30 19:07maiteIssue Monitored: networkb
2016-07-01 12:50aferrazAssigned ToTriage Finance => markmm82
2016-07-08 09:25vmromanosAssigned Tomarkmm82 => AtulOpenbravo
2016-07-20 18:07AtulOpenbravoStatusnew => scheduled
2016-07-22 13:44aferrazAssigned ToAtulOpenbravo => egoitz
2016-07-22 13:44aferrazStatusscheduled => feedback
2016-07-22 13:45aferrazNote Added: 0088642
2016-08-03 08:58maiteAssigned Toegoitz => AtulOpenbravo
2016-08-03 08:58maiteStatusfeedback => new
2016-08-04 09:33aferrazStatusnew => scheduled
2016-08-17 12:48hgbotCheckin
2016-08-17 12:48hgbotNote Added: 0089178
2016-08-17 12:48hgbotStatusscheduled => resolved
2016-08-17 12:48hgbotResolutionopen => fixed
2016-08-17 12:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8150e26c692bfe5eb2947a7d6a5b57173ac43699 [^]
2016-08-17 12:49aferrazReview Assigned To => aferraz
2016-08-17 12:49aferrazNote Added: 0089179
2016-08-17 12:49aferrazStatusresolved => closed
2016-08-17 12:49aferrazFixed in Version => 3.0PR16Q4
2016-08-17 17:36hudsonbotCheckin
2016-08-17 17:36hudsonbotNote Added: 0089186

Notes
(0088642)
aferraz   
2016-07-22 13:45   
We need access to client's environment to test the fix.
(0089178)
hgbot   
2016-08-17 12:48   
Repository: erp/devel/pi
Changeset: 8150e26c692bfe5eb2947a7d6a5b57173ac43699
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Aug 16 22:53:24 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/8150e26c692bfe5eb2947a7d6a5b57173ac43699 [^]

Fixes issue 33398: Performance problem in selectDocumentsDates method

Improved selectDocumentsDates method query using EXISTS clause.

---
M src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql
---
(0089179)
aferraz   
2016-08-17 12:49   
Code review + Testing OK
(0089186)
hudsonbot   
2016-08-17 17:36   
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/2cc6016b8b9f [^]
Maturity status: Test