Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033956Openbravo ERP07. Sales managementpublic2016-09-12 18:412016-09-23 18:22
Reporteregoitz 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q4 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket42526
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033956: The generate invoic takes long with big amount of data
DescriptionWhen there are thousand of invoices pending to be created, the generate invoices process takes long
Steps To Reproduce-On an environment with thousand of order pending to be invoiced, open the create invoices process and execute it:
*It takes minutes to finish
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0033319 closed AtulOpenbravo The generate shipment from orders form takes long to print the data with a lot of orders pending to be deliver 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-09-12 18:41egoitzNew Issue
2016-09-12 18:41egoitzAssigned To => AtulOpenbravo
2016-09-12 18:41egoitzOBNetwork customer => Yes
2016-09-12 18:41egoitzModules => Core
2016-09-12 18:41egoitzSupport ticket => 42526
2016-09-12 18:41egoitzResolution time => 1475100000
2016-09-12 18:41egoitzTriggers an Emergency Pack => No
2016-09-12 18:41egoitzIssue generated from0033319
2016-09-12 18:41egoitzRelationship addedrelated to 0033319
2016-09-13 08:39heccamIssue Monitored: heccam
2016-09-13 09:38aferrazAssigned ToAtulOpenbravo => Triage Finance
2016-09-14 12:29aferrazAssigned ToTriage Finance => AtulOpenbravo
2016-09-22 10:24hgbotCheckin
2016-09-22 10:24hgbotNote Added: 0090150
2016-09-22 10:24hgbotStatusnew => resolved
2016-09-22 10:24hgbotResolutionopen => fixed
2016-09-22 10:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/13f7a8be31637e8f44e276bb49066780ae16e3d0 [^]
2016-09-22 10:25aferrazReview Assigned To => aferraz
2016-09-22 10:25aferrazNote Added: 0090151
2016-09-22 10:25aferrazStatusresolved => closed
2016-09-22 10:25aferrazFixed in Version => 3.0PR16Q4
2016-09-23 18:22hudsonbotCheckin
2016-09-23 18:22hudsonbotNote Added: 0090213

Notes
(0090150)
hgbot   
2016-09-22 10:24   
Repository: erp/devel/pi
Changeset: 13f7a8be31637e8f44e276bb49066780ae16e3d0
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Sep 21 00:20:58 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/13f7a8be31637e8f44e276bb49066780ae16e3d0 [^]

Fixes issue 33956: The generate invoice takes long with big amount of data

Added index for column isselected of order table to improve select query and initupdate method used in invoice create process.

---
M src-db/database/model/tables/C_ORDER.xml
---
(0090151)
aferraz   
2016-09-22 10:25   
Code review + Testing OK
(0090213)
hudsonbot   
2016-09-23 18:22   
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/25f7de2ab346 [^]
Maturity status: Test