Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027727Openbravo ERP09. Financial managementpublic2014-10-01 18:192015-02-09 21:48
Reporteregoitz 
Assigned Toaferraz 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR15Q2 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027727: Performance problems on the "Wrong sales invoice. Wrong amount in payment plan detail" ALERT
DescriptionPerformance problems on the "Wrong sales invoice. Wrong amount in payment plan detail" ALERT.
On environment with big amount of that on the tables involved on the alertrule it takes long to be executed.

Data volume:
'fin_payment_schedule';890239
'fin_payment_scheduledetail';456669
'c_invoice';434864
'ad_org';22
Steps To ReproduceOn an environment with big amount of data execute the query of the alert
Proposed Solutionhttps://issues.openbravo.com/view.php?id=26203 [^]
Additional Information
TagsPerformance
Relationships
depends on feature request 0026203 new AugustoMauch Add the possibility to specify the alerts to be executed on each background scheduling 
related to defect 0027809 closed reinaldoguerra The Wrong sales invoice. Wrong amount in payment plan detail ALERT can not be properly deactivated. 
Not all the children of this issue are yet resolved or closed.
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-10-01 18:19egoitzNew Issue
2014-10-01 18:19egoitzAssigned To => dmiguelez
2014-10-01 18:19egoitzModules => Core
2014-10-01 18:19egoitzTriggers an Emergency Pack => No
2014-10-01 18:24egoitzNote Added: 0070623
2014-10-01 18:49egoitzProposed Solution updated
2014-10-01 19:00egoitzProposed Solution updated
2014-10-01 19:00egoitzRelationship addeddepends on 0026203
2014-10-02 10:31egoitzNote Added: 0070648
2014-10-06 16:30jonalegriaesarteResolution time => 1414796400
2014-10-09 10:56egoitzRelationship addedrelated to 0027809
2014-10-16 10:34jonalegriaesarteTag Attached: Performance
2014-10-31 13:09dmitry_mezentsevAssigned Todmiguelez => Sandrahuguet
2014-11-11 15:55SandrahuguetAssigned ToSandrahuguet => reinaldoguerra
2015-02-03 18:19SandrahuguetAssigned Toreinaldoguerra => aferraz
2015-02-06 12:19aferrazNote Added: 0074249
2015-02-06 13:03aferrazNote Edited: 0074249bug_revision_view_page.php?bugnote_id=0074249#r7639
2015-02-09 12:44hgbotCheckin
2015-02-09 12:44hgbotNote Added: 0074283
2015-02-09 12:44hgbotStatusnew => resolved
2015-02-09 12:44hgbotResolutionopen => fixed
2015-02-09 12:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d4a650e1890c13c11aa8dec64b667a8f3d8045d1 [^]
2015-02-09 12:45SandrahuguetReview Assigned To => Sandrahuguet
2015-02-09 12:45SandrahuguetNote Added: 0074284
2015-02-09 12:45SandrahuguetStatusresolved => closed
2015-02-09 12:45SandrahuguetFixed in Version => 3.0PR15Q2
2015-02-09 21:48hudsonbotCheckin
2015-02-09 21:48hudsonbotNote Added: 0074306

Notes
(0070623)
egoitz   
2014-10-01 18:24   
The alert is being created by the following modulescript:
https://code.openbravo.com/erp/devel/pi/file/d4ef13fecc97/modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoices.java [^]
(0070648)
egoitz   
2014-10-02 10:31   
Othe possibility could be to call the java of the modulescript from a background process and have the alert defined as E.
(0074249)
aferraz   
2015-02-06 12:19   
(edited on: 2015-02-06 13:03)
Tes plan:

- Realize AlertsForWrongInvoices modulescript only runs the first time you make "ant update.database"
(0074283)
hgbot   
2015-02-09 12:44   
Repository: erp/devel/pi
Changeset: d4a650e1890c13c11aa8dec64b667a8f3d8045d1
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Feb 06 12:55:58 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d4a650e1890c13c11aa8dec64b667a8f3d8045d1 [^]

Fixes issue 27727: Performance problems on AlertsForWrongInvoices modulescript

A preference has been added to AlertsForWrongInvoices modulescript in order to execute it only one time.

---
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoices.class
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoicesData.class
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoices.java
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoices_data.xsql
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoicesData.java
---
(0074284)
Sandrahuguet   
2015-02-09 12:45   
Code review + testing OK
(0074306)
hudsonbot   
2015-02-09 21:48   
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/d68c131a3f59 [^]
Maturity status: Test