Running a report without indexes

Kenneth Brody kenbrody at spamcop.net
Tue Mar 19 07:42:12 PDT 2013


On 3/19/2013 9:55 AM, Ian Wood wrote:
> filepro 5.07.03.02
> Windows Server 2008
>
> We currently run an overnight process that exports data from about 50 files
> to feed another system.  Periodically, we get an invalid index error on one
> of the files, not one in particular, just a random spot.  I have the -ro
> flag set to run as read only.
>
> Is there a way to have rreport run on files and ignore automatic indexes?
> I'm not posting anything, just doing file dumps.

If you're running with "-ro", then the problem isn't when updating an index 
(which it won't do in read-only mode), but when reading an index.  Assuming 
that the error doesn't occur on the temp index that *report built, then I 
can only assume that the error occurred on a lookup.  (What index did the 
error occur on?)  And the only index being accessed when executing the 
lookup it the index being used for that lookup, which you obviously can't 
avoid using.

> I don't have enough time to do a dxmaint -ra -e on all files first as we
> run two shifts and the exports take approximately 5-6 hours to run.

If you are looking up to a file via a corrupted index, you may have no 
choice but to rebuild that index.

-- 
Kenneth Brody


More information about the Filepro-list mailing list