Kbase 16171: SE: Index in for recid could not be deleted. (1422) V7
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/7/2002 |
|
SE: Index in for recid could not be deleted. (1422) V7
Version 7 bug# 19951006-052.
There is a bug that occurs when a FIND fails due to either a write
trigger or validation which must be performed on a record in the
buffer before the FIND can be executed. The invalid (updated record)
in the buffer may get into the database. Sometimes this record may
be blank. When this occurs, you will see the following system error.
SYSTEM ERROR: Index in for recid could not be deleted. (1422)
The 1422 error indicates there are duplicate records. You need to
delete the duplicate record using the RECID to find the record.
The problem is caused by a FIND ... NO-LOCK after a record that will
fail validation is created in the same buffer. You can workaround
this by placing the statement
RELEASE my-table [NO-ERROR].
before the FIND. This will prevent the creation of the invalid
records.
This bug is fixed in the following patch versions:
DG/UX V.4 7.3C02
HP/UX 7.3C02
IBM AIX 7.3C02
SCO/UNIX 7.3C02
SUN SOLARIS 7.3C02
UNIX386 V.4 7.3C03
26-Sep-96
Progress Software Technical Support Note # 16171