We are running a VFP 9.0 SP2 application on a virtual terminal server (VMware running Windows 2008 Standard R2 64 bit) with Xbase data stored on second virtual server (VMware Windows 2008 SBS SP2 64 bit). The data stored on that server is accessed by local workstations throughout the day without any issues. Terminal server users logon at night and encounter intermittent VFP 1104 errors (error reading file) on different tables in random areas within the application. Here are a few basic facts:
The application works fine in other TS environments.
There are never more than 8 concurrent TS users logged on at night.
Neither server ever gets close to maximizing any system resources.
Users do not complain about lags prior to errors.
The antivirus software is configured to skip cdx, dbf, and fpt files.
No backup or scheduled tasks are running during the errors.
TS users can sometimes go several nights without any errors.
The errors can occur anywhere within the application.
Errors can sometimes be light (1-12 per night) or heavy (100+).
On a night with heavy errors the users can sometimes work for an hour without any errors.
Disconnected sessions close automatically after 15 minutes.
All TS users have the same rights.
All data folders and subdirectories grant full access to everyone.
The TS is rebooted weekly.
Rebooting the TS does not make errors any less likely.
There are no system events to suggest
This is the additional error information passed back by the VFP AERROR() function:
Error Number: 1104
Error Text: Error reading file s:\netdata\tables\user.dbf.
Error Table: s:\netdata\tables\user.dbf
OS Error: 64
OS Text: The specified network name is no longer available.
It is not as frequent, but sometimes the last two lines of AERROR() return:
OS Error: 59
OS Text: An unexpected network error occurred.
Thanks in advance for your time.