Kbase P7953: Schema changes to the database seem to get lost
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/15/2011 |
|
Status: Verified
SYMPTOM(s):
Character Client
Schema changes made to the database through the Data Dictionary Tool seem to get lost
Database table that is being modified has an inactive index
An error message quickly flashes and disappears from the screen
Primary index <index> must be active to make the requested changes. (997)
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
CAUSE:
The primary index for a particular database table must be active in order for schema changes to be applied to that table. When using a Character Client, the message is not displayed long enough to read the message.
FIX:
Always activate the primary index for the table that is going to have modification in its schema. If it is currently inactive, then activate it through the PROUTIL -C IDXBUILD utilitiy.