Index maintenance

Ian Wood iwood at guaranteedreturns.com
Mon Dec 19 08:37:43 PST 2011


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.

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.

The only thing I can think of is to copy the index to a named index while the index is valid, and then have the menu script do the following
(the bad indexes are in a qualifier called label)

cd \filepro\gr_bag
del indexlabel.A
del indexlabel.B
copy indexlabel.goodA indexlabel.A
copy indexlabel.goodB indexlabel.B
cd\
\fp\dxmaint gr_bag -ra -e -m label

If anyone else has a better idea, feel free to shout it out.

I still need to find what is causing this, but I didn't write the code that this process runs from and don't have time right now to dig though and/or rewrite the process.


Ian Wood
Programmer/Analyst

Guaranteeed Returns
100 Colin Drive
Holbrook, NY 11741
(800) 473-2148 ext 109
Fax (631) 689-0196
iwood at guaranteedreturns.com
[siglogos]

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipients and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail, delete this message and destroy all copies thereof.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20111219/61721e9e/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 8683 bytes
Desc: image001.jpg
Url : http://mailman.celestial.com/pipermail/filepro-list/attachments/20111219/61721e9e/attachment.jpg 


More information about the Filepro-list mailing list