Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009955Openbravo ERPY. DBSourceManagerpublic2009-07-19 17:242009-08-07 15:41
Reporterpsarobe 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP7 
Target VersionFixed in Version2.40MP8 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009955: Error migrating from 235MP13 to 240MP7. Conversion type not correct
DescriptionWhile migrating from 235MP13 to 240MP7 columns which were defined as CHAR in 235MP13 and nowadays are defined as NCHAR in 240MP7 are not convert and remains CHAR.

You can check that with column UOMSYMBOL in table C_UOM or table C_UOM_TRL
Steps To Reproduce1. Install 235MP13
2. Migrate to 240MP7
3. Run export.database
3. Compare folders: the model folder of the 240MP7 migrated with a 240MP7 fresh installation
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0009954 closed marvintm Error migrating from 235MP13 to 240MP7. Conversion type not correct 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-19 17:24psarobeTypedefect => backport
2009-07-19 17:24psarobefix_in_branch => 2.40
2009-07-20 11:40psarobePriorityimmediate => urgent
2009-07-28 17:11hgbotCheckin
2009-07-28 17:11hgbotNote Added: 0018662
2009-07-28 17:11hgbotStatusscheduled => resolved
2009-07-28 17:11hgbotResolutionopen => fixed
2009-07-28 17:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/9a98d8c5193a461a25211c2db692d3fee8b9b9b2 [^]
2009-08-07 15:41sureshbabuStatusresolved => closed
2009-08-07 15:41sureshbabuNote Added: 0018879
2009-08-07 15:41sureshbabuFixed in Version => 2.40MP8

Notes
(0018662)
hgbot   
2009-07-28 17:11   
Repository: erp/stable/2.40
Changeset: 9a98d8c5193a461a25211c2db692d3fee8b9b9b2
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Jul 28 17:08:21 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/9a98d8c5193a461a25211c2db692d3fee8b9b9b2 [^]

Fixed issue 9955. Now NCHAR columns should be correctly created when upgrading to a newer version of Openbravo, when using a PostgreSQL database.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0018879)
sureshbabu   
2009-08-07 15:41   
Tested working fine