Kbase P118028: Error 6227 using as4toodb transformation tool to create the schema holder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/09/2008 |
|
Status: Verified
SYMPTOM(s):
Error 6227 using as4toodb transformation tool to create the schema holder
SYSTEM ERROR: _type_psql: Bad datatype 0. (6227)
FACT(s) (Environment):
OpenEdge 10.1A
OpenEdge 10.1B
ODBC DataServer
The DB2/400 has TIME field
The .df file created using the as4toodb tool mapped the TIME field FOREIGN-TYPE to "integer"
The .df file created using the tool mapped the TIME field progress data type as "character"
Windows NT 4.0 Terminal Server Edition
CAUSE:
Bug# 20060331-034
CAUSE:
The foreign type was mapped to "integer" caused the error.
FIX:
For OE10.1A, upgrade to service pack OE10.1A02 or upgrade to 10.1B.
If upgrade is not possible use the following workaround to resolve the error 6227:
Open the .df file created from the as4toodb transformation tool. Find the TIME field on the .df file and add/modify the properties shown below. Do NOT remove any existing properties of the field on the .df file. Save the changes and use the conversion tool again to create the schema holder.
...
FORMAT "x(8)"
INITIAL ?
...
FOREIGN-TYPE "Time"
DSRVR-PRECISION 8
DSRVR-LENGTH 8
...
Note that "..." means other properties for the field in the .df file those do not need to be changed.
On the fix above, only portion of the TIME field definition were shown that are required to be changed or added.