Odd Problem Windows platform

[Richard Kreiss]

Windows Server 2008
Windows 7 Pro

FilePro 5.7.03.06

I have a select process which is used for creating a report of transaction to run and to do the actual run.

I received a call yesterday that the select process was "hanging up".  It would select the records to process but then stop. This select process uses a - lookup using index K - built on a date and transaction type.

I logged into their system with Remote Desktop to their IIS server.  This has a mapped drive to their database server.

When I run this processes, it runs properly.  I used the script and logged into the application as would a user and again had no trouble running this report.

My client tried to run this report both locally through his network connection and then again logging into the IIS server.  Both times the select process got "hung up".  

I added a show statement so I would know the record number of the last record selected and then used that information to browse index K for any unusual records.  I found none.

The starting date is 01/15/2015 and the ending date is today's date.  When the execution date in the transaction is larger than today's date, the program does a - lookup using the date 12/31/2029 and get lower,  The highest date currently is below 12/31/2018.  

The program will test a number of fields and end if the field value matches the test.

Since I can't duplicate the problem when I log in, does anyone have any suggestions as to why they can't run the selection to completion and I can?


Richard Kreiss
GCC Consulting