Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index corruption
Message
From
27/07/1999 16:37:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Index corruption
Miscellaneous
Thread ID:
00246853
Message ID:
00246853
Views:
46
I am having trouble with indexes becoming regulalry corrupted.
Problem manifests itself as users are running the application and have it lock up with the cursor set to the
hourglass. Sometimes a windows 95 illegal operation occurs. Specs are below.
The code at this point is attempting some index related function ie: set key to, seek, set order to, or executing a
function which implements Rushmore, etc. Problem can be recreated using any of these methods. Problem is with
ONLY a specific tag within the CDX. Using functions with other tags set doesn't recreate the problem.
Somehow the index has been corrupted. We delete the tags and rebuild from scratch using a data dictionary
each time we rebuild. Doing this reindex is the only way to get the users back on line without the lock-ups. It is
imperative that I identify the cause, since it results in the system being down for excessively long periods of time
for each reindex.

Application is written in Foxpro 2.6 for windows.
WorkStations are running Windows 95 with Novell Client 32 versions 2.2 ,3.01, 3.11 .
Server is Novell Netware version 4.11 with patch 6.
Network is ethernet.

Currently we are updating all workstation clients to 3.1 with Cache writes set to off and file cache level set to
zero. This is related to a knowledge based article from Novell.
Any help or suggestions will be sincerely appreciated.
Thank you in advance.

Steven Marin
Next
Reply
Map
View

Click here to load this message in the networking platform