Kbase P100786: Index name does not show up as table-name##index-name in the schema holder .df
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/01/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0B
Oracle DataServer
SYMPTOM(s):
Schema holder df shows incorrect FOREIGN-OWNER name referenced for index after running Pro-to-Oracle utility
Index name does not show up as table-name##index-name in the schema holder .df
ProtoOra was run with 4gl-compatible-objects selected
Index is the progress-recid
Table name is more than 14 characters
Table and index name are identical or the same
CAUSE:
Bug# 20050203-022
FIX:
Upgrade to 10.0B03 or higher
I you can not upgrade than the workaround is to:
1. Note how many tables are being impacted
2. Remove those tables from the schema holder
3. Reload the tables into the schema holder through a pull using Oracle Utilities/ Update/Add Table Definitions
4. Delete the index which has no fields attached
5. Rename the index which has the -1 suffix by removing the -1 from the index name
5. Connect to the original progress database
6. Run the Adjust Schema option under Oracle Utilities/Schema Migration