Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Urgent- Index does not match table error
Hi there,
One of our clients is in deep trouble.
On of the tables of our application is corrupt, and the foxpro message "index does not match table-delete index file and recreate" appears.
We got hold of their file (dbf, cdx,fpt) as well as their Database container (Dbc,dcx and dct).
We used reindex, but the same problem appears.
I deleted the index file, but after rebuilding the index file from scratch, the same problem appears.
I took the dbf and fpt and attached it to a fine working database container, and then rebuilt the index file. you guessed.. the same problem appears.
I noticed that during the reindex process, the names of the index tags are corrupted. There are six indexes and from the fourth on, the actual names of the indexes you see on the screen during reindexing (building of keys and indexes) do not match the names of the indexes you see when you look at the table properties. The last few characters are corrupted, and you get strings like IXCLI ÿcL_þ where I would have expected IXCLIENT.
The error seems to reside in the .DBF file, resulting in faulty index files at each rebuild (which is , of course, based on the .dbf files. However, I can't find any apparent errors in the dbf. It all seems normal.
It is a fairly big file, 80 MB at 700.000 records.
Any bright ideas? This client has 50 employees doing nothing because their main application is down and I'm feeling guilty because I'm the one that's supposed to solve all proiblems here!
Thanks in advance,
Geert van Snik
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement