Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index missing - The .cdx file is deleted?????
Message
From
02/02/2005 14:02:17
 
 
To
02/02/2005 13:14:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00983107
Message ID:
00983166
Views:
18
>>I actually got more details on the case. It seems that the program displays "Structural Index file" not found or something to that line. Here is the weird part... I guess the file is actually there, it has the same file size as the restored cdx file would, but if you go to the command box and use it, it will let you use without error box, but you see no indexes in it. To get even stranger, when you rebuild the first index of about 6 or 7, as soon as the first one has been rebuilt, the other ones show up fine and everything is back to normal. Any ideas?
>
>Sounds like corruption. Try DELETE TAGS ALL and rebuilding them so that you start with a clean index file.
>
>Tamar

Well see, that's the thing, I have a machine I setup bat files along with windows task manager to start at 11:00 PM and they go through each table of our program, copy it to a backup drive on the slave disk, delete the indexes, recreates each index, and then if nothing errors out, it copies them back online. This gives me a reindexed backup of each table and an online reindexed table to start with each day. The batch files have all ran through fine without errors for a while. So basically if it is getting corrupted, it is doing it every time this random whatever occurs since I have a fresh new index on them every day. Any other ideas?
``` Appreciate a normal day, it is always better than a bad one ```

Kev
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform