Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028939Openbravo ERP09. Financial managementpublic2015-02-13 12:482015-03-26 15:52
Reportereduardo_Argal 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritycriticalReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1.2Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackYes
Summary0028939: Perfromance problem running module script in environments with large amount of transactions (invoices and orders)
DescriptionUpdateBpPaymentLine module script takes huge time to finish when updating from an environment with large amount of data (invoices and orders)
Steps To ReproduceExecute 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00291993.0PR15Q1.2 closed eduardo_Argal Perfromance problem running module script in environments with large amount of transactions (invoices and orders) 
related to defect 00305443.0PR15Q4 closed dmiguelez Perfromance problem running module script in environments with large amount of transactions in ORACLE (invoices and orders) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-02-13 12:48eduardo_ArgalNew Issue
2015-02-13 12:48eduardo_ArgalAssigned To => eduardo_Argal
2015-02-13 12:48eduardo_ArgalOBNetwork customer => No
2015-02-13 12:48eduardo_ArgalModules => Core
2015-02-13 12:48eduardo_ArgalTriggers an Emergency Pack => No
2015-02-25 18:24eduardo_ArgalStatusnew => scheduled
2015-02-25 18:24eduardo_Argalfix_in_branch => pi
2015-02-25 18:25eduardo_ArgalTriggers an Emergency PackNo => Yes
2015-02-25 18:25eduardo_Argalfix_in_branchpi =>
2015-03-06 17:03hgbotCheckin
2015-03-06 17:03hgbotNote Added: 0075260
2015-03-06 17:03hgbotStatusscheduled => resolved
2015-03-06 17:03hgbotResolutionopen => fixed
2015-03-06 17:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b9fc7e8e60ae95fd9a92c65ba2c6460c5151bbbc [^]
2015-03-09 11:56eduardo_ArgalStatusresolved => new
2015-03-09 11:56eduardo_ArgalResolutionfixed => open
2015-03-09 11:56eduardo_ArgalStatusnew => scheduled
2015-03-09 11:56eduardo_ArgalStatusscheduled => resolved
2015-03-09 11:56eduardo_ArgalResolutionopen => fixed
2015-03-09 17:49hudsonbotCheckin
2015-03-09 17:49hudsonbotNote Added: 0075334
2015-03-26 15:52vmromanosReview Assigned To => vmromanos
2015-03-26 15:52vmromanosNote Added: 0076019
2015-03-26 15:52vmromanosStatusresolved => closed
2015-08-11 12:34VictorVillarRelationship addedrelated to 0030544

Notes
(0075260)
hgbot   
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   
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   
2015-03-26 15:52   
Code review OK