Kbase P131812: Generate delta.sql Openedge to MS SQL fails with errors 560 and 6227
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/02/2009 |
|
Status: Unverified
SYMPTOM(s):
Attempt to load the df file into the schema holder produces the errors 560 and 6227.
Entry <entry#> is outside the range of list <list-string>. (560)
Entry 0 is outside range of list followed by a list of datatypes.
SYSTEM ERROR: <proc-name>: Bad datatype <datatype>. (6227)
SYSTEM ERROR: _type_psql: Bad datatype 0. (6227)
Progress session crashes
Stack trace from _progress
RaiseException
dbut_bufmov
Attempt to run the .sql script produces the errors:
Msg 102, Level 15, State 1, Line x
Incorrect syntax near ' ) '.
FACT(s) (Environment):
Delta.df file created to upgrade to the current version of the schema
Schema holder .df and .sql files generated using "Generate delta.sql OpenEdge to MSS" tool.
The .sql script update some sequences
Windows
OpenEdge 10.x
MS SQL
CAUSE:
Bug# OE00167691
FIX:
Upgrade to OpenEdge 10.2A or later.
If upgrading is not an option, edit the generated .df file and change FOREIGN-TYPE "TEXT" to FOREIGN-TYPE "LONGVARCHAR".
Load the modified .df file into the schema holder.
Edit the generated .sql file and remove all the INSERT for the sequence and change it to an UPDATE sequence.
UPDATE sequence set field = value, field = value
Run the .sql script.