Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030451Openbravo ERP04. Warehouse managementpublic2015-07-29 16:122016-09-19 13:38
Reporterngarcia 
Assigned Toaferraz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030451: Performance Problems on the Costing Migration Process
DescriptionPerformance Problems on the Costing Migration Process
Steps To ReproduceIn an environment without the new costing engine (previous to 3.0MP13) and a big quantity of transactions (e.g. 1500000)
As system admin role:
   Upgrade it to the last version
   Close the current period
   Launch the Costing Migration process
   If you don't change the Session Timeout to be higher than 24 hours the errors launched by the process will only be available in the log
   Check its first launch takes too long and the process fails
   It should be launched again from scratch once the period is opened
   The same could happen if you have negative stock without allowing it (you could reach this situation if you use Openbravo For Retail)
   
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0024008 new dmiguelez It would be fine to have any kind of information about the evolution of the Costing Migration Process 
related to defect 00240063.0MP25 closed pramakrishnan The Costing Migration Process should be improved to avoid performance problems. 
related to defect 0034130 closed aferraz Costing Migration Process takes too long with big amount of records in m_transaction table 
related to defect 0035959 closed markmm82 Performance problem in Costing Migration Process with high volume of records in m_transaction table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-07-29 16:12ngarciaNew Issue
2015-07-29 16:12ngarciaAssigned To => Triage Finance
2015-07-29 16:12ngarciaModules => Core
2015-07-29 16:12ngarciaTriggers an Emergency Pack => No
2015-07-29 16:13ngarciaIssue Monitored: networkb
2015-07-29 19:04ngarciaRelationship addedrelated to 0024008
2015-08-03 14:11ngarciaResolution time => 1441663200
2015-08-05 09:37ngarciaRelationship addedrelated to 0024006
2015-08-07 10:23aferrazAssigned ToTriage Finance => aferraz
2015-08-20 10:57aferrazStatusnew => scheduled
2015-08-21 11:58hgbotCheckin
2015-08-21 11:58hgbotNote Added: 0079569
2015-08-21 11:58hgbotStatusscheduled => resolved
2015-08-21 11:58hgbotResolutionopen => fixed
2015-08-21 11:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a2790dd1c4226a4a6762e171329c5c2a3c0e5aaa [^]
2015-08-21 11:59dmiguelezReview Assigned To => dmiguelez
2015-08-21 11:59dmiguelezNote Added: 0079570
2015-08-21 11:59dmiguelezStatusresolved => closed
2015-08-21 21:00hudsonbotCheckin
2015-08-21 21:00hudsonbotNote Added: 0079589
2016-09-19 13:38ngarciaNote Added: 0090063
2016-09-29 14:17ngarciaRelationship addedrelated to 0034130
2017-05-09 12:32aferrazRelationship addedrelated to 0035959

Notes
(0079569)
hgbot   
2015-08-21 11:58   
Repository: erp/devel/pi
Changeset: a2790dd1c4226a4a6762e171329c5c2a3c0e5aaa
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Aug 12 10:53:32 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a2790dd1c4226a4a6762e171329c5c2a3c0e5aaa [^]

Fixes issue 30451: Performance Problems on Costing Migration Process

Added some checks before process starts to check if exists wrong data and it is needed to correct it.

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0079570)
dmiguelez   
2015-08-21 11:59   
Code Review + Testing Ok
(0079589)
hudsonbot   
2015-08-21 21:00   
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/be999ae66d23 [^]
Maturity status: Test
(0090063)
ngarcia   
2016-09-19 13:38   
The process will also stop if there does not exist conversion rate defined from the legal entity currency to the m_transaction_cost currency