Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023067Openbravo ERP07. Sales managementpublic2013-02-13 12:102013-03-04 12:31
Reporteregoitz 
Assigned Tojonalegriaesarte 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP19.3 
Target Version3.0MP21Fixed in Version3.0MP21 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket19302
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023067: The generate invoices from shipments process takes long.
DescriptionThe generate invoices process from shipments takes long when there are a lot of invoices, and invoice lines
Steps To Reproduce-On an environment with a lot of invoices and invoicelines create 10 shipments and complete all .
-Go to generate invoices from shipment window-
-Select all the shipments and click on process
*It takes long to create the data
Proposed SolutionAdd the following index:


CREATE INDEX c_invoicelinetax_invoiceline ON c_invoicelinetax USING
btree (c_invoiceline_id);
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-13 12:10egoitzNew Issue
2013-02-13 12:10egoitzAssigned To => dmiguelez
2013-02-13 12:10egoitzModules => Core
2013-02-13 12:10egoitzOBNetwork customer => Yes
2013-02-13 12:10egoitzTriggers an Emergency Pack => No
2013-02-13 12:11egoitzTag Attached: Performance
2013-02-13 12:12egoitzSupport ticket => 19302
2013-02-13 12:12egoitzResolution time => 1368136800
2013-02-14 08:59dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-02-21 02:29hgbotCheckin
2013-02-21 02:29hgbotNote Added: 0056659
2013-02-21 02:29hgbotStatusnew => resolved
2013-02-21 02:29hgbotResolutionopen => fixed
2013-02-21 02:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9f692840db9276e750afabee18ac901adce53acd [^]
2013-02-21 17:48hudsonbotCheckin
2013-02-21 17:48hudsonbotNote Added: 0056705
2013-03-04 12:31egoitzReview Assigned To => egoitz
2013-03-04 12:31egoitzNote Added: 0056993
2013-03-04 12:31egoitzStatusresolved => closed
2013-03-04 12:31egoitzFixed in Version => 3.0MP21

Notes
(0056659)
hgbot   
2013-02-21 02:29   
Repository: erp/devel/pi
Changeset: 9f692840db9276e750afabee18ac901adce53acd
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Thu Feb 21 02:28:45 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9f692840db9276e750afabee18ac901adce53acd [^]

Fixes issue 0023067: The generate invoices from shipments process takes long.

---
M src-db/database/model/tables/C_INVOICELINETAX.xml
---
(0056705)
hudsonbot   
2013-02-21 17:48   
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/2add4de9509d [^]

Maturity status: Test
(0056993)
egoitz   
2013-03-04 12:31   
verified