Weird behavior after index rebuild

[Kenneth Brody]

On 1/21/2014 9:46 AM, Boaz Bezborodko wrote:
[...]
>> One other point.  I found that one of the files had a problem that
>> caused a "Sanity Check" error.  The file was one of the ones I found
>> that had been corrupted which screwed up a process.  When I ran a
>> program to correct the data I got this error on one of the records. I
>> had rebuilt the indexes before running the program which cleared the
>> data in some fields in certain records.  When I reran the process it
>> started from the records that had not yet been touched. I forgot to
>> get a screen shot.
>>
>> Is there a way to check the files for the kind of errors that would
>> create a Sanity Check error?

You would need to post the complete, exact, message in order to figure out 
the problem.

> It seems that I'm having other problems with date indexes.  I have some
> old files that have a date field with a (9,mdy/)  I think the original
> programmer did this so that the user would have to press enter to move
> on to the next field.  The thing is that if I enter a date (say 1/20/14
> which I know is in one of the records) it won't come up.
>
> In this case it's non-critical.  But there may be other areas he did
> this that I haven't ID'ed.  Is there a way to fix this so that it works
> the old way?

If the index was never rebuilt since 4.8, it's possible that it was in the 
"old" format, and rebuilding it made it the "new" format.

Try setting PFOLDIX=ON and rebuilding it again.

Of course, you may also want to consider using (10,mdyy/) for dates as well.

-- 
Kenneth Brody