Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034564
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2016-11-17 15:432016-12-16 18:39
ReporterngarciaView Statuspublic 
Assigned ToSanjota 
PriorityurgentResolutionfixedFixed in Version3.0PR17Q1
StatusclosedFix in branchFixed in SCM revisiona87d9652fd86
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034564: 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
TagsNo tags attached.
Attached Files? file icon 34564.sql [^] (267 bytes) 2016-12-01 02:15

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0034563 closedSanjota Index: 0, Size: 0 error when launching Costing Migration Process 
related to defect 0034662 closedSanjota If we launch costing migration process the last day of a month, PeriodClosedForMMI error is thrown 
related to defect 0035959 closedmarkmm82 Performance problem in Costing Migration Process with high volume of records in m_transaction table 

-  Notes
(0091907)
Sanjota (developer)
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 (manager)
2016-12-01 02:16

 Attached query to fix data.
(0091970)
hgbot (developer)
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 (manager)
2016-12-01 14:47

 Code review + Testing OK
(0092677)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2016-11-17 15:43 ngarcia New Issue
2016-11-17 15:43 ngarcia Assigned To => Triage Finance
2016-11-17 15:43 ngarcia Modules => Core
2016-11-17 15:43 ngarcia Resolution time => 1481151600
2016-11-17 15:43 ngarcia Triggers an Emergency Pack => No
2016-11-17 15:43 ngarcia Relationship added depends on 0034563
2016-11-17 15:44 ngarcia Issue Monitored: networkb
2016-11-18 09:32 aferraz Assigned To Triage Finance => Sanjota
2016-11-28 06:32 Sanjota Status new => scheduled
2016-11-29 10:48 Sanjota Note Added: 0091907
2016-12-01 02:14 aferraz File Added: 34564.sql
2016-12-01 02:15 aferraz File Deleted: 34564.sql
2016-12-01 02:15 aferraz File Added: 34564.sql
2016-12-01 02:16 aferraz Note Added: 0091944
2016-12-01 09:59 aferraz Relationship added related to 0034662
2016-12-01 14:44 hgbot Checkin
2016-12-01 14:44 hgbot Note Added: 0091970
2016-12-01 14:44 hgbot Status scheduled => resolved
2016-12-01 14:44 hgbot Resolution open => fixed
2016-12-01 14:44 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a87d9652fd86e4907c1bad0611d2a6879dd57007 [^]
2016-12-01 14:47 aferraz Review Assigned To => aferraz
2016-12-01 14:47 aferraz Note Added: 0091973
2016-12-01 14:47 aferraz Status resolved => closed
2016-12-01 14:47 aferraz Fixed in Version => 3.0PR17Q1
2016-12-16 18:39 hudsonbot Checkin
2016-12-16 18:39 hudsonbot Note Added: 0092677
2017-05-09 13:42 aferraz Relationship added related to 0035959

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker