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