Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029199
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementcriticalsometimes2015-02-13 12:482015-04-01 08:31
Reportereduardo_ArgalView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionca337ee89a85
ProjectionnoneETAnoneTarget Version3.0PR15Q1.2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0029199: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00305443.0PR15Q4 closeddmiguelez Perfromance problem running module script in environments with large amount of transactions in ORACLE (invoices and orders) 
blocks defect 00289393.0PR15Q1.2 closededuardo_Argal Perfromance problem running module script in environments with large amount of transactions (invoices and orders) 

-  Notes
(0075309)
hgbot (developer)
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 (developer)
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 (viewer)
2015-03-26 15:51

 Code review OK
(0076199)
hgbot (developer)
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 (developer)
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 (administrator)
2015-04-01 08:31

 closed again, as the status changed due the merge tag of 3.0PR15Q1.2 to backports/3.0PR15Q2

- Issue History
Date Modified Username Field Change
2015-03-09 11:56 eduardo_Argal Type defect => backport
2015-03-09 12:13 hgbot Checkin
2015-03-09 12:13 hgbot Note Added: 0075309
2015-03-09 12:13 hgbot Status scheduled => resolved
2015-03-09 12:13 hgbot Resolution open => fixed
2015-03-09 12:13 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/b9fc7e8e60ae95fd9a92c65ba2c6460c5151bbbc [^] => http://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/ca337ee89a855c93b7889b3f958a4972e0327876 [^]
2015-03-10 11:12 hgbot Checkin
2015-03-10 11:12 hgbot Note Added: 0075370
2015-03-26 15:51 vmromanos Review Assigned To => vmromanos
2015-03-26 15:51 vmromanos Note Added: 0076018
2015-03-26 15:51 vmromanos Status resolved => closed
2015-04-01 08:05 hgbot Checkin
2015-04-01 08:05 hgbot Note Added: 0076199
2015-04-01 08:05 hgbot Status closed => resolved
2015-04-01 08:05 hgbot Fixed in SCM revision http://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/ca337ee89a855c93b7889b3f958a4972e0327876 [^] => http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/ca337ee89a855c93b7889b3f958a4972e0327876 [^]
2015-04-01 08:06 hgbot Checkin
2015-04-01 08:06 hgbot Note Added: 0076204
2015-04-01 08:31 priyam Status resolved => closed
2015-04-01 08:31 priyam Note Added: 0076271
2015-08-11 12:34 VictorVillar Relationship added related to 0030544

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker