run index maintenance error
Richard Kreiss
rkreiss at gccconsulting.net
Tue Apr 17 07:29:44 PDT 2007
> > Jeff,
> >
> > In answer to your question:
> > 1. I have tokenized the processing table as I placed
> msgbox 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?
>
Windows version 5.6.06 D9 and R9
Yes, both have been retokenized.
I use the same command line for both, just change r to d.
Menu command line
/fp/rreport l_card -f expire -v sel_expire -ic -a -u -pq
Yes I know that the lookup is causing the error. Placed a msgbox just
before the first - lookup and when the process hit that line, the index
error message appeared.
There is no show statement after that line, however I did test with another
msgbox to indicate if the process was crashing when the last record was
selected. Never reached that point. Always on the first - lookup line.
I have checked the data to see if there was anything odd, but there isn't.
Richard
Since this is a - lookup and all of the year fields are just (4,.0) fields,
there should be no problem with that.
More information about the Filepro-list
mailing list