Deleted Key not Found 2 - Network 5.0 filepro on Windows

[Bruce Easton]

Mark wrote Wednesday, August 01, 2007 1:13 PM:
[..]
> I've got a way to generate DKNF at-will.  I brought it up a while back but
> nobody ever responded to it.  I'll try again.
>
> fP 5.0.14 native on Windows 2003 Server
>
> File is a foreign file with two indexes, one built across two fields, the
> other across a single field.
>
> Add a record to the file from within dclerk.
>
> Congratulations on your brand, spankin' new DKNF!
>
> However, the record appears in the key segment, and the index entries are
> made, as lookups and all seem to work fine afterwards.  You just get the
> spurious error for no apparent reason.
>
> Anyone have an explanation?  It happens with two files that are
> essentially
> identical except for the data within them.  Same structure and indexes.
> Doesn't seem to be data-dependant at all, other than the fact I'm adding a
> data by adding a record.  I've even tried just reiterating the data from
> one record into adding the new record and still get the error.
>

Mark - I tried the scenario you describe under Unix -same fp version:

I made a non-filepro file called junk
built index A on field 1 for length of 3 (lengths of fields 1 & 2)
built index B on field 2 for length of 1 (full field),

also tried
index A built  with two levels on fields 1 & 2, (each on full length
of field)

and I cannot duplicate that.  I tried both a free record lookup from
another file and manually adding a record.  Are you adding the record
via lookup from within the file that you are adding to? (If so, from
within what type of event?)

Have you rebuilt all the indexes before trying this?  Also, does your
index built across two fields do so at one index def level or do you
build using separate index levels?  What env. vars. do you have set
that may govern how indexes are built?  (I'm just trying to duplicate
exactly your situation.)

Bruce

Bruce Easton
STN, Inc.