Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026502Openbravo ERPZ. Otherspublic2014-05-09 12:432014-10-01 16:36
Reporterjecharri 
Assigned ToSandrahuguet 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q2Fixed in Version 
Merge Request Status
Review Assigned Tojecharri
OBNetwork customerNo
Web browserGoogle Chrome
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression levelProduction - QA Approved
Regression date2014-02-11
Regression introduced in release3.0PR14Q2
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/87765308f9bd [^]
Triggers an Emergency PackYes
Summary0026502: Performance of module script InitializeIsPaymentPaid is bad in Q2
DescriptionPerformance of module script InitializeIsPaymentPaid is bad in Q2
Steps To Reproduce-Upgrade one instance with 250000 payment schedule detail to Q2

You will see that module script never ends
Proposed Solution
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-05-09 12:43jecharriNew Issue
2014-05-09 12:43jecharriAssigned To => dmiguelez
2014-05-09 12:43jecharriWeb browser => Google Chrome
2014-05-09 12:43jecharriModules => Advanced Payables and Receivables Mngmt
2014-05-09 12:43jecharriOBNetwork customer => No
2014-05-09 12:43jecharriTriggers an Emergency Pack => No
2014-05-09 12:46jecharriWeb browserGoogle Chrome => Google Chrome
2014-05-09 12:46jecharriResolution time => 1400536800
2014-05-09 12:46jecharriRegression level => Production - QA Approved
2014-05-09 12:46jecharriRegression date => 2014-02-11
2014-05-09 12:46jecharriRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/87765308f9bd [^]
2014-05-09 12:46jecharriTriggers an Emergency PackNo => Yes
2014-05-09 12:48jecharriTag Attached: Performance
2014-05-09 12:48jecharriTag Attached: per
2014-05-09 12:48jecharriTag Detached: per
2014-05-09 12:52jecharriAssigned Todmiguelez => Sandrahuguet
2014-05-09 13:42hgbotCheckin
2014-05-09 13:42hgbotNote Added: 0067039
2014-05-09 13:42hgbotStatusnew => resolved
2014-05-09 13:42hgbotResolutionopen => fixed
2014-05-09 13:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5ef5b7acfcbd5d3509e25938572e472af9770223 [^]
2014-05-09 15:55hgbotCheckin
2014-05-09 15:55hgbotNote Added: 0067042
2014-05-12 13:02jecharriReview Assigned To => jecharri
2014-05-12 13:02jecharriNote Added: 0067088
2014-05-12 13:02jecharriStatusresolved => closed
2014-05-12 17:35hudsonbotCheckin
2014-05-12 17:35hudsonbotNote Added: 0067096
2014-05-12 17:35hudsonbotCheckin
2014-05-12 17:35hudsonbotNote Added: 0067098
2014-10-01 16:36plujanWeb browserGoogle Chrome => Google Chrome
2014-10-01 16:36plujanRegression introduced in release => 3.0PR14Q2

Notes
(0067039)
hgbot   
2014-05-09 13:42   
Repository: erp/devel/pi
Changeset: 5ef5b7acfcbd5d3509e25938572e472af9770223
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri May 09 13:41:51 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5ef5b7acfcbd5d3509e25938572e472af9770223 [^]

Fixed bug 26502 Improve performance of modulescript InitializeIsPaymentPaid

---
M src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeIsPaymentPaidData.class
M src-util/modulescript/src/org/openbravo/modulescript/InitializeIsPaymentPaid_data.xsql
---
(0067042)
hgbot   
2014-05-09 15:55   
Repository: erp/devel/pi
Changeset: caaec458a53c920fe43f054bc96454a03c66bf18
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri May 09 14:56:09 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/caaec458a53c920fe43f054bc96454a03c66bf18 [^]

Related to issue 26502

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeIsPaymentPaidData.class
M src-util/modulescript/src/org/openbravo/modulescript/InitializeIsPaymentPaid_data.xsql
---
(0067088)
jecharri   
2014-05-12 13:02   
Verified in a client environment
(0067096)
hudsonbot   
2014-05-12 17:35   
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/8bdb56ba8f66 [^]
Maturity status: Test
(0067098)
hudsonbot   
2014-05-12 17:35   
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/8bdb56ba8f66 [^]
Maturity status: Test