Selection Logic - Windows 2003 filepro 5.0

[Nancy Palmquist]

Steve Wiltsie wrote:
> ----- Original Message ----- 
> From: "Nancy Palmquist" <nlp at vss3.com>
> To: "filePro List" <filepro-list at lists.celestial.com>
> Sent: Monday, April 02, 2007 2:30 PM
> Subject: Selection Logic - Windows 2003 filepro 5.0
> 
> 
> 
>>I apologize if you got this a second time, I did not see this post to
>>the list.
>>
>>Ignore if you already got this ---------------
>>
>>Well I have a very weird event and want to see if any others have had a
>>similar experience.
>>
>>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)
>>
>>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.
> 
>>One computer is running Windows2000 and one is running WindowsXP.
>>
>>The switch speed for the WindowsXP is much faster and it is the one that
>>seems to be skipping over records.  Could the switch be dropping packets
>>or something without the OS noticing?
>>
>>Does anyone have any notion what we might look for to try to put this
>>process back to working correctly every time?
>>
>>Nancy
> 
> 
> Nancy,
> 
> There are a lot of variables here.  Are the filePro programs on the Windows
> 2003 server and run from it by the workstations or are the programs on the
> PCs and only the data on the server?  

Data and filePro sits on the Server -  Execution is initiated by the 
workstation.


I would try to run the same thing from
> another XP workstation or connect the XP machine into the same network
> switch the Windows 2000 workstation is on to see if that made a difference.

We did make some changes here and I will have to verify the results. 
That is the only real difference we could determine between what worked 
and what didn't.

I would expect the XP has all the current patches but I need to verify that.


> I would also check for Windows Updates on the XP PC to see if the new
> 'stability fix' is needed for that computer.
> 
> Steve Wiltsie
> microCONCEPTS Div. multi/user/inc.        Since 1981
> (812) 474-0127                          Fax: (812) 474-0147
> 
> 
> 


-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com