Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0034599 | Openbravo ERP | 09. Financial management | public | 2016-11-22 18:11 | 2016-12-16 18:39 |
|
| Reporter | maite | |
| Assigned To | AtulOpenbravo | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q1 | |
| Merge Request Status | |
| Review Assigned To | aferraz |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| 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 |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| 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 | Modules | => Core |
| 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 | |
|
Notes |
|
|
(0092413)
|
|
hgbot
|
|
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
|
|
2016-12-15 12:59
|
|
|
|
|
|
|
|
|
|
|
Process has been improved from 1.5 hours to 18 seconds. |
|
|
|
|
|
|
|
|
|