run index maintenance error
Bruce Easton
bruce at stn.com
Tue Apr 17 06:36:53 PDT 2007
Richard Kreiss wrote Tuesday, April 17, 2007 8:51 AM:
> Jeff Harrison wrote:
> >
> > > I have a report using -v select processing.
> > >
> > > When run using rreport I get an index maintenance on the
> > index being
> > > used for the - lookup.
> > >
> > > Run the same report using dreport, it runs perfectly.
> > >
[..]
> >
> > Hi Richard. What is the exact error message that you are
> > getting? I don't think it really is "Index Maintenance".
> > When you get different results with rreport and dreport the
> > first thing to check is that you have tokenized all of the
> > tables that could be used. Especially the output processing
> > table, -v table, and automatic processing table.
> >
> > Also, have you re-built index C?
> >
> > Good Luck.
> >
> > Jeff Harrison
> >
>
> Jeff,
>
> In answer to your question:
> 1. I have tokenized the processing table as I placed msgboxes to
> show where the process was when the error occurred when using rreport
> 2. The index has been built, rebuilt, deleted and rebuilt
>
> Here is the message
>
>
>
> *** A filePro Error Has Occurred ***
>
> Fatal error
>
> On File: W:\ccp/filepro/l_card/index.C
>
> Invalid index.
> Run Index Maintenance to rebuild the index.
>
>
> So, with the processing table and token table the same, why should dreport
> work and rreport fail?
>
> Richard Kreiss
> GCC Consulting
>
Just a couple of things to check.
1. In the few cases I've seen with the behavior you describe, more than
once the problem did not go away until all the indexes in the offending file
were rebuilt.
2. If your report calls an auto table other than the default that it used
based on way report is called from your development menu/script that you are
using to tokenize, then try retokenizing with an explicit -y <rptautoname>
as part of you rcabe command. Maybe something in a default auto table is
conflicting with your report output processing.
Bruce
Bruce Easton
STN, Inc.
More information about the Filepro-list
mailing list