>>I'm getting three error messages when I run the "Validate Database" command.
>>
>>(1)Object #697 (Index "junk"): Tag not found in structural CDX for table 'health.dbf'
>>
>>(2)Object #137 (Table "hftrns"): One or more structural indexes missing from DBC.
>>
>>(3)Object #270 (Index "typeloc"): Tag not found in structural CDX for table 'master.dbf'
>>
>>
>>1. junk shows in the project manager but is no longer an index tag.
>>2. I added a new index tag "hfstsgan" = str(stateno) + str(seqno) + acct_no, but it isn't included under the table in the project manager.
>>3. same as 1.
>>
>>Looks like I need to remove two indexes which no longer exit and add one that does.
>>
>>I've tried reindexing to no avail, any thoughts would be appreciated, thanks.
>>
>>Jim
>
>okay, so the "Hacker's" guide says to open the dbc exclusive and then validate with the "recover" option.
>
>This gives you the opportunity to hopefully "fix" any problems that might have cropped up.
>
>If that doesn't work you can try to hack the dbc, or get a third party repair tool.
>
>Why does the dbc get "messed up" in the first place? I don't ordinarily open the dbc explicitly (ie; use hanover!hftrns) when I open a table to add/edit/delete a index, is that an issue???
The DBC gets opened automatically whenever a table referenced by the DBC is opened. If you attempt to open a table referenced by a DBC without the DBC being present, you will get an error message. If you are opening the table exclusively you will get the option to drop the table from the DBC, this will automatically remove all details of a Primary Key, RI and persistent relationships. It will also automatically truncate all field names to 10 characters (the long field names are stored in the DBC not the DBF header).
Do you have any code that moves / copies CDX’s and/or DBF’s that might not be correctly associated with the DBC?
censored.