run index maintenance error

GCC Consulting gccconsulting at comcast.net
Tue Apr 17 09:11:47 PDT 2007


OK all, here is an odd one regarding this problem.

I copied l_card the n_card using fpcopy and then rebuilt all of the auto
indexes.

Changed the menu command line to run n_card.  Report ran as it should using
rreport.

Renamed l_card to k_card and renamed n_card back to l_card.  Modified the
command line again to run from l_card.

The report gave me the same error.

Copied the file to k-card, ran the report, no error.

Only with the file name l_card does the error happen.

Richard


> -----Original Message-----
> From: 
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> .com 
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> elestial.com] On Behalf Of GCC Consulting
> Sent: Tuesday, April 17, 2007 11:32 AM
> To: 'Bruce Easton'; filepro-list at lists.celestial.com
> Subject: RE: run index maintenance error
> 
> Bruce,
> 
> Just modified the selection process to use demand index 1.
> 
> Then index error now says the l_card index K is invalid.  
> There is no index K,  the last auto index is index I.
> 
> Now this is getting even more interesting.  
> 
> I think I'll sent this to fp support as there is definitely 
> something wrong.
> 
> Richard 
> 
> > -----Original Message-----
> > From: 
> > filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> > .com
> > [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> > elestial.com] On Behalf Of Bruce Easton
> > Sent: Tuesday, April 17, 2007 10:35 AM
> > To: filepro-list at lists.celestial.com
> > Subject: RE: run index maintenance error
> > 
> > GCC Consulting wrote Tuesday, April 17, 2007 9:52 AM:
> > [..]
> > > > > where the process was when the error occurred when 
> using rreport
> > > > > 	2. The index has been built, rebuilt, deleted
> > and rebuilt
> > > > >
> > [..]
> > Bruce wrote:
> > > >
> > > > 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.
> > > >
> > [..]
> > >
> > Richard replied:
> > > Bruce,
> > >
> > > As stated, the offending index has been rebuilt and deleted
> > and rebuilt.
> > >
> > [..]
> > 
> > Richard - should I conclude from your reply that you only have one 
> > automatic index in the file "W:\ccp/filepro/l_card?"
> > 
> > Bruce
> > 
> > Bruce Easton
> > STN, Inc.
> > 
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> > 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 




More information about the Filepro-list mailing list