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