Fatal error

[prustie]

Hi

I have an application written in VFP 6.0 which is causing a problem on one site where it is running on a pier to pier network with a mixture of XP and ME. The system is actually on an ME machine.

Everything runs fine except that one index keeps being corrupted.

The Table BOOKDETS has three indexes

KEY BKD_KEY primary
BOOKING TRANS(BKD_BOOKING,'@L 999999')+
TRANS(BKD_LINE,'@L 99')
TEAM STR(BKD_STYLIST,6)+DTOC(BKD_DATE)

BKD_KEY is N 6,0 BKD_BOOKING N 6,0
BKD_LINE N 2,0 BKD_STYLIST N 6,0 and BKD_DATE D

From time to time the application hangs and you have to End Task. After this if you run form the command window and SKIP down the BOOKDETS file with the ORDER set to TEAM the following fault 'Fatal error Exception Code=C0000005' occurs.

REINDEX seems to cure the problem.

Can anyone give me some pointers as to what may be causing this error?

Thanks.

Malcolm P.

 

[DSummZZZ]

Without knowing where it is crashing, it is pretty hard to say "Do this". But you can cure some ills by making sure you have the latest net drivers and stable hardware.
Also, make sure the hard drive is kept cleaned up, temp files etc.

Corrupt indexes will many times cause the app to crash. You should count on reindexing each time it does, and regularly when it doesn't. But, don't just REINDEX. Recreate the indexes from scratch. Delete the index file (.CDX) and do:

INDEX ON whatever1 TAG whatever1
INDEX ON whatever2 TAG whatever2
etc.

A currupt header will also cause you grief, that's why it's best to recreate them from scratch.
Dave S.

 

[rgbean]

Malcom,
Consider reading "Avoiding Table and Index Corruption" on Craig's site -

http://www.craigberntson.com/articles.htm

.

Rick