DKNY error

[Jeff Harrison]

--- Don Coleman <dcoleman at dgcreact.com> wrote:

> For the past week or two the following table has
> been causing DKNF errors on
> one index in this file (E).  This table runs as the
> second part of a script
> where part one is an ascii import process.  As you
> can see there is no
> delete functions in this table yet the field index E
> is built on (149) is
> modified.  However, each night an archive process
> runs on this file which
> deletes 30,000-40,000 records from this file.  Total
> number of records in
> this file is approx. 70,000.  Each night via
> scheduled tasks FREECHAIN.EXE
> plus each index in this file is rebuilt.  Yet each
> day we are having to have
> each user exit fP and manually rebuild this one
> index once or twice per day.
> Does anyone see anything in this table that I am
> missing which could be
> causing the DKNY error?  fP v5.0.13, Windows 2000 &
> XP Pro clients, WIN2000
> Advanced Server.  TY,
> 
>

Your code looks ok to me Don.  It should not be
causing a DKNF error.  Also, the freechain program
should not have anything to do with the indexes.  I'm
wondering why you have each user rebuild the indexes? 
I would think that the indexes would only need to be
rebuilt once after a DKNF error.

Are you sure the delete process works without any
errors?  Are you rebuilding the indexes after the
deletion process?

At any rate you should not be getting these errors -
you may want to send the file and processing to fptech
to see if they can duplicate this.

Good Luck.

Jeff Harrison
jeffaharrison at yahoo.com

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com