Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0023924 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| design defect | [Openbravo ERP] 07. Sales management | critical | always | 2013-05-27 18:32 | 2014-03-17 13:46 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | Sandrahuguet | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0PR14Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 12591b3385f8 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | egoitz | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0023924: The c_invoice_create function takes long with big amount of data | |||||||
| Description | The c_invoice_create function takes long with big amount of data. 'c_orderline';301054 'm_inout';66654 'm_inoutline';271216 'c_invoice';28805 'c_invoiceline';283204 'c_oder';75218 | |||||||
| Steps To Reproduce | -Create a product with invoice term inmediate and 10 lines -complete it -go to create invoices from order Form -Select the order previously created -Execute process -It takes more than 5 seconds only for one order. The problem seems to be caused by the select executed to define the Cur_InvoiceSchedule cursor. The select is properly executed on pgadmin but on runtime it takes long due to the explain created with the parameters. Check if the order by is needed because removing it reduces the time to finish the process | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0060786) jonalegriaesarte (viewer) 2013-08-27 11:23 |
This processes (including book processes) are going to be reviewed in depth at the end of Q3-2013 |
|
(0064617) hgbot (developer) 2014-02-26 15:34 |
Repository: erp/devel/pi Changeset: 12591b3385f81d9633403106e87bbe9d5b174a63 Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Tue Feb 25 17:16:57 2014 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/12591b3385f81d9633403106e87bbe9d5b174a63 [^] Fixes bug 23924 c_invoice_create takes long with big amount of data --- M src-db/database/model/functions/C_INVOICE_CREATE.xml --- |
|
(0064618) hgbot (developer) 2014-02-26 15:34 |
Repository: erp/devel/pi Changeset: 12591b3385f81d9633403106e87bbe9d5b174a63 Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Tue Feb 25 17:16:57 2014 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/12591b3385f81d9633403106e87bbe9d5b174a63 [^] Fixes bug 23924 c_invoice_create takes long with big amount of data --- M src-db/database/model/functions/C_INVOICE_CREATE.xml --- |
|
(0064619) hgbot (developer) 2014-02-26 15:34 |
Repository: erp/devel/pi Changeset: 12591b3385f81d9633403106e87bbe9d5b174a63 Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Tue Feb 25 17:16:57 2014 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/12591b3385f81d9633403106e87bbe9d5b174a63 [^] Fixes bug 23924 c_invoice_create takes long with big amount of data --- M src-db/database/model/functions/C_INVOICE_CREATE.xml --- |
|
(0064696) hudsonbot (viewer) 2014-02-28 19:50 |
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/2a3305b1338e [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2013-05-27 18:32 | egoitz | New Issue | |
| 2013-05-27 18:32 | egoitz | Assigned To | => dmiguelez |
| 2013-05-27 18:32 | egoitz | Modules | => Core |
| 2013-05-27 18:32 | egoitz | OBNetwork customer | => Yes |
| 2013-05-27 18:32 | egoitz | Triggers an Emergency Pack | => No |
| 2013-05-28 10:20 | dmiguelez | Assigned To | dmiguelez => jonalegriaesarte |
| 2013-08-27 11:23 | jonalegriaesarte | Note Added: 0060786 | |
| 2013-08-27 11:23 | jonalegriaesarte | Type | defect => design defect |
| 2014-02-26 15:34 | hgbot | Checkin | |
| 2014-02-26 15:34 | hgbot | Note Added: 0064617 | |
| 2014-02-26 15:34 | hgbot | Checkin | |
| 2014-02-26 15:34 | hgbot | Note Added: 0064618 | |
| 2014-02-26 15:34 | hgbot | Checkin | |
| 2014-02-26 15:34 | hgbot | Note Added: 0064619 | |
| 2014-02-26 15:34 | hgbot | Status | new => resolved |
| 2014-02-26 15:34 | hgbot | Resolution | open => fixed |
| 2014-02-26 15:34 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/12591b3385f81d9633403106e87bbe9d5b174a63 [^] |
| 2014-02-26 15:34 | hgbot | Status | new => resolved |
| 2014-02-26 15:34 | hgbot | Status | new => resolved |
| 2014-02-27 18:38 | Sandrahuguet | Assigned To | jonalegriaesarte => Sandrahuguet |
| 2014-02-28 19:50 | hudsonbot | Checkin | |
| 2014-02-28 19:50 | hudsonbot | Note Added: 0064696 | |
| 2014-03-17 13:46 | egoitz | Review Assigned To | => egoitz |
| 2014-03-17 13:46 | egoitz | Status | resolved => closed |
| 2014-03-17 13:46 | egoitz | Fixed in Version | => PR14Q2 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |