Kbase P12127: SYSTEM ERROR: Invalid recid in index <index-num> on file <file-name>. Entry ignored. (18)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/2/2010 |
|
Status: Unverified
SYMPTOM(s):
Error 18 with a RECID value of "?" or "0"
SYSTEM ERROR: Invalid RECID in index <index-num> on file <file-name>. Entry ignored. (18)
SYSTEM ERROR: Invalid RECID in index 16 on file 16. Entry ignored. (18)
SYSTEM ERROR: Invalid RECID in index 2 on file 2. Entry ignored.
the <index-num> and <file-num> attributes of the System error are always the same
If you have a sequence linked to the table which is given the error, it can happen that the sequence has been reset itself to zero.
The error appears in the database log file, not on the client.
FACT(s) (Environment):
Progress 9.x
All Supported Operating Systems
OpenEdge 10.x
OpenEdge Category: Language (4GL/ABL)
CAUSE:
This is a known issue.
The error happens the RECID is "?" or "0".
DEFINE VARIABLE p-irecid AS RECID initial "?" NO-UNDO.
open query q FOR EACH customer
WHERE RECID(customer) = p-irecid SHARE-LOCK.
GET FIRST q.
CAUSE:
Bug# OE00083039
FIX:
None at this time.
As a work around, use "-1" instead of a "?" or "0" to return an invalid RECID.