Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034564Openbravo ERP04. Warehouse managementpublic2016-11-17 15:432016-12-16 18:39
Reporterngarcia 
Assigned ToSanjota 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q1 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034564: Duplicated records in m_transactioncost table after launching the Costing Migration Process
DescriptionDuplicated records in m_transactioncost table after launching the Costing Migration Process
Steps To Reproduce    As system admin role:
   Install the 3.0MP12.2 version
   Upgrade it to pi
   Note: I need to launch the following command as the Costing Algorithms were not present in the system after recompiling it:
      ant apply.module -DforceRefData=true
      ant smartbuild
As group admin roles:
   Create 2016 year and periods for all the legal with accounting organizations in the system
   Open them
As system admin role:
   Launch the Costing Migration process
   Check it launches a warning that there are transactions without cost
   Set as inactive the 'Products with transactions without available cost on date.' alert
   Launch the Costing Migration process again
   Once it finishes, check there are duplicated entries in m_transactioncost table for each transaction available in the system previous to the migration
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0034563 closed Sanjota Index: 0, Size: 0 error when launching Costing Migration Process 
related to defect 0034662 closed Sanjota If we launch costing migration process the last day of a month, PeriodClosedForMMI error is thrown 
related to defect 0035959 closed markmm82 Performance problem in Costing Migration Process with high volume of records in m_transaction table 
Attached Files? 34564.sql (267) 2016-12-01 02:15
https://issues.openbravo.com/file_download.php?file_id=10136&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-11-17 15:43ngarciaNew Issue
2016-11-17 15:43ngarciaAssigned To => Triage Finance
2016-11-17 15:43ngarciaModules => Core
2016-11-17 15:43ngarciaResolution time => 1481151600
2016-11-17 15:43ngarciaTriggers an Emergency Pack => No
2016-11-17 15:43ngarciaRelationship addeddepends on 0034563
2016-11-17 15:44ngarciaIssue Monitored: networkb
2016-11-18 09:32aferrazAssigned ToTriage Finance => Sanjota
2016-11-28 06:32SanjotaStatusnew => scheduled
2016-11-29 10:48SanjotaNote Added: 0091907
2016-12-01 02:14aferrazFile Added: 34564.sql
2016-12-01 02:15aferrazFile Deleted: 34564.sql
2016-12-01 02:15aferrazFile Added: 34564.sql
2016-12-01 02:16aferrazNote Added: 0091944
2016-12-01 09:59aferrazRelationship addedrelated to 0034662
2016-12-01 14:44hgbotCheckin
2016-12-01 14:44hgbotNote Added: 0091970
2016-12-01 14:44hgbotStatusscheduled => resolved
2016-12-01 14:44hgbotResolutionopen => fixed
2016-12-01 14:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a87d9652fd86e4907c1bad0611d2a6879dd57007 [^]
2016-12-01 14:47aferrazReview Assigned To => aferraz
2016-12-01 14:47aferrazNote Added: 0091973
2016-12-01 14:47aferrazStatusresolved => closed
2016-12-01 14:47aferrazFixed in Version => 3.0PR17Q1
2016-12-16 18:39hudsonbotCheckin
2016-12-16 18:39hudsonbotNote Added: 0092677
2017-05-09 13:42aferrazRelationship addedrelated to 0035959

Notes
(0091907)
Sanjota   
2016-11-29 10:48   
Test plan:
Test plan:
Create new instance (application with 3.0MP12.2 version)
   Upgrade it to pi -hg pull -u
Build instance - ant smartbuild -Dlocal=no -Dforce=true
   Note: I need to launch the following command as the Costing Algorithms were not present in the system after recompiling it:
      ant apply.module -DforceRefData=true
      ant smartbuild
As group admin roles:
   Create 2016 year and periods for all the legal with accounting organizations in the system
   Open them
As system admin role:
   Launch the Costing Migration process
   Check it launches a warning that there are transactions without cost
   Set as inactive the 'Products with transactions without available cost on date.' alert
   Launch the Costing Migration process again
   Once it finishes, check there is only one entry in m_transactioncost table for each transaction available in the system previous to the migration
(0091944)
aferraz   
2016-12-01 02:16   
Attached query to fix data.
(0091970)
hgbot   
2016-12-01 14:44   
Repository: erp/devel/pi
Changeset: a87d9652fd86e4907c1bad0611d2a6879dd57007
Author: Sanjota <sanjota.nelagi <at> promantia.com>
Date: Tue Nov 29 15:10:55 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/a87d9652fd86e4907c1bad0611d2a6879dd57007 [^]

Fixes issue 34564: Duplicated transaction cost in Costing Migration Process

Resolved duplicated records in m_transaction_cost table after launching the Costing Migration process.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0091973)
aferraz   
2016-12-01 14:47   
Code review + Testing OK
(0092677)
hudsonbot   
2016-12-16 18:39   
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/dc8bf00badd0 [^]
Maturity status: Test