Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025355Openbravo ERP09. Financial managementpublic2013-12-17 18:382015-06-02 03:42
Reporteregoitz 
Assigned Tofsoto82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025355: Long time to show the lines on the payment in/out windows
DescriptionOn payments with many lines it takes long to show the lines
Steps To Reproduce-On an environment with more than 200.000 rows on the fin_payment_scheduledetail table click on a payment with arround 10 lines.
*It takes long to show the data.

The problems is on the select with the following view:

FIN_PAYMENT_SCHED_INV_V

that also uses a view:

FIN_PAYMENT_DETAIL_V
Proposed SolutionRedesign the views used on the lines tab.
Additional Information
TagsPerformance
Relationships
related to defect 00260013.0PR14Q3 closed shankarb Tab is empty when defined with Disable Parent key Property 
causes defect 00300703.0PR15Q3 closed aferraz NPE in Payment In/Out Lines when navigating from Order/Invoice Payment Schedule and it is null 
causes defect 0030080 closed vmromanos Improve user experience in Payment In/Out lines tab 
causes defect 0032233 closed inigosanchez Payment In and Payment Out lines are not exported to CSV 
causes defect 0033288 closed markmm82 Linked items error in Payment Plan window when invoice is not paid 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-12-17 18:38egoitzNew Issue
2013-12-17 18:38egoitzAssigned To => dmiguelez
2013-12-17 18:38egoitzModules => Core
2013-12-17 18:38egoitzResolution time => 1357945200
2013-12-17 18:38egoitzTriggers an Emergency Pack => No
2013-12-17 18:39egoitzTag Attached: Performance
2014-01-02 12:20dmiguelezAssigned Todmiguelez => jonalegriaesarte
2014-03-12 10:43jonalegriaesarteResolution time1357945200 => 1363302000
2014-03-13 12:37jonalegriaesarteResolution time1363302000 =>
2014-03-13 12:37jonalegriaesarteNote Added: 0065132
2014-03-13 12:37jonalegriaesarteTypedefect => design defect
2014-03-13 12:37jonalegriaesarteTarget VersionPR14Q2 =>
2014-03-13 12:38jonalegriaesarteAssigned Tojonalegriaesarte => eduardo_Argal
2014-03-26 16:39egoitzRelationship addedrelated to 0026001
2014-07-11 11:58dmitry_mezentsevNote Added: 0068588
2014-08-06 19:22dmitry_mezentsevNote Added: 0069107
2014-09-05 14:16dmitry_mezentsevNote Added: 0069984
2014-09-09 11:36egoitzNote Added: 0070047
2014-09-09 15:24dmitry_mezentsevNote Added: 0070055
2014-09-24 11:13dmitry_mezentsevNote Added: 0070308
2015-02-05 15:26fsoto82Statusnew => scheduled
2015-02-05 15:26fsoto82Assigned Toeduardo_Argal => fsoto82
2015-02-05 15:26fsoto82fix_in_branch => pi
2015-05-29 13:37hgbotCheckin
2015-05-29 13:37hgbotNote Added: 0077890
2015-05-29 13:37hgbotStatusscheduled => resolved
2015-05-29 13:37hgbotResolutionopen => fixed
2015-05-29 13:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/15dbf5983411271754cdb97c5d993a241b395601 [^]
2015-05-29 13:37hgbotCheckin
2015-05-29 13:37hgbotNote Added: 0077891
2015-05-29 13:37hgbotCheckin
2015-05-29 13:37hgbotNote Added: 0077892
2015-05-29 13:38vmromanosReview Assigned To => vmromanos
2015-05-29 13:38vmromanosNote Added: 0077893
2015-05-29 13:38vmromanosStatusresolved => closed
2015-06-01 11:10hgbotCheckin
2015-06-01 11:10hgbotNote Added: 0077919
2015-06-02 03:42hudsonbotCheckin
2015-06-02 03:42hudsonbotNote Added: 0077957
2015-06-02 03:42hudsonbotCheckin
2015-06-02 03:42hudsonbotNote Added: 0077958
2015-06-02 03:42hudsonbotCheckin
2015-06-02 03:42hudsonbotNote Added: 0077959
2015-06-02 12:01aferrazRelationship addedcauses 0030070
2015-06-03 09:34vmromanosRelationship addedcauses 0030080
2016-02-16 16:01inigosanchezRelationship addedcauses 0032233
2016-06-20 10:11aferrazRelationship addedcauses 0033288

Notes
(0065132)
jonalegriaesarte   
2014-03-13 12:37   
Moved to design defect because the windows needs to be rebuilt
(0068588)
dmitry_mezentsev   
2014-07-11 11:58   
Eduardo,

As far as I understood you this issue is fixed in Q3 release, right?
(0069107)
dmitry_mezentsev   
2014-08-06 19:22   
Egoitz,

Eduardo is commenting that you have a patch to test. Were you able to do it in a customer environment?
(0069984)
dmitry_mezentsev   
2014-09-05 14:16   
Ping!
(0070047)
egoitz   
2014-09-09 11:36   
The patch of the related issue improves the performance.
Now the lines are shown much faster. For a payment with 100 lines
has improved from more than a minute to show the lines to around 5 seconds.
(0070055)
dmitry_mezentsev   
2014-09-09 15:24   
Good news!
Thanks.

Eduardo,
Could you resolve the issue then please?
(0070308)
dmitry_mezentsev   
2014-09-24 11:13   
Eduardo,

Ping!
If it works we need to put it in Q4.
(0077890)
hgbot   
2015-05-29 13:37   
Repository: erp/devel/pi
Changeset: 15dbf5983411271754cdb97c5d993a241b395601
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Fri Feb 13 10:20:41 2015 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/15dbf5983411271754cdb97c5d993a241b395601 [^]

Fixed bug 25355: Long time to show the lines on the payment in/out windows

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_DIMENSION_MAPPING.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_TAB.xml
---
(0077891)
hgbot   
2015-05-29 13:37   
Repository: erp/devel/pi
Changeset: 093fb9ca1c6d340260547fedf9fbc79ef60e5976
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Feb 26 18:09:18 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/093fb9ca1c6d340260547fedf9fbc79ef60e5976 [^]

Related to issue 25355: Fix Dimension fields display

Dimension fields display in Payment In Lines and Payment Out Lines tabs will now work with Accounting Dimensions Central Maintenance.
Also, Order Payment Schedule and Invoice Payment Schedule fields navigation has been fixed.

---
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_DIMENSION_MAPPING.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/erpCommon/utility/ReferencedLink.java
---
(0077892)
hgbot   
2015-05-29 13:37   
Repository: erp/devel/pi
Changeset: 38c6321b2ad980cb1be2f459e13d753b5fb4e9bb
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue May 12 09:36:15 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/38c6321b2ad980cb1be2f459e13d753b5fb4e9bb [^]

Related to issue 25355: Executed Synchronize Terminology

---
M src-db/database/sourcedata/AD_FIELD.xml
---
(0077893)
vmromanos   
2015-05-29 13:38   
Code review + testing OK
(0077919)
hgbot   
2015-06-01 11:10   
Repository: tools/automation/int
Changeset: 572d26a20bb667b8b196d5ec52631a12b3c4f6a0
Author: Pablo Lujan <pablo.lujan <at> openbravo.com>
Date: Sun May 31 23:59:27 2015 +0200
URL: http://code.openbravo.com/tools/automation/int/rev/572d26a20bb667b8b196d5ec52631a12b3c4f6a0 [^]

Related with issue 25355 - Changes to automated tests

---
M src-test/com/openbravo/test/integration/erp/data/financial/receivablespayables/transactions/paymentin/PaymentInLinesData.java
M src-test/com/openbravo/test/integration/erp/data/financial/receivablespayables/transactions/paymentout/PaymentOutLinesData.java
M src-test/com/openbravo/test/integration/erp/gui/financial/receivablespayables/transactions/paymentin/PaymentInLinesTab.java
M src-test/com/openbravo/test/integration/erp/gui/financial/receivablespayables/transactions/paymentout/PaymentOutLinesTab.java
---
(0077957)
hudsonbot   
2015-06-02 03:42   
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/14de467bd788 [^]
Maturity status: Test
(0077958)
hudsonbot   
2015-06-02 03:42   
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/14de467bd788 [^]
Maturity status: Test
(0077959)
hudsonbot   
2015-06-02 03:42   
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/14de467bd788 [^]
Maturity status: Test