Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022233Openbravo ERP09. Financial managementpublic2012-11-08 09:582012-11-21 06:06
Reportermaite 
Assigned ToioritzCia 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP18Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022233: Performance problems in Payment Monitor background process
DescriptionPerformance problems in Payment Monitor background process
Steps To ReproduceIn an environment with huge amount of invoices, performance problems are experienced when scheduling this process
Proposed Solution2 possible point of problem are:

- OBCriteria conditions should be improved as, in a migrating instance, old invoices have "finalsettlement" field set to null. Due to current conditions they are being considered by background process when they should not.
Following condition (or similar) should be included:
Finalsettlement Is Null
          And Not Exists (Select 1 From Fin_Payment_Schedule Fps Where Fps.C_Invoice_Id=C_Invoice_Id)

- obc.list() action is performed. It should be substituted by Scrollable action
(patch attached with this changes)
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff 22233.diff (1,497) 2012-11-08 10:01
https://issues.openbravo.com/file_download.php?file_id=5715&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-11-08 09:58maiteNew Issue
2012-11-08 09:58maiteAssigned To => dmiguelez
2012-11-08 09:58maiteModules => Advanced Payables and Receivables Mngmt
2012-11-08 09:58maiteTarget Version => 3.0MP18
2012-11-08 10:01maiteFile Added: 22233.diff
2012-11-08 10:01maiteIssue Monitored: networkb
2012-11-08 11:34dmiguelezAssigned Todmiguelez => jonalegriaesarte
2012-11-08 13:46ioritzCiaAssigned Tojonalegriaesarte => ioritzCia
2012-11-08 16:22egoitzIssue Monitored: egoitz
2012-11-13 18:41hgbotCheckin
2012-11-13 18:41hgbotNote Added: 0054213
2012-11-13 18:41hgbotStatusnew => resolved
2012-11-13 18:41hgbotResolutionopen => fixed
2012-11-13 18:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ddaa51b1b0e12937ca61189aa6ff5534ae1b489a [^]
2012-11-15 10:37maiteNote Added: 0054255
2012-11-15 10:37maiteStatusresolved => closed
2012-11-21 06:06hudsonbotCheckin
2012-11-21 06:06hudsonbotNote Added: 0054376

Notes
(0054213)
hgbot   
2012-11-13 18:41   
Repository: erp/devel/pi
Changeset: ddaa51b1b0e12937ca61189aa6ff5534ae1b489a
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Tue Nov 13 10:20:19 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ddaa51b1b0e12937ca61189aa6ff5534ae1b489a [^]

Fixes issue 22233: Performance problems in Payment Monitor background process.

---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_PaymentMonitorProcess.java
---
(0054255)
maite   
2012-11-15 10:37   
verified
(0054376)
hudsonbot   
2012-11-21 06:06   
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/c3c5e61b0164 [^]

Maturity status: Test