Selection Logic - Windows 2003 filepro 5.0

Bruce Easton bruce at stn.com
Mon Apr 2 12:52:05 PDT 2007


Please see inline comments/questions...

Nancy Palmquist wrote Monday, April 02, 2007 3:31 PM:
> [..]
> We have a scan select process that runs successfully from beginning to 
> end - no errors.  It picks what seems to be the right number of records 
> which it is then supposed to copy to selected files in the output step. 
> I know it picks the right number of records because I count them and 
> display the totals in the @done logic when all is supposed to be done.
> 
> So if the source file has 40,000 records, I should end up with close 
> 40,000 records total in the files it writes.  These start blank and I 
> said close to because there is some logic to eliminate records that are 
> not billable.  (Might be 10 or 20 like that)

Are there any indexes that are used for this filtering?  Maybe the
indexes on one side are corrupt (or just different)?

> 
> When it breaks I might be missing 3000 records - a significant 
> difference.  We clear the files and run it from the Win2000 and it runs 
> flawlessley with all records copied successfully.
> 
> It has done this twice now.  The process has been running without issue 
> for years and now two months in a row we have had to rerun it repeatedly 
> to get all the records correctly copied.
> 
> The two computers use the same config file - so index scan is not 
> different.
>

How do you mean?  Based on setting of PFCMARK?
 
>[..]

Bruce

Bruce Easton
STN, Inc.



More information about the Filepro-list mailing list