Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0034599 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2016-11-22 18:11 | 2016-12-16 18:39 | |||
| Reporter | maite | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0PR17Q1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 80dac576712c | ||||
| 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 | 44532 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0034599: Performance problem in AcctServer process when posting a reconciliation with aprox 800 lines | |||||||
| Description | Process takes aprox 1.5h to post reconciliation document | |||||||
| Steps To Reproduce | I can provide environment where problem is reproducible | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0092413) hgbot (developer) 2016-12-15 12:59 |
Repository: erp/devel/pi Changeset: 80dac576712ce6a9cc24a18c483fe6d726744075 Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Wed Dec 14 15:54:12 2016 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/80dac576712ce6a9cc24a18c483fe6d726744075 [^] Fixes issue 34599: Bad performance when posting reconciliation with many lines ** Add m_RecordID2 member variable, getter and setter method in FactLine.java ** Set RecordID2 while Creating FactLine in Fact.java ** After successfully creation of FactLine, add RecordID2 to Set. ** Move UpdateBalancedDate in Fact.java ** For every 1000 records in RecordID2 Set, call UpdateBalancedDate method ** Set of 1000 records is nescessary to meet Oracle In clause restrictions. --- M src/org/openbravo/erpCommon/ad_forms/Fact.java M src/org/openbravo/erpCommon/ad_forms/FactLine.java M src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql --- |
|
(0092414) hgbot (developer) 2016-12-15 12:59 |
Repository: erp/devel/pi Changeset: ebd14e85e73d2dce2268d8254afbfc9c83bff61a Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> Date: Thu Dec 15 12:39:26 2016 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/ebd14e85e73d2dce2268d8254afbfc9c83bff61a [^] Related to issue 34599: Code review improvements Improve splitRecordID2Set method. --- M src/org/openbravo/erpCommon/ad_forms/Fact.java --- |
|
(0092415) aferraz (viewer) 2016-12-15 13:00 |
Code review + Testing OK |
|
(0092416) aferraz (viewer) 2016-12-15 13:03 |
Process has been improved from 1.5 hours to 18 seconds. |
|
(0092720) hudsonbot (viewer) 2016-12-16 18:39 |
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/dc8bf00badd0 [^] Maturity status: Test |
|
(0092721) hudsonbot (viewer) 2016-12-16 18:39 |
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/dc8bf00badd0 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-11-22 18:11 | maite | New Issue | |
| 2016-11-22 18:11 | maite | Assigned To | => Triage Finance |
| 2016-11-22 18:11 | maite | OBNetwork customer | => Yes |
| 2016-11-22 18:11 | maite | Modules | => Core |
| 2016-11-22 18:11 | maite | Support ticket | => 44532 |
| 2016-11-22 18:11 | maite | Resolution time | => 1480374000 |
| 2016-11-22 18:11 | maite | Triggers an Emergency Pack | => No |
| 2016-11-22 18:12 | maite | Issue Monitored: networkb | |
| 2016-11-22 19:16 | aferraz | Assigned To | Triage Finance => AtulOpenbravo |
| 2016-11-23 08:13 | heccam | Issue Monitored: heccam | |
| 2016-11-24 17:36 | aferraz | Resolution time | 1480374000 => 1481583600 |
| 2016-11-24 17:59 | AtulOpenbravo | Status | new => scheduled |
| 2016-12-15 12:59 | hgbot | Checkin | |
| 2016-12-15 12:59 | hgbot | Note Added: 0092413 | |
| 2016-12-15 12:59 | hgbot | Status | scheduled => resolved |
| 2016-12-15 12:59 | hgbot | Resolution | open => fixed |
| 2016-12-15 12:59 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/80dac576712ce6a9cc24a18c483fe6d726744075 [^] |
| 2016-12-15 12:59 | hgbot | Checkin | |
| 2016-12-15 12:59 | hgbot | Note Added: 0092414 | |
| 2016-12-15 13:00 | aferraz | Review Assigned To | => aferraz |
| 2016-12-15 13:00 | aferraz | Note Added: 0092415 | |
| 2016-12-15 13:00 | aferraz | Status | resolved => closed |
| 2016-12-15 13:00 | aferraz | Fixed in Version | => 3.0PR17Q1 |
| 2016-12-15 13:03 | aferraz | Note Added: 0092416 | |
| 2016-12-16 18:39 | hudsonbot | Checkin | |
| 2016-12-16 18:39 | hudsonbot | Note Added: 0092720 | |
| 2016-12-16 18:39 | hudsonbot | Checkin | |
| 2016-12-16 18:39 | hudsonbot | Note Added: 0092721 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |