run index maintenance error

GCC Consulting gccconsulting at comcast.net
Tue Apr 17 05:50:54 PDT 2007


 
> > 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.
> > 
> > The problem seems to be at line 11
> > 
> > Year(4,.0), syear and lyear are (4,.0,g).  Index C is built on year
> > 
> > Lyear is "2099"
> > 
> > top    â—„ If: expire_date = ""
> >        Then: GOTO begin
> >   9  -------   -   -   -   -   -   -   -   -   -   -
> >   -   -   -   -   -   -
> >        â—„ If: year lt syear           'select
> > everything before syear
> >        Then: GOSUB chk_mem           'then drop to
> > next line
> >  10  -------   -   -   -   -   -   -   -   -   -   -
> >   -   -   -   -   -   -
> >        â—„ If: year lt syear
> >        Then: lookup -  k=(syear)   i=C -ng
> >  11  -------   -   -   -   -   -   -   -   -   -   -
> >   -   -   -   -   -   -
> > is_doneâ—„ If: year gt syear
> >        Then: lookup -  k=(lyear)   i=C -nl
> >  12  -------   -   -   -   -   -   -   -   -   -   -
> >   -   -   -   -   -   -
> >        â—„ If:         is_done
> >        Then:         END
> > 
> > I have checked the data in the file and corrected any that 
> might have 
> > created a problem.
> > 
> > Any suggestion as to what I may be looking for?
> > 
> > Richard Kreiss
> > GCC Consulting
> >  
> > 
> 
> 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
  




More information about the Filepro-list mailing list