Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0020358
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 09. Financial managementminoralways2012-04-26 12:062012-09-13 10:42
ReporteregoitzView Statuspublic 
Assigned Todmiguelez 
PriorityhighResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision8d41e9b2be65
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP10.1SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0020358: Problems when calculating the linked items when the elment is referened from fin_orig_payment_sched_v view

DescriptionWhen calculating linked items on sales order window it takes long to calculate them.
The problem is when looking if there are elements on fin_orig_payment_sched_v (sales / purchase) that reference to the current row.

Steps To ReproduceOn a application with 16137 rows on fin_orig_paym_scheddetai table, go to sales order window and click on linked items section.
See that more than 20 seconds are needed to calculate the linked items
TagsPerformance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate defect 00203393.0MP12 closedmarvintm Linked items takes longs to be loaded when the tables fin_orig_payment_schedule and fin_orig_paym_scheddetail had arround 15000 

-  Notes
(0048012)
egoitz (developer)
2012-04-26 12:37

Resolved with that commit;
https://code.openbravo.com/erp/devel/pi/rev/c88ce1de44de [^]
(0048021)
hgbot (developer)
2012-04-26 12:50

Repository: erp/devel/pi
Changeset: 153cac4dbab2d666163285b169910f12961a05f5
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Thu Apr 26 12:49:00 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/153cac4dbab2d666163285b169910f12961a05f5 [^]

Fixed Issue 0020358: Revert the previous chan ge

---
M src-db/database/model/views/FIN_ORIG_PAYMENT_SCHED_V.xml
---
(0048156)
hudsonbot (developer)
2012-04-28 02:31

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/cd923b317af4 [^]

Maturity status: Test
(0048159)
hudsonbot (developer)
2012-04-28 02:31

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/cd923b317af4 [^]

Maturity status: Test
(0048332)
hgbot (developer)
2012-05-03 13:42

Repository: erp/devel/pi
Changeset: 8d41e9b2be6524bec2256a6efde1edbb5519de59
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Thu May 03 13:41:55 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8d41e9b2be6524bec2256a6efde1edbb5519de59 [^]

Fixed issue 20358: long time to calculate linked items

---
M src-db/database/model/views/FIN_ORIG_PAYMENT_SCHED_V.xml
---
(0048339)
hgbot (developer)
2012-05-03 16:02

Repository: erp/devel/pi
Changeset: 18676afefe0ca9b4702772601c6ac900c133b4d8
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Thu May 03 16:01:58 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/18676afefe0ca9b4702772601c6ac900c133b4d8 [^]

Backout issue 20358

---
M src-db/database/model/views/FIN_ORIG_PAYMENT_SCHED_V.xml
---
(0049008)
hudsonbot (developer)
2012-05-25 12:09

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/5401e185a8b0 [^]

Maturity status: Test
(0049011)
hudsonbot (developer)
2012-05-25 12:09

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/5401e185a8b0 [^]

Maturity status: Test
(0051079)
egoitz (developer)
2012-08-02 12:14

After remove the original payment plan from core the view affecting the performance does not exist so the problem does not happen.

- Issue History
Date Modified Username Field Change
2012-04-26 12:06 egoitz New Issue
2012-04-26 12:06 egoitz Assigned To => egoitz
2012-04-26 12:06 egoitz Modules => Core
2012-04-26 12:06 egoitz Tag Attached: Performance
2012-04-26 12:07 egoitz Relationship added has duplicate 0020339
2012-04-26 12:34 egoitz Fixed in SCM revision => c88ce1de44de
2012-04-26 12:35 egoitz Fixed in SCM revision c88ce1de44de => https://code.openbravo.com/erp/devel/pi/rev/c88ce1de44de [^]
2012-04-26 12:36 egoitz Status new => scheduled
2012-04-26 12:36 egoitz fix_in_branch => pi
2012-04-26 12:36 egoitz Status scheduled => resolved
2012-04-26 12:36 egoitz Fixed in Version => 3.0MP11
2012-04-26 12:36 egoitz Resolution open => fixed
2012-04-26 12:37 egoitz Note Added: 0048012
2012-04-26 12:38 egoitz Note Added: 0048013
2012-04-26 12:39 egoitz Note Added: 0048014
2012-04-26 12:50 hgbot Checkin
2012-04-26 12:50 hgbot Note Added: 0048021
2012-04-26 12:50 hgbot Fixed in SCM revision https://code.openbravo.com/erp/devel/pi/rev/c88ce1de44de [^] => http://code.openbravo.com/erp/devel/pi/rev/153cac4dbab2d666163285b169910f12961a05f5 [^]
2012-04-26 12:51 egoitz Status resolved => new
2012-04-26 12:51 egoitz Resolution fixed => open
2012-04-26 12:51 egoitz Fixed in Version 3.0MP11 =>
2012-04-26 12:51 egoitz Note Deleted: 0048014
2012-04-26 12:51 egoitz Note Deleted: 0048013
2012-04-28 02:31 hudsonbot Checkin
2012-04-28 02:31 hudsonbot Note Added: 0048156
2012-04-28 02:31 hudsonbot Checkin
2012-04-28 02:31 hudsonbot Note Added: 0048159
2012-05-03 13:42 hgbot Checkin
2012-05-03 13:42 hgbot Note Added: 0048332
2012-05-03 13:42 hgbot Status new => resolved
2012-05-03 13:42 hgbot Resolution open => fixed
2012-05-03 13:42 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/153cac4dbab2d666163285b169910f12961a05f5 [^] => http://code.openbravo.com/erp/devel/pi/rev/8d41e9b2be6524bec2256a6efde1edbb5519de59 [^]
2012-05-03 16:02 hgbot Checkin
2012-05-03 16:02 hgbot Note Added: 0048339
2012-05-03 16:43 egoitz Status resolved => new
2012-05-03 16:43 egoitz Resolution fixed => open
2012-05-25 12:09 hudsonbot Checkin
2012-05-25 12:09 hudsonbot Note Added: 0049008
2012-05-25 12:09 hudsonbot Checkin
2012-05-25 12:09 hudsonbot Note Added: 0049011
2012-05-28 09:44 egoitz Priority urgent => high
2012-05-28 09:44 egoitz Severity major => minor
2012-05-28 09:44 egoitz Target Version 3.0MP12 => 3.0MP13
2012-05-28 09:44 egoitz fix_in_branch pi =>
2012-06-27 11:53 egoitz Target Version 3.0MP13 => 3.0MP14
2012-07-25 10:59 jonalegriaesarte Type defect => design defect
2012-07-25 10:59 jonalegriaesarte Target Version 3.0MP14 =>
2012-08-02 12:14 egoitz Note Added: 0051079
2012-08-02 12:14 egoitz Status new => closed
2012-08-02 12:14 egoitz Resolution open => no change required
2012-09-13 10:42 jonalegriaesarte Assigned To egoitz => dmiguelez


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker