Index maintenance

[Ian Wood]

On Mon, Dec 19, 2011 at 11:59 AM, Kenneth Brody <kenbrody at spamcop.net>wrote:

> On 12/19/2011 11:37 AM, Ian Wood wrote:
> > I am having an issue almost daily where a file is getting bad automatic
> indexes.
> >
> > OS is:
> > -----------------------------------------
> > System information
> > -----------------------------------------
> > Windows 2008 R2
> >     (Server Standard Edition (full installation))
> > Mapi32 DLL build 1.0.2536.0 (win7_rtm.090713-1255)
> >
> > filePro version is 5.014DN9
> >
> > When looking at the index through dxmaint it says Invalid Index. I have
> to delete the index and then rebuild it manually.
>
> The bigger problem is what's causing the indexes to become invalid.
>
> > I need to be able to put this onto a menu to allow the user to do this
> as they are not in the same building as me.
> >
> > \fp\dxmaint -ra -e won't work as the index is invalid and when I go to
> build it, the field values are blank.
> >
> > I can't use the \fp\dxmaint -rf option as this is only for demand
> indexes as far as I can see in the documentation.
> [...]
>
> While it may have once been true that "-rf" was only for demand indexes,
> this is no longer the case.
>
> But, as I said, the bigger issue is tracking down what's causing the
> indexes
> to become invalid.
>
> --
> Kenneth Brody
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

My documentation says

4.0     -RF n,l,o:n,l,o ...  rebuilds a demand index on field,length & order

However, I will test it out for the automatic indexes.

The qualifier is only used to generate labels and is deleted each time.
(Don't ask me why, I didn't write the code).

I just read Rich's response about an unprotected lookup, this is certainly
possible and I can certainly scan all my processing tables for this.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20111219/533ca4c2/attachment.html