0009955: Error migrating from 235MP13 to 240MP7. Conversion type not correct

Description

While 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 Reproduce

1. 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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0009954

closed

marvintm

Error migrating from 235MP13 to 240MP7. Conversion type not correct

Notes
(0018662) hgbot (developer) 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 (viewer) 2009-08-07 15:41	Tested working fine

Issue History
Date Modified	Username	Field	Change
2009-07-19 17:24	psarobe	Type	defect => backport
2009-07-19 17:24	psarobe	fix_in_branch	=> 2.40
2009-07-20 11:40	psarobe	Priority	immediate => urgent
2009-07-28 17:11	hgbot	Checkin
2009-07-28 17:11	hgbot	Note Added: 0018662
2009-07-28 17:11	hgbot	Status	scheduled => resolved
2009-07-28 17:11	hgbot	Resolution	open => fixed
2009-07-28 17:11	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.40/rev/9a98d8c5193a461a25211c2db692d3fee8b9b9b2 [^]
2009-08-07 15:41	sureshbabu	Status	resolved => closed
2009-08-07 15:41	sureshbabu	Note Added: 0018879
2009-08-07 15:41	sureshbabu	Fixed in Version	=> 2.40MP8