Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029739Openbravo ERP04. Warehouse managementpublic2015-04-29 18:202015-06-12 16:59
ReporterioritzCia 
Assigned ToTriage Omni WMS 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionUbuntu 14.04
Product Version3.0PR15Q1 
Target VersionFixed in Version3.0PR15Q4 
Merge Request Status
Review Assigned ToioritzCia
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029739: Costing Background process takes most of the time of execution on a system
DescriptionDepending on the system the Costing Background process can take up to a 25% of the execution time of the whole server.

We will provide more details when possible.

We have a clone of the environment.
Steps To ReproduceYou need to enter the system and analyze execution times.

Ask for already executed analysis.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0029708 closed umartirena The costing background process is very slow 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-04-29 18:20ioritzCiaNew Issue
2015-04-29 18:20ioritzCiaAssigned To => Triage Finance
2015-04-29 18:20ioritzCiaWeb browser => Google Chrome
2015-04-29 18:20ioritzCiaModules => Core
2015-04-29 18:20ioritzCiaTriggers an Emergency Pack => No
2015-04-29 18:21ioritzCiaTag Attached: Performance
2015-04-29 18:23shuehnerIssue Monitored: shuehner
2015-04-29 18:43ioritzCiaWeb browserGoogle Chrome => Google Chrome
2015-04-29 18:43ioritzCiaNote Added: 0076885
2015-04-30 13:25ioritzCiaReview Assigned To => ioritzCia
2015-04-30 13:25ioritzCiaRelationship addedduplicate of 0029708
2015-04-30 13:25ioritzCiaStatusnew => closed
2015-04-30 13:25ioritzCiaResolutionopen => duplicate
2015-04-30 13:30ioritzCiaStatusclosed => new
2015-04-30 13:30ioritzCiaResolutionduplicate => open
2015-04-30 13:30ioritzCiaRelationship deleted0029708
2015-04-30 13:30ioritzCiaRelationship addedrelated to 0029708
2015-04-30 13:32ioritzCiaNote Added: 0076914
2015-04-30 13:39egoitzWeb browserGoogle Chrome => Google Chrome
2015-04-30 13:39egoitzResolution time => 1431036000
2015-04-30 13:44egoitzIssue Monitored: egoitz
2015-06-11 18:29hgbotCheckin
2015-06-11 18:29hgbotNote Added: 0078221
2015-06-11 18:29hgbotStatusnew => resolved
2015-06-11 18:29hgbotResolutionopen => fixed
2015-06-11 18:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2a66cd73cfe8a9b37ecd30545b8e6fcc77cd0e5b [^]
2015-06-12 09:29ioritzCiaNote Added: 0078227
2015-06-12 09:29ioritzCiaStatusresolved => closed
2015-06-12 09:29ioritzCiaFixed in Version => 3.0PR15Q4
2015-06-12 16:59hudsonbotCheckin
2015-06-12 16:59hudsonbotNote Added: 0078258

Notes
(0076885)
ioritzCia   
2015-04-29 18:43   
This particular instance has 7 background processes configured each one for one of their 7 orgs. This is like this, so that if the background process stops calculating one cost for a particular org the rest of the costs of the rest of the orgs keep being calculated. If we fixed this, so that one single process would not stop calculating costs of other organizations, they could schedule one single process.
(0076914)
ioritzCia   
2015-04-30 13:32   
Issue 29708 complains about large execution of the process, which does not happen here as the process is executed frequently. Even if it is executed frequently, takes an average of 4'5 seconds to execute and it gets executed a huge amount of times, there should be a way to improve this.
(0078221)
hgbot   
2015-06-11 18:29   
Repository: erp/devel/pi
Changeset: 2a66cd73cfe8a9b37ecd30545b8e6fcc77cd0e5b
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Jun 11 18:28:02 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2a66cd73cfe8a9b37ecd30545b8e6fcc77cd0e5b [^]

Fixes Issue 29739. Adds Indexes for isProcess and IsCostCalculated columns
to improve performance in Costing Background Process Queries.

---
M src-db/database/model/tables/M_TRANSACTION.xml
---
(0078227)
ioritzCia   
2015-06-12 09:29   
Tested and verified in the cloned environment.
(0078258)
hudsonbot   
2015-06-12 16:59   
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/ebf462f93acf [^]
Maturity status: Test