Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index corruption
Message
From
27/07/1999 18:17:38
 
 
To
27/07/1999 16:35:01
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00246852
Message ID:
00246903
Views:
14
>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

Is there a field in this index that does not exist in other index tags? If so, I would look at data corruption in the table. BTW, what is the key to this tag?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform