Kbase P142599: Some tables are not migrated from OE database to MS SQL Server database using OE10.1C FCS SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/03/2009 |
|
Status: Unverified
SYMPTOM(s):
Some tables are not migrated from OE database to MS SQL Server database using OE10.1C FCS SQL Server DataServer
The schema holder log file shows the following error:
WARNING: TABLE <table name> will not be created.
Table contains unsupported Progress data types and cannot be created.
The .sql file created during the protoMSS utility is commented out as:
-- ** if (select name from sysobjects
-- ** where name = 't' and type = 'U' and
-- ** uid = (select uid from sysusers
-- ** where sid = (select sid from master.dbo.syslogins
-- ** where UPPER(name) = UPPER('dbo'))))
-- ** is not NULL
-- ** drop table abnormalities
-- ** go
-- ** CREATE TABLE t (
-- ** f1 varchar (40),
-- ** f2 UNSUPPORTED-datetime,
-- ** PROGRESS_RECID bigint null,
-- ** PROGRESS_RECID_IDENT_ bigint identity
-- ** )
-- ** go
-- **
FACT(s) (Environment):
The table has a field with OpenEdge datetime
Windows
UNIX
OpenEdge 10.1x
MS SQL DataServer
Oracle DataServer
CAUSE:
The OpenEdge datetime data type is not supported on the OE10.1C FCS MS SQL Server and Oracle DataServers. Therefore, some of the table are skipped by the protoMSS utility. Support for the datetime data type is introduced on the OE10.1C service pack.
FIX:
Upgrade to OpenEdge 10.1C01 or later