Kbase P123496: Schema change appears successful, no error received in character mode, but changes are not saved.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/05/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Running character client session.
Running CHUI session.
Schema change is successful.
Schema change is not saved when committed.
No error on commit.
Character client is not reporting error.
Primary Index is inactive.
expected error when Primary index is not active is (997).
Primary index must be active to make the requested changes. (997)
CAUSE:
Some error message are only visible for a character client by reviewing "recent messages" under the menu item "help/recent messages". In this case when this is checked the message:
Primary index <name> must be active to make the requested changes. (997)
was found.
FIX:
Schema changes are not allowed to a table when the primary index is inactive.
1. Activate the primary index.
2. Make schema changes.
3. Commit changes.