Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020358Openbravo ERP09. Financial managementpublic2012-04-26 12:062012-09-13 10:42
Reporteregoitz 
Assigned Todmiguelez 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version3.0MP10.1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020358: 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
Proposed Solution
Additional Information
TagsPerformance
Relationships
has duplicate defect 00203393.0MP12 closed marvintm Linked items takes longs to be loaded when the tables fin_orig_payment_schedule and fin_orig_paym_scheddetail had arround 15000 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-04-26 12:06egoitzNew Issue
2012-04-26 12:06egoitzAssigned To => egoitz
2012-04-26 12:06egoitzModules => Core
2012-04-26 12:06egoitzTag Attached: Performance
2012-04-26 12:07egoitzRelationship addedhas duplicate 0020339
2012-04-26 12:34egoitzFixed in SCM revision => c88ce1de44de
2012-04-26 12:35egoitzFixed in SCM revisionc88ce1de44de => https://code.openbravo.com/erp/devel/pi/rev/c88ce1de44de [^]
2012-04-26 12:36egoitzStatusnew => scheduled
2012-04-26 12:36egoitzfix_in_branch => pi
2012-04-26 12:36egoitzStatusscheduled => resolved
2012-04-26 12:36egoitzFixed in Version => 3.0MP11
2012-04-26 12:36egoitzResolutionopen => fixed
2012-04-26 12:37egoitzNote Added: 0048012
2012-04-26 12:38egoitzNote Added: 0048013
2012-04-26 12:39egoitzNote Added: 0048014
2012-04-26 12:50hgbotCheckin
2012-04-26 12:50hgbotNote Added: 0048021
2012-04-26 12:50hgbotFixed in SCM revisionhttps://code.openbravo.com/erp/devel/pi/rev/c88ce1de44de [^] => http://code.openbravo.com/erp/devel/pi/rev/153cac4dbab2d666163285b169910f12961a05f5 [^]
2012-04-26 12:51egoitzStatusresolved => new
2012-04-26 12:51egoitzResolutionfixed => open
2012-04-26 12:51egoitzFixed in Version3.0MP11 =>
2012-04-26 12:51egoitzNote Deleted: 0048014
2012-04-26 12:51egoitzNote Deleted: 0048013
2012-04-28 02:31hudsonbotCheckin
2012-04-28 02:31hudsonbotNote Added: 0048156
2012-04-28 02:31hudsonbotCheckin
2012-04-28 02:31hudsonbotNote Added: 0048159
2012-05-03 13:42hgbotCheckin
2012-05-03 13:42hgbotNote Added: 0048332
2012-05-03 13:42hgbotStatusnew => resolved
2012-05-03 13:42hgbotResolutionopen => fixed
2012-05-03 13:42hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/153cac4dbab2d666163285b169910f12961a05f5 [^] => http://code.openbravo.com/erp/devel/pi/rev/8d41e9b2be6524bec2256a6efde1edbb5519de59 [^]
2012-05-03 16:02hgbotCheckin
2012-05-03 16:02hgbotNote Added: 0048339
2012-05-03 16:43egoitzStatusresolved => new
2012-05-03 16:43egoitzResolutionfixed => open
2012-05-25 12:09hudsonbotCheckin
2012-05-25 12:09hudsonbotNote Added: 0049008
2012-05-25 12:09hudsonbotCheckin
2012-05-25 12:09hudsonbotNote Added: 0049011
2012-05-28 09:44egoitzPriorityurgent => high
2012-05-28 09:44egoitzSeveritymajor => minor
2012-05-28 09:44egoitzTarget Version3.0MP12 => 3.0MP13
2012-05-28 09:44egoitzfix_in_branchpi =>
2012-06-27 11:53egoitzTarget Version3.0MP13 => 3.0MP14
2012-07-25 10:59jonalegriaesarteTypedefect => design defect
2012-07-25 10:59jonalegriaesarteTarget Version3.0MP14 =>
2012-08-02 12:14egoitzNote Added: 0051079
2012-08-02 12:14egoitzStatusnew => closed
2012-08-02 12:14egoitzResolutionopen => no change required
2012-09-13 10:42jonalegriaesarteAssigned Toegoitz => dmiguelez

Notes
(0048012)
egoitz   
2012-04-26 12:37   
Resolved with that commit;
https://code.openbravo.com/erp/devel/pi/rev/c88ce1de44de [^]
(0048021)
hgbot   
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   
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   
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   
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   
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   
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   
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   
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.