Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0028939 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | critical | sometimes | 2015-02-13 12:48 | 2015-03-26 15:52 | |||
| Reporter | eduardo_Argal | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | b9fc7e8e60ae | ||||
| Projection | none | ETA | none | Target Version | 3.0PR15Q1.2 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | vmromanos | |||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | Yes | |||||||
| Summary | 0028939: Perfromance problem running module script in environments with large amount of transactions (invoices and orders) | |||||||
| Description | UpdateBpPaymentLine module script takes huge time to finish when updating from an environment with large amount of data (invoices and orders) | |||||||
| Steps To Reproduce | Execute update.database on a database with big amount of data (containing lots of invoices and orders). the issue was reproduced in an environment with 460000 invoices | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0075260) hgbot (developer) 2015-03-06 17:03 |
Repository: erp/devel/pi Changeset: b9fc7e8e60ae95fd9a92c65ba2c6460c5151bbbc Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Fri Mar 06 17:03:04 2015 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/b9fc7e8e60ae95fd9a92c65ba2c6460c5151bbbc [^] Fixes issue 28939 Perfromance problem running module script in environments with large amount of transactions (invoices and orders). New index is added in postgres environments when this is not present. Problem comes from table recreation, so impacts those who update from a version that requires invoice table rebuilding. --- M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateBpPaymentLine.class M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateBpPaymentLineData.class M src-util/modulescript/src/org/openbravo/modulescript/UpdateBpPaymentLine.java M src-util/modulescript/src/org/openbravo/modulescript/UpdateBpPaymentLine_data.xsql --- |
|
(0075334) hudsonbot (viewer) 2015-03-09 17:49 |
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/ef8a16dd11b3 [^] Maturity status: Test |
|
(0076019) vmromanos (viewer) 2015-03-26 15:52 |
Code review OK |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-02-13 12:48 | eduardo_Argal | New Issue | |
| 2015-02-13 12:48 | eduardo_Argal | Assigned To | => eduardo_Argal |
| 2015-02-13 12:48 | eduardo_Argal | OBNetwork customer | => No |
| 2015-02-13 12:48 | eduardo_Argal | Modules | => Core |
| 2015-02-13 12:48 | eduardo_Argal | Triggers an Emergency Pack | => No |
| 2015-02-25 18:24 | eduardo_Argal | Status | new => scheduled |
| 2015-02-25 18:24 | eduardo_Argal | fix_in_branch | => pi |
| 2015-02-25 18:25 | eduardo_Argal | Triggers an Emergency Pack | No => Yes |
| 2015-02-25 18:25 | eduardo_Argal | fix_in_branch | pi => |
| 2015-03-06 17:03 | hgbot | Checkin | |
| 2015-03-06 17:03 | hgbot | Note Added: 0075260 | |
| 2015-03-06 17:03 | hgbot | Status | scheduled => resolved |
| 2015-03-06 17:03 | hgbot | Resolution | open => fixed |
| 2015-03-06 17:03 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/b9fc7e8e60ae95fd9a92c65ba2c6460c5151bbbc [^] |
| 2015-03-09 11:56 | eduardo_Argal | Status | resolved => new |
| 2015-03-09 11:56 | eduardo_Argal | Resolution | fixed => open |
| 2015-03-09 11:56 | eduardo_Argal | Status | new => scheduled |
| 2015-03-09 11:56 | eduardo_Argal | Status | scheduled => resolved |
| 2015-03-09 11:56 | eduardo_Argal | Resolution | open => fixed |
| 2015-03-09 17:49 | hudsonbot | Checkin | |
| 2015-03-09 17:49 | hudsonbot | Note Added: 0075334 | |
| 2015-03-26 15:52 | vmromanos | Review Assigned To | => vmromanos |
| 2015-03-26 15:52 | vmromanos | Note Added: 0076019 | |
| 2015-03-26 15:52 | vmromanos | Status | resolved => closed |
| 2015-08-11 12:34 | VictorVillar | Relationship added | related to 0030544 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |