Kbase P746: Oracle Dsrv: Incorrect Data-Type causing Error 54 When Applying Incremental .df
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1A05
Progress 9.1B
Progress 8.3B
Progress 8.3C
Oracle DataServer
SYMPTOM(s):
SYSTEM ERROR: fmu -- bad data type. (54)
Error 54 is encountered when an incremental DF is loaded into schema holder
CAUSE:
Bug# 20000821-017. Error 54 and Dr. Watson after Incr. DF
The problem is seen when there is a field of datatype RECID in the delta.df, the incremental .df generates it incorrectly as RECID instead of the correct INTEGER.
ADD FIELD "field2" OF "table1" AS recid -> should be INTEGER
FIX:
This issue has been fixed in Progress 9.1B01 (for all Operating Systems) and Progress 8.3D and thereafter.
To workaround, change the data type from RECID to INTEGER. Verify that the data types in the .sql and the .df files match.