Kbase P26416: Table/field names longer than 26 characters are not present within schema holder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/03/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
Oracle DataServer
All Supported Operating Systems
SYMPTOM(s):
Table/field names longer than 26 characters are not present within schema holder
No error message is displayed
Issue can be seen after running a Pro-to-ORA
Issue can be seen after performing an Update/Add Table Definition and Adjust schema
Tables/fields missing from schema holder
CAUSE:
Bug# OE00076916
CAUSE:
The DataServer allows a maximum of 26 characters to generate table and field names within ORACLE. This is because Oracle limits table/field names to 30 characters and the DataServer needs to set a number that is less than 30 characters so that it can append additional characters when working with shadow columns and arrays.
In this bug, the translation program fails to parse 26 characters for table/field names longer than 30 characters. This causes the adjust schema to fail and delete tables that are longer than 26 characters.
FIX:
Upgrade to OpEnEdge 10.0A
Or,
Use the following workaround:
to avoid having the long name tables removed from the schema holder only perform an Update/Add Table Definition.
1. This means that during Pro-to-ORA, do not load the .sql file into ORACLE.
2. Load the .sql file after the schema holder is created.
3. Perform an Update/Add Table Definition against affected tables
4. Manually adjust the schema holder to the Progress db.
Please note that each time a schema change is made (Update/Add Table Definition is performed), do not perform an Adjust schema. Manually adjust schema holder schema to Progress db.