<html><head></head><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1484061617183_48633" dir="ltr"><span id="yui_3_16_0_ym19_1_1484061617183_48689">I have a processing table that rebuilds all automatic indexes that I run either every night or once a week on a few of my clients' systems. It does not solve the problem like fixing the code would, but it may help while you are trying to track down the root cause and is still not a bad idea to run weekly even when you do. I'd could send you the processing table I wrote if you are interested.</span></div><div id="yui_3_16_0_ym19_1_1484061617183_48633" dir="ltr"><span><br></span></div><div id="yui_3_16_0_ym19_1_1484061617183_48633" dir="ltr"><span id="yui_3_16_0_ym19_1_1484061617183_49092">Bill Lucca</span></div><div id="yui_3_16_0_ym19_1_1484061617183_48633" dir="ltr"><span><br></span></div> <div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1484061617183_49145"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1484061617183_49575" style="display: block;"> <div style="font-family: verdana, helvetica, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1484061617183_49574"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1484061617183_49573"> <div dir="ltr" id="yui_3_16_0_ym19_1_1484061617183_49572"><font size="2" face="Arial" id="yui_3_16_0_ym19_1_1484061617183_49571"> On Tuesday, January 10, 2017 1:10 PM, Kenneth Brody via Filepro-list <filepro-list@lists.celestial.com> wrote:<br></font></div> <br><br> <div class="y_msg_container">On 1/10/2017 12:15 PM, Linda Gray via Filepro-list wrote:<br clear="none">> Hi all,<br clear="none">><br clear="none">> We have an index.A for a sometimes large file. We run a lot of reports from<br clear="none">> this file using the index. The index is constantly getting corrupted. Does<br clear="none">> anyone know of a way to prevent this?<br clear="none"><br clear="none">In what way is it getting "corrupted"?<br clear="none"><br clear="none">I might suggest the first think to do is set PFCHECKLOCK=ON and <br clear="none">PFCHECKLOCKLOG=/path/to/a/logfile. See if there are any unprotected lookups <br clear="none">that are being modified.<br clear="none"><br clear="none">(Also, what is a "sometimes large file"?)<br clear="none"><br clear="none">-- <br clear="none">Kenneth Brody<div class="yqt3954467833" id="yqtfd95196"><br clear="none">_______________________________________________<br clear="none">Filepro-list mailing list<br clear="none"><a shape="rect" ymailto="mailto:Filepro-list@lists.celestial.com" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br clear="none">Subscribe/Unsubscribe/Subscription Changes<br clear="none"><a shape="rect" href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br clear="none"></div><br><br></div> </div> </div> </div></div></body></html>