run index maintenance error

[Jeff Harrison]

--- GCC Consulting <gccconsulting at comcast.net> wrote:

>  
> > > I have a report using -v select processing.
[snip]
> > > 
> > 
> > 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
> 

Have you re-tokenized the OTHER processing tables
involved?  What version of dreport, rreport and
dxmaint are you using?  You should supply 3 different
version numbers - get them by running each program
with PFVER=ON
 
What is the exact command line that you are using when
you use dreport?  What is the exact command line that
you are using when you use rreport?

Do you know that this lookup is the cause of the
error?  Do you have a show statement immediately after
this line that never gets executed?

Granted that this should not cause an error, but what
key(s) and length(s) is the index built on?  Are they
the same as the key to your lookup?

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The fastest and
easiest ways to generate filepro exports and imports.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com