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