Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0033398 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2016-06-30 19:07 | 2016-08-17 17:36 | |||
| Reporter | maite | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0PR16Q4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 8150e26c692b | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | aferraz | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | 42323 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0033398: "selectDocumentsDates" does not finish in case huge number of organizations and opened period control | |||||||
| Description | selectDocumentsDates 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0088642) aferraz (viewer) 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 (viewer) 2016-08-17 12:49 |
Code review + Testing OK |
|
(0089186) hudsonbot (viewer) 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 |
|
Notes |
|
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 | OBNetwork customer | => Yes |
| 2016-06-30 19:07 | maite | Modules | => Core |
| 2016-06-30 19:07 | maite | Support ticket | => 42323 |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |