Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0020358 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
design defect | [Openbravo ERP] 09. Financial management | minor | always | 2012-04-26 12:06 | 2012-09-13 10:42 | |||
Reporter | egoitz | View Status | public | |||||
Assigned To | dmiguelez | |||||||
Priority | high | Resolution | no change required | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | 8d41e9b2be65 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 3.0MP10.1 | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0020358: Problems when calculating the linked items when the elment is referened from fin_orig_payment_sched_v view | |||||||
Description | When 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 Reproduce | On 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 | |||||||
Tags | Performance | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
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 |