We've now deployed a modified error handler in production using sys(1104) and a RETRY.
All is fixed!!
Thank you, thank you, thank you.
>Hi David,
>
>Take a look into thread #
810798.
>
>Thanks,
>Aleksey.
>
>
>>We continue to get an increasing number of these errors over a period even though the index is not corrupted...
>>Error: 2066 - Index file "h:\ht\quids\data\jitems.cdx" is corrupted. Please rebuild it.
>>
>>The table has approx 2.3 million records has 8 index tags including one on deleted. There are only 200 deleted records. There are large numbers of transactions on this file every day, perhaps 50,000 or so. It's not that huge in terms of disk space, 470MB for the dbf and 95 MB for the CDX.
>>
>>300 users, and we get perhaps 20 errors per day.
>>
>>Any ideas folks?