freechn

[Richard Kreiss]

> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Chris
Sellitto
> Sent: Friday, March 06, 2015 9:18 AM
> To: filepro-list at lists.celestial.com
> Subject: RE: freechn
> 
> >[.....]
> > Subject: Re: freechn
> >
> > On 3/2/2015 7:20 PM, Richard Kreiss wrote:
> > [...]
> > >>> Is there a way to use a wildcard to have freechn rebuild the
> > >>> primary file as well as all of the qualifiers?
> > >>
> > >> You can't put a wildcard on the command line, but you can put it in
> > >> a loop.
> > >>    What O/S are you on?
> > >
> > > Windows
> > >
> > > I think it might be easier to just copy the command line and add
> > > each qualifier  (4).
> > >
> > > Of course one of the qualifiers has almost 20 million records at
> > > this
> > point
> > > and it grows at 1,000 records a week.  This is an indexed file.
> > >
> > > The freechn needs to be run on the server otherwise it take much too
> > long to
> > > finish.
> >
> > I guess the bigger question here is...
> >
> > Why do you need to rebuild the freechain on a regular basis?
> >
> > --
> > Kenneth Brody
> 
> On the topic of Freechains, what are the most common causes for freechains
to
> occur?  We seem to be getting them here at our facility on a daily basis.
We
> have 5.7.03, running on a Windows environment.  We have disabled the
> Window's ability to use the "X" to close a window.  Where else can we
look?
> 
> Thank you
> Chris Sellitto

Chris,

I seem to remember a discussion on this topic many years ago.  It was
related to deleting a lot of records.  It was recommended that after
deleting a lot of records (Don't know what constitutes a lot of records)
that freechn be run on that file.

In the case of my client who had this problem, they do not ship backorders
so any order item detail not shipped is deleted.  The deletion deletes the
record from the current file and their order history file.  The history file
is just shy of 20 million records and growing.  The freechn rebuild on this
file pops up almost quarterly.  I would like to have this done as a task but
I need to find time when some evening task is not being run.  One report
that gets generated takes about 3 hours to generate to a csv file and this
runs 3 times a week.  That's 3 hours on the server at night with no one on
the system.  It hits almost all of the major databases on the system.

Richard