Kbase P13830: Error: (997) attempting to load a .df file
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/04/2006 |
|
Status: Verified
SYMPTOM(s):
Primary index <index> must be active to make the requested changes. (997)
Primary index custnum must be active to make the requested changes. (997)
Attempting to apply an incremental.df to a database
The .df file has one or more DROP TABLE statements referencing tables with an inactive primary indexes.
None of the incremental.df changes were committed.
CAUSE:
When changes are made to the dictionary that need the data to be scanned (like when you delete a field, add a new index or drop a table), Progress uses the primary index for that table to scan the data. If the primary index is inactive, it cannot be referenced as inactive indexes are not maintained and are therefore 'invalid'. As a result none of the changes in the delta .df are committed.
FIX:
Investigate the changes that were made to identify the table and then either use the index rebuild utility to reactivate the primary index for the table that was modified, or select another index as the primary index.