Would you be willing to post the code for your error handler for historical purposes for developers that come across this problem in the future and search the UT for a resolution?
>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?
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"