General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
Hey,
All the indexes on this table are single field indexes and are not variable length. I had checked for that too....
Thanks!
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only