Kbase P66612: S/E 1422 for Index XIE2gsc_entity_mnemonic
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/04/2009 |
|
Status: Unverified
SYMPTOM(s):
SYSTEM ERROR: Index XIE2gsc_entity_mnemonic in gsc_entity for recid <RECID> could not be deleted. (1422)
Index <indexname> in <tablename> for recid <recid> could not be deleted. (1422)
A field was added to a table and its corresponding entity deleted and then reimported
The dynamics database was backedup prior to the delete and import
FACT(s) (Environment):
Dynamics 2.1A
CAUSE:
The index corruption , as per error 1422, is due to a none fully identified 4GL bug. Separating the actions which modify the index XIE2gsc_entity_mnemonic minimizes the risk of hitting the bug.
FIX:
Restore the backup of the dynamics database
Do the two steps, delete entity and import entity, within two separate sessions.