Index is too big error (GRX)

John Esak john at valar.com
Tue Sep 18 15:43:32 PDT 2007


Hey Ken,

Just curious. This is such a great page you point to here. Is there a page
that has *every* known filePro env var done in this format??  That would be
great.  Currently, I'm always going into the dmakemenu help or all over the
place, or string'sing dclerk|grep PF'ing for new vars, and that of course
doesn't give explanations.  And, just for a laugh, do you know how many
filePro env vars there are now?  Any way to count them all throughout all
the source?  Say, just for dclerk and dreport? 

Thanks,
John




 -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.com] On Behalf
> Of Kenneth Brody
> Sent: Tuesday, September 18, 2007 12:52 PM
> To: Chris Sellitto
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Index is too big error (GRX)
> 
> Quoting Chris Sellitto (Tue, 18 Sep 2007 11:10:21 -0400):
> 
> > DXMAINT: 5.0.14DN9
> > Windows XP
> >
> > Hello All,
> >
> > Does anybody know how to overcome this error?
> >
> > -----------------------------------------------------
> > *** A filePro Error Has Occurred ***
> >
> > Error Writing Sort Key
> >
> > On File:
> >
> > Index Is Too Big
> > Rebuild the index using a smaller key.
> >
> >
> >  Press  H -Hardcopy  ?--+ -Continue
> > -----------------------------------------------------
> >
> > I am trying to create a demand index on the first 13 fields of a
> > file for a length of 105.
> > The number of records in this file is 7,043,444.
> >
> > Are there any environment variables that need to be set?
> 
> http://www.fptech.com/Products/Docs/FPFormat/envvars.shtml#indexes
> 
> Check out PFMAXALLOC and PFMAXASIZE.
> 
> --
> KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com
> _______________________________________________
> 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