Kbase 20068: Oracle Dsrv: Incorrect FOREIGN-TYPE causing Error 54 When Applying Incremental .df
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/09/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1A05
Progress 9.1B
Progress 8.3B
Progress 8.3C
Oracle DataServer
SYMPTOM(s):
Error 54 is encountered when an incremental DF is loaded into schema holder
SYSTEM ERROR: fmu -- bad data type. (54)
CAUSE:
Bug# 20000821-017
CAUSE:
The issue could be related to the FOREIGN-TYPE field in the incremental .df that is generated.
For EXAMPLE:
A CHARACTER field with a large format is being generated as NUMBER instead LONG in the incremental .df:
ADD FIELD "field1" OF "table1" AS character
FOREIGN-NAME "table1"
FORMAT "X(12000)"
FOREIGN-TYPE "NUMBER" -----> should be LONG
FIX:
Upgrade to Progress 8.3D or later.
Upgrade to Progress 9.1B01 or later.
If upgrading is not an option:
- edit the .df file generated by "Generate Delta.sql Progress to Oracle"
- change the FOREIGN-TYPE of the CHARACTER field to LONG . Make sure that the data types in the .sql and the .df files match.