Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024723Openbravo ERPA. Platformpublic2013-09-09 18:282013-09-23 10:27
Reporteregoitz 
Assigned Topramakrishnan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP28Fixed in Version3.0MP28 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024723: Performance problem when opening a row on the transacctions tab on the financial account window
DescriptionWhen there are a lot of payments on the application when opening a transaction row on the financial account window it takes long to load the data.

The problem is tha fin_payment_id field:

- Warning: In the window Financial Account, in tab Transaction the combo fields inpfinPaymentId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo.
Steps To Reproduce-ON an application with more than 1000 payments open a row on the transaction tab, on the financial account window.

It takes long to load and on the log you get the following message:

- Warning: In the window Financial Account, in tab Transaction the combo fields inpfinPaymentId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo.
Proposed Solution-Change the reference to OBUISelector Reference, and the reference search key to Payment Selector
Additional Information
TagsPerformance
Relationships
duplicate of defect 00243643.0MP29 closed caristu Payment selector in Financial account - Transaction window is causing performance problems 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-09-09 18:28egoitzNew Issue
2013-09-09 18:28egoitzAssigned To => AugustoMauch
2013-09-09 18:28egoitzModules => Core
2013-09-09 18:28egoitzOBNetwork customer => Yes
2013-09-09 18:28egoitzTriggers an Emergency Pack => No
2013-09-09 18:32egoitzTag Attached: Performance
2013-09-10 08:31alostaleAssigned ToAugustoMauch => dmiguelez
2013-09-15 12:00pramakrishnanAssigned Todmiguelez => pramakrishnan
2013-09-15 12:03pramakrishnanReview Assigned To => egoitz
2013-09-15 12:03pramakrishnanStatusnew => scheduled
2013-09-15 12:04hgbotCheckin
2013-09-15 12:04hgbotNote Added: 0061162
2013-09-15 12:04hgbotStatusscheduled => resolved
2013-09-15 12:04hgbotResolutionopen => fixed
2013-09-15 12:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/641fafa5187050c3e105d564f5c13e445e35b499 [^]
2013-09-17 19:03hudsonbotCheckin
2013-09-17 19:03hudsonbotNote Added: 0061253
2013-09-23 10:27egoitzNote Added: 0061345
2013-09-23 10:27egoitzStatusresolved => closed
2013-09-23 10:27egoitzFixed in Version => 3.0MP28
2013-10-21 12:56caristuRelationship addedduplicate of 0024364

Notes
(0061162)
hgbot   
2013-09-15 12:04   
Repository: erp/devel/pi
Changeset: 641fafa5187050c3e105d564f5c13e445e35b499
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Sun Sep 15 15:32:37 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/641fafa5187050c3e105d564f5c13e445e35b499 [^]

Fixes Issue 24723: Performance problem in transactions tab in financial account

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0061253)
hudsonbot   
2013-09-17 19:03   
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/1c53d622fc50 [^]

Maturity status: Test
(0061345)
egoitz   
2013-09-23 10:27   
verified