Kbase 20058: ORACLE Dsrv: Incremental .df Does Not Change Field Size
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.3B
Progress 8.3C
Progress 9.1A05
Progress 9.1B
Oracle DataServer
SYMPTOM(s):
The original delta .df file has correct formatted changes
Using Progress to ORACLE delta incremental utility
The .SQL file generated does not include the changes to the ORACLE table
The delta df for the schema holder contains the field size changes.
There is a mismatch between ORACLE and schema
CAUSE:
Bug# 20000808-036
CAUSE:
When the delta.df has a change in the size of a character field, the SQL generated does not have the modification for the table over Oracle, but the delta df generated for schema holder has format change. This leads to mismatched schema after the delta df is applied against the schema holder.
The format defines just the display of the field. A format change does not mean the field size changes.
FIX:
This issue has been fixed in Progress 9.1C and Progress 8.3D. The fix takes away the functionality of the format modification to schema holder by not allowing the format changes of the field in the Progress database..
This will not cause change to Oracle or change to schema holder, thus maintains consistency between Oracle and schema holder