Kbase P88495: Can not run delta df utility with a new index that is also made primary in Progress delta df
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/19/2008 |
|
Status: Verified
SYMPTOM(s):
Can not run delta sql progress to oracle utility
Error running delta sql progress to oracle utility
The delta DF file contains update primary index myindex for table mytable and
index does not exist in the schma holder. This process is being aborted.
The above error is encountered when migrating index changes on table mytable
Progress delta df contains a new index
The new index is made primary
Typical progress df
ADD INDEX "myindex" ON "mytable"
AREA "Schema Area"
INDEX-FIELD "field1" ASCENDING
INDEX-FIELD "field2" ASCENDING
UPDATE PRIMARY INDEX "myindex" ON "mytable"
FACT(s) (Environment):
OpenEdge 10.0A
Oracle DataServer
All Supported Operating Systems
CAUSE:
Bug# OE00107687
FIX:
Upgrade to Progress 9.1E or OE 10.1A and later or use following workaround:
1. Alter the df as following
ADD INDEX "myindex" ON "mytable"
AREA "Schema Area"
primary
INDEX-FIELD "field1" ASCENDING
INDEX-FIELD "field2" ASCENDING
2. Run delta sql utility again