Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033398
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2016-06-30 19:072016-08-17 17:36
ReportermaiteView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionfixedFixed in Version3.0PR16Q4
StatusclosedFix in branchFixed in SCM revision8150e26c692b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033398: "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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0088642)
aferraz (manager)
2016-07-22 13:45

 We need access to client's environment to test the fix.
(0089178)
hgbot (developer)
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 (manager)
2016-08-17 12:49

 Code review + Testing OK
(0089186)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2016-06-30 19:07 maite New Issue
2016-06-30 19:07 maite Assigned To => Triage Finance
2016-06-30 19:07 maite Modules => Core
2016-06-30 19:07 maite Resolution time => 1468879200
2016-06-30 19:07 maite Triggers an Emergency Pack => No
2016-06-30 19:07 maite Issue Monitored: networkb
2016-07-01 12:50 aferraz Assigned To Triage Finance => markmm82
2016-07-08 09:25 vmromanos Assigned To markmm82 => AtulOpenbravo
2016-07-20 18:07 AtulOpenbravo Status new => scheduled
2016-07-22 13:44 aferraz Assigned To AtulOpenbravo => egoitz
2016-07-22 13:44 aferraz Status scheduled => feedback
2016-07-22 13:45 aferraz Note Added: 0088642
2016-08-03 08:58 maite Assigned To egoitz => AtulOpenbravo
2016-08-03 08:58 maite Status feedback => new
2016-08-04 09:33 aferraz Status new => scheduled
2016-08-17 12:48 hgbot Checkin
2016-08-17 12:48 hgbot Note Added: 0089178
2016-08-17 12:48 hgbot Status scheduled => resolved
2016-08-17 12:48 hgbot Resolution open => fixed
2016-08-17 12:48 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8150e26c692bfe5eb2947a7d6a5b57173ac43699 [^]
2016-08-17 12:49 aferraz Review Assigned To => aferraz
2016-08-17 12:49 aferraz Note Added: 0089179
2016-08-17 12:49 aferraz Status resolved => closed
2016-08-17 12:49 aferraz Fixed in Version => 3.0PR16Q4
2016-08-17 17:36 hudsonbot Checkin
2016-08-17 17:36 hudsonbot Note Added: 0089186

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker