Kbase P25975: 1127 error performing IDXBUILD after applying delta.df
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/28/2003 |
|
Status: Unverified
SYMPTOM(s):
Error performing IDXBUILD
Fix RECID <recid>, <file-name> already exists with <field value>. (1127)
CHANGE:
Applied a delta.df file before IDXBUILD was run.
CAUSE:
An index has been added that does not contain a unique field. For example, a delta.df file dropped an existing index on the table and added a new one.
The old index was comprised of three fields. The new index is comprised of only two. Neither of the two fields that comprise the index are unique.
FIX:
Add unique field to index and rerun IDXBUILD.