Kbase 19073: "Error during rename Index" When applying a delta.df
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/02/2005 |
|
"Error during rename Index" When applying a delta.df
DRAFT COPY - Currently under review and edit.
INTRODUCTION:
=============
This Tech Support document explains the errors associated with "error
during rename index" when trying to apply an incremental df from a db
that has had index changes. And describes a work around.
WHY YOU NEED TO KNOW THIS:
===========================
If your source db has had index changes, when you try to apply this de
lta.df to the target db you will get this error. This is a seriuos dep
lyment problem and is being reviewed by development for a fix. The pro
blem lies in the way the delta.df is created.
PROCEDURAL APPROACH:
====================
Steps to reproduce:
1. Create 2 db's from sports. Name them one and two respectively.
2. Connect to db one. Open the data dictionary, Go to the Schema menu.
3. Then go to index editor. choose the customer table.
4. Delete the Comments Index. Leave the editor and commit your changes
5. Then go to the field editor under schema, again choose the customer
table. Delete the comments field. The add a field called comments but
make it integer. Commit your chnages.
6. Then go back into the index editor and add an index called Comments
. Accept the defaults. Commit your changes.
7. Then go into the database menu and connect to the two db.
8. Go back into the database menu and select working db, choose the on
e.db
9. Then go into the admin menu, dump data and definitions, create incr
emental .df.
10. It should show the two db as the comparing db.
11. Choose an appropriate file name, it should default to delta.df.
12. Dump the .df
13. Make the two db your working db.
14. Go into the admin menu, load data and definitions, data defintions
(.df file)
15. Load the .df.
16 You should receive 3 error messages one after the other.
a. Error during rename index. Line XXX rename index AAA to temp-XXXXX
XXX-X on "table name". Try to modify unknown index
b. Error during add Index "index name". Line XXX Index_field "table n
ame" ascending cannot find field to index.
c. Error during delete index. Line XXX drop index temp-XXXXXXXX-X on
"table name". Try to modify unknown index.
ONLINE PROCEDURES OR UTILITIES:
===============================
There is a simple work around for this problem. Simply edit the delta.
df file before you apply it. Remove the line that renames the index to
temp-XXXXXXXX-X, and remove the line that drops that index.
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
Bug Number 19970814-029
Quantum case number W908264133