Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029199Openbravo ERP09. Financial managementpublic2015-02-13 12:482015-04-01 08:31
Reportereduardo_Argal 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritycriticalReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1.2Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackYes
Summary0029199: 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
related to defect 00305443.0PR15Q4 closed dmiguelez Perfromance problem running module script in environments with large amount of transactions in ORACLE (invoices and orders) 
blocks defect 00289393.0PR15Q1.2 closed eduardo_Argal Perfromance problem running module script in environments with large amount of transactions (invoices and orders) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-09 11:56eduardo_ArgalTypedefect => backport
2015-03-09 12:13hgbotCheckin
2015-03-09 12:13hgbotNote Added: 0075309
2015-03-09 12:13hgbotStatusscheduled => resolved
2015-03-09 12:13hgbotResolutionopen => fixed
2015-03-09 12:13hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/b9fc7e8e60ae95fd9a92c65ba2c6460c5151bbbc [^] => http://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/ca337ee89a855c93b7889b3f958a4972e0327876 [^]
2015-03-10 11:12hgbotCheckin
2015-03-10 11:12hgbotNote Added: 0075370
2015-03-26 15:51vmromanosReview Assigned To => vmromanos
2015-03-26 15:51vmromanosNote Added: 0076018
2015-03-26 15:51vmromanosStatusresolved => closed
2015-04-01 08:05hgbotCheckin
2015-04-01 08:05hgbotNote Added: 0076199
2015-04-01 08:05hgbotStatusclosed => resolved
2015-04-01 08:05hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/ca337ee89a855c93b7889b3f958a4972e0327876 [^] => http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/ca337ee89a855c93b7889b3f958a4972e0327876 [^]
2015-04-01 08:06hgbotCheckin
2015-04-01 08:06hgbotNote Added: 0076204
2015-04-01 08:31priyamStatusresolved => closed
2015-04-01 08:31priyamNote Added: 0076271
2015-08-11 12:34VictorVillarRelationship addedrelated to 0030544

Notes
(0075309)
hgbot   
2015-03-09 12:13   
Repository: erp/backports/3.0PR15Q1.2
Changeset: ca337ee89a855c93b7889b3f958a4972e0327876
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Mar 09 11:59:44 2015 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/ca337ee89a855c93b7889b3f958a4972e0327876 [^]

Fixes issue 29199
Fixes performance problem when missing index

---
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
---
(0075370)
hgbot   
2015-03-10 11:12   
Repository: erp/backports/3.0PR15Q1.2
Changeset: 06304f2fc541a6f454a5170717f5623be76330ef
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Mar 10 11:11:51 2015 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/06304f2fc541a6f454a5170717f5623be76330ef [^]

Related to issue 29199
Problem with generated classes

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateBpPaymentLine.class
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateBpPaymentLineData.class
---
(0076018)
vmromanos   
2015-03-26 15:51   
Code review OK
(0076199)
hgbot   
2015-04-01 08:05   
Repository: erp/backports/3.0PR15Q2
Changeset: ca337ee89a855c93b7889b3f958a4972e0327876
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Mar 09 11:59:44 2015 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/ca337ee89a855c93b7889b3f958a4972e0327876 [^]

Fixes issue 29199
Fixes performance problem when missing index

---
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
---
(0076204)
hgbot   
2015-04-01 08:06   
Repository: erp/backports/3.0PR15Q2
Changeset: 06304f2fc541a6f454a5170717f5623be76330ef
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Mar 10 11:11:51 2015 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/06304f2fc541a6f454a5170717f5623be76330ef [^]

Related to issue 29199
Problem with generated classes

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateBpPaymentLine.class
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateBpPaymentLineData.class
---
(0076271)
priyam   
2015-04-01 08:31   
closed again, as the status changed due the merge tag of 3.0PR15Q1.2 to backports/3.0PR15Q2