Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupt index
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01504794
Message ID:
01504797
Vues:
67
>Hello,
>
>We have a vfp desktop application that has been running for many years without any problems. In the last month or so, we are experiencing problems with corrupt indexes. Primarily it has been restricted to one table, although I believe one other table had its index corrupted as well. This is now occurring about every other day.
>
>Another thing is it is not trashing the entire file, but it is basically mis-placing one record. Once it occurs and someone tries to search that record, they get the corrupted index message. We can scan throught the table using the index and it will find every record except that one that has been "corrupted".
>
>After we rebuild the index, everything runs fine.
>
>We are checking everything we can think of, including network cards, network lines, switches, etc. Best we can tell, it does seem to be happening on computer(s) from one corner of the building, although we can not be absolutely sure.
>
>If anyone has any suggestions, we are open to trying anything at this point.
>
>Thanks!
>Kevin Payne

This may be unrelated to your question, but can you provide index expressions to the indexes in this bad table? Could it be that you have variable length indexes? That will be my first guess to try before checking the network configuration.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform