Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023924Openbravo ERP07. Sales managementpublic2013-05-27 18:322014-03-17 13:46
Reporteregoitz 
Assigned ToSandrahuguet 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR14Q2 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023924: The c_invoice_create function takes long with big amount of data
DescriptionThe 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

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-05-27 18:32egoitzNew Issue
2013-05-27 18:32egoitzAssigned To => dmiguelez
2013-05-27 18:32egoitzModules => Core
2013-05-27 18:32egoitzOBNetwork customer => Yes
2013-05-27 18:32egoitzTriggers an Emergency Pack => No
2013-05-28 10:20dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-08-27 11:23jonalegriaesarteNote Added: 0060786
2013-08-27 11:23jonalegriaesarteTypedefect => design defect
2014-02-26 15:34hgbotCheckin
2014-02-26 15:34hgbotNote Added: 0064617
2014-02-26 15:34hgbotCheckin
2014-02-26 15:34hgbotNote Added: 0064618
2014-02-26 15:34hgbotCheckin
2014-02-26 15:34hgbotNote Added: 0064619
2014-02-26 15:34hgbotStatusnew => resolved
2014-02-26 15:34hgbotResolutionopen => fixed
2014-02-26 15:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/12591b3385f81d9633403106e87bbe9d5b174a63 [^]
2014-02-26 15:34hgbotStatusnew => resolved
2014-02-26 15:34hgbotStatusnew => resolved
2014-02-27 18:38SandrahuguetAssigned Tojonalegriaesarte => Sandrahuguet
2014-02-28 19:50hudsonbotCheckin
2014-02-28 19:50hudsonbotNote Added: 0064696
2014-03-17 13:46egoitzReview Assigned To => egoitz
2014-03-17 13:46egoitzStatusresolved => closed
2014-03-17 13:46egoitzFixed in Version => PR14Q2

Notes
(0060786)
jonalegriaesarte   
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   
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   
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   
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   
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