Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reason for index corruption?
Message
From
18/09/2006 11:07:42
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
 
 
To
18/09/2006 08:24:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 4.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01154622
Message ID:
01154709
Views:
18
Hi Christian,
I assume we've met.
I am on a Novell Network, and I have similar problems unless we set the Novell Client to File Caching = Off and File Commit = On.

>Hello,
>
>At one client it happens very frequently that the index of some tables gets corrupted.
>
>My guess is that the network connection is not very stable, but they checked the connection and say there should be no problems with the network.
>
>Yesterday a table got corrupted with the message (when appending a record):
>
Index file "c:\Cinemas\transactions.cdx" tag "Trusedt" is corrupted. Please rebuild it."
>
>After that we suggested to run the program locally on the computer. I issued a REINDEX and they worked again. After 20 minutes the same message appeared.
>
>Then I deleted the CDX file and created the indexes again. That seemed to have helped, but I am not sure what causes this problem.
>
>The other strange thing is that this program does not alter the field Trusedt.
>
>Any ideas where I can look for a solution?
Charlie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform