<br><br><div class="gmail_quote">On Mon, Dec 19, 2011 at 11:59 AM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net">kenbrody@spamcop.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">On 12/19/2011 11:37 AM, Ian Wood wrote:<br>
> I am having an issue almost daily where a file is getting bad automatic indexes.<br>
><br>
> OS is:<br>
> -----------------------------------------<br>
> System information<br>
> -----------------------------------------<br>
> Windows 2008 R2<br>
> (Server Standard Edition (full installation))<br>
> Mapi32 DLL build 1.0.2536.0 (win7_rtm.090713-1255)<br>
><br>
> filePro version is 5.014DN9<br>
><br>
> When looking at the index through dxmaint it says Invalid Index. I have to delete the index and then rebuild it manually.<br>
<br>
</div>The bigger problem is what's causing the indexes to become invalid.<br>
<div class="im"><br>
> 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.<br>
><br>
> \fp\dxmaint -ra -e won't work as the index is invalid and when I go to build it, the field values are blank.<br>
><br>
> 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.<br>
</div>[...]<br>
<br>
While it may have once been true that "-rf" was only for demand indexes,<br>
this is no longer the case.<br>
<br>
But, as I said, the bigger issue is tracking down what's causing the indexes<br>
to become invalid.<br>
<font color="#888888"><br>
--<br>
Kenneth Brody<br>
</font><div><div></div><div class="h5">_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br>My documentation says <br><br>4.0 -RF n,l,o:n,l,o ... rebuilds a demand index on field,length & order<br><br>However, I will test it out for the automatic indexes.<br><br>The qualifier is only used to generate labels and is deleted each time. (Don't ask me why, I didn't write the code).<br>
<br>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.<br>