Page 1 of 1

dbAppend() spurious errors

Posted: Mon Jan 03, 2022 11:16 am
by rdonnay
Bobby's Medallion program occasionally gets a runtime error when calling dbAppend(1).

There is no error information except a gencode of 8999.

Has anyone experienced this error?

Re: dbAppend() spurious errors

Posted: Mon Jan 03, 2022 12:14 pm
by jezda
maybe this will help:

5xxx - ???:
===========
5381 - [BASE] - ???
Associated with (non-standard) Gen Error: "8999"
Can be caused by: "OrdCreate()" when Tag Name is longer than allowed (e.g. 11 characters for a CDX Index)
Can be caused by: "DbAppend()" when database (session) is opened via PGDBE
Remarks: NOT Listed in PDRs 109-4341 and 109-6356

Re: dbAppend() spurious errors

Posted: Mon Jan 03, 2022 12:51 pm
by rdonnay
Thanks, but that's no help.
Those conditions don't exist.

Re: dbAppend() spurious errors

Posted: Mon Jan 03, 2022 3:17 pm
by bobvolz
I get this now and then. It is usually a corrupted index. I manually delete the index and Bobby's Usedb() recreates it. Problem solved.
Bob Volz

Re: dbAppend() spurious errors

Posted: Tue Jan 04, 2022 12:45 am
by skiman
Hi,

I noticed the same as Bob. If a db... error (dbappend,dbgoto,dbskip,...) appears, recreating the index files solves it.