Kbase P151207: ProtoMSS fails to create a table with Unicode type fields on the MS SQL Server Database if a OE fiel
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/20/2009 |
|
Status: Unverified
SYMPTOM(s):
ProtoMSS fails to create a table with Unicode type fields on the MS SQL Server Database if a OE field contains a single quote (') for the initial value
With the extended logging, the following error is displayed:
CREATE TABLE tbl1 ( fld1 nvarchar (16) DEFAULT '''' null, fld2 nvarchar (16) DEFAULT '""' null, PROGRESS_RECID bigint null, PROGRESS_RECID_IDENT_ bigint identity ) (15069)
SQLState: 37000
Native Error Code: 102
Error Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ''. (15044)
FACT(s) (Environment):
There is no error shown with out the extended bebugging parameter
During the protoMSS process "Include defaults" and "Unicode Type" are selected
The initial value on the OpenEdge database is a single quote (')
Windows
MS SQL DataServer
OpenEdge 10.1C
OpenEdge 10.2x
CAUSE:
Bug# OE00189701
FIX:
The workaround is to copy the table's sql from the .sql file generated by the protoMSS process and run it on the transact-sql tool against the MS SQL Server database. Then adjust schema holder for the selected table(s) against the original OpenEdge database.