Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0030451Openbravo ERP04. Warehouse managementpublic2015-07-29 16:122016-09-19 13:38
ngarcia 
aferraz 
urgentmajoralways
closedfixed 
5
 
 
dmiguelez
Core
No
0030451: Performance Problems on the Costing Migration Process
Performance Problems on the Costing Migration Process
In 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)
   
No tags attached.
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 
Issue History
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-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