Kbase P47994: Running a delete statement aborts with a 1422 error.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/8/2005 |
|
Status: Unverified
FACT(s) (Environment):
Solaris SPARC 2.8 64-bit
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Error 1422 running a 4GL program.
for each <tablename>: delete <tablename>. End.
The error aborted the delete.
SYSTEM ERROR: Index in for recid could not be deleted. (1422)
CAUSE:
corrupt index.
FIX:
In this case the choice was to create a (data definition) .df file for the table.
drop the table.
Reload the .df file for the table.