Corrupted index(s)
Corrupted index(s)
(OP)
I inherited a large Foxpro 2.5 and 2.6 database that runs on NT.
This was originally set up as peer to peer.
On reindexing the database files (that are huge), there was binary that 'snuck' in. Needless to say, the indices do not work well. And, programs that depend on them do not work at all. And, as usual, the users want things yesterday.
On reindexing, which I have tried 3 times, at varying times yesterday and this morning, I just get different types of binary.
I would really appreciate it if someone has some ideas. I ran out of them this morning.
This was originally set up as peer to peer.
On reindexing the database files (that are huge), there was binary that 'snuck' in. Needless to say, the indices do not work well. And, programs that depend on them do not work at all. And, as usual, the users want things yesterday.
On reindexing, which I have tried 3 times, at varying times yesterday and this morning, I just get different types of binary.
I would really appreciate it if someone has some ideas. I ran out of them this morning.
RE: Corrupted index(s)
Not quite sure what you mean by "binary that 'snuck' in".
Are you using the REINDEX command? In cases of corrupted indexes, it is usually recommended that you delete the existing index files and then manually recreate them from scratch.
Andy Blay
a.d.blay@talk21.com
RE: Corrupted index(s)
I get messages....
file name, index name 'binary of various types' of file.
I have been using reindex. I thought about the fact that I was just compounding the error.
The indices are all cdx. I don't know for sure what they were made of and I have no idea at all in terms of the order in which they were put.
Meanwhile, I have some other programs that are failing because they can't find the appropriate index.
The two files with the corrputed indices are in the gigabyte range.
RE: Corrupted index(s)
server = ibs.internationalbid.net
username = fpug
password = 73897253
There are programs in the directory \sharedcode\sysindex\fpw that can help you.
The Word Document Sysindex.doc tells you about files.
There is a database (SysIndex.dbf & SysIndex.fpt) there that you must populate.
The Prg DataChk will return a logical if there is a stray binary code in a memory variable.
The Prg DbfCheck runs datachk against every field in in a table in the SysIndex database.
The Prg CdxStru will collect the index information for every file in the sysindex database.
The PrgThe Word Document Sysindex.doc tells you about files. will rebuild the indexes from scratch for every file in the sysindex database.
Warning - Use the programs at you own risk. Run tests against backup files first. The code is your to use/atler/pass around as you see fit.
There is a VFP Version in the directory \sharedcode\sysindex\vfp.
David W. Grewe
Dave@internationalbid.net
RE: Corrupted index(s)
RE: Corrupted index(s)
Disp stat
c:\patient.dbf
STRUCTURAL INDEX patient.cdx
INDEX TAG NAME Primaryindex alltrim(name)+dtoc(dob)
INDEX TAG NAME Secondkey alltrim(recno)
Now when you will delete patient.cdx it will delete Primaryindex and secondrykey tags.
Now make new index file by using the same structure shown above.
farrukh
RE: Corrupted index(s)