DKNY error

[Don Coleman]

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,


Aug 14, 2006  15:14           File Name: QS1                       Page   1
                             Processing: WHZONE

   1 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 9 eq AA
       Then: goto zone
   2 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: AA(4,ALLUP,g)=9
   3 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: lookup req = labelreq  k=9    i=A -nx
   4 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: not req
       Then: end
   5 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: AB(3,.0,g)=req(28)
   6 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: (AB ge "1" and AB le "50") or (AB ge "211" and AB le "257")
       Then: AC(1,.0,g)="1";goto zone
   7 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: (AB ge "51" and AB le "100") or (AB ge "258" and AB le "300")
       Then: AC="2";goto zone
   8 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: (AB ge "101" and AB le "150") or (AB ge "301" and AB le "347")
       Then: AC="3";goto zone
   9 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: (AB ge "151" and AB le "196") or (AB ge "348" and AB le "391")
       Then: AC="4";goto zone
  10 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: (AB ge "197" and AB le "210") or (AB ge "392" and AB le "403")
       Then: AC="5"
  11 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
zone     If: AB eq ""
       Then: 148="";149="";write;end
  12 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: 148=AB;149=AC;write;end



Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302