Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024833Openbravo ERP04. Warehouse managementpublic2013-09-25 22:192013-11-25 12:33
Reporterjecharri 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP30Fixed in Version3.0MP30 
Merge Request Status
Review Assigned Tojonalegriaesarte
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket23312
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024833: Pareto product stock has performance problems
DescriptionPareto product stock has performance problems
Steps To ReproduceIf you have one environment with 60000 records in table m_transaction_cost
the report can take hours executing.

Proposed Solution
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-09-25 22:19jecharriNew Issue
2013-09-25 22:19jecharriAssigned To => dmiguelez
2013-09-25 22:19jecharriWeb browser => Google Chrome
2013-09-25 22:19jecharriModules => Core
2013-09-25 22:19jecharriOBNetwork customer => Yes
2013-09-25 22:19jecharriSupport ticket => 23312
2013-09-25 22:19jecharriResolution time => 1382479200
2013-09-25 22:19jecharriTriggers an Emergency Pack => No
2013-09-25 22:20jecharriWeb browserGoogle Chrome => Google Chrome
2013-09-25 22:20jecharriSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5057#r5057
2013-09-25 22:21jecharriTag Attached: Performance
2013-09-30 16:29jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2013-09-30 16:29jonalegriaesarteTarget Version3.0MP28 => 3.0MP29
2013-10-02 18:21dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-10-14 16:37jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2013-10-14 16:37jonalegriaesarteTarget Version3.0MP29 => 3.0MP30
2013-11-07 12:04hgbotCheckin
2013-11-07 12:04hgbotNote Added: 0062047
2013-11-07 12:04hgbotStatusnew => resolved
2013-11-07 12:04hgbotResolutionopen => fixed
2013-11-07 12:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c91c09a9f15556388198768e885df3def9c0e943 [^]
2013-11-11 11:05jecharriAssigned Tojonalegriaesarte => jecharri
2013-11-11 11:05jecharriStatusresolved => new
2013-11-11 11:05jecharriResolutionfixed => open
2013-11-11 11:05jecharriStatusnew => scheduled
2013-11-11 11:05jecharrifix_in_branch => pi
2013-11-11 11:05jecharriStatusscheduled => resolved
2013-11-11 11:05jecharriResolutionopen => fixed
2013-11-19 19:07hudsonbotCheckin
2013-11-19 19:07hudsonbotNote Added: 0062242
2013-11-25 12:33jonalegriaesarteReview Assigned To => jonalegriaesarte
2013-11-25 12:33jonalegriaesarteNote Added: 0062369
2013-11-25 12:33jonalegriaesarteStatusresolved => closed
2013-11-25 12:33jonalegriaesarteFixed in Version => 3.0MP30

Notes
(0062047)
hgbot   
2013-11-07 12:04   
Repository: erp/devel/pi
Changeset: c91c09a9f15556388198768e885df3def9c0e943
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Nov 07 12:05:31 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c91c09a9f15556388198768e885df3def9c0e943 [^]

Fixes issue 24833: Pareto product stock has performance problems

---
M src-db/database/model/functions/M_GET_PARETO_ABC.xml
---
(0062242)
hudsonbot   
2013-11-19 19:07   
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/ab71e0273dc1 [^]

Maturity status: Test
(0062369)
jonalegriaesarte   
2013-11-25 12:33   
Working fine