Kbase P58662: Tables/fields in schema holder do not adjust properly to original Progress db
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/03/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
All Supported Operating Systems
Progress 9.1D
SYMPTOM(s):
Progress 9.1D07
After Pro-to-ORA, some tables/fields in schema holder are in uppercase and have underscores
Original tables/fields in Progress db are in lowercase and have hyphens
Adjust schema does not adjust schema holder properly to original Progress db
Pro-to-ORA is run without data load option
CAUSE:
Bug# OE00098546
CAUSE:
Adjust schema is not completing appropriately
1 - Tables that have FOREIGN-NAME defined as "n/a" in the Progress db are not adjusted properly.
2 - Fields with extent that have long names are not adjusted properly because we don't account for the extra characters added to the column name when trimming the field name to the max field name size allowed.
3 - If a table has several fields with similar names (specific to long names), we identify unique names when we are pushing the schema definitions, but we don't adjust them properly because we don't use the same algorithm to find unique names when adjusting the schema.
FIX:
Upgrade to Progress 9.1D08 and later