Save command
Richard Kreiss
rkreiss at verizon.net
Tue May 17 11:44:51 PDT 2011
> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of Kenneth Brody
> Sent: Tuesday, May 17, 2011 12:25 PM
> To: flowersoft at compuserve.com
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Save command
>
> On 5/17/2011 11:48 AM, flowersoft at compuserve.com wrote:
> > The record is written to disk as soon as a save is executed or before
> > that if you do a 'write' in processing.
>
> No, the record isn't written until processing ends, or an explicit WRITE
is
> executed.
>
> > I don't think a 'free chain' should be run if anyone else is adding
> > records to the database. My experience with this is that the free
> > chain never stops running and the other stations 'hang up' until
> > everyone else stops adding records to the database. If a station
> > needs to run a 'free chain' you should have the other users exit the
> program.
>
> The freechain rebuild handles people in the file during the rebuild,
including
> adding records. I have heard over the years from a few people that the
> rebuild hangs or gets in an infinite-restart in such a case, but no one
has ever
> gotten me a demonstrable case.
Ken,
At my client's site with field reps using terminal server to access the
system, whenever the free chain rebuild starts, the records being added are
not saved.
We can track what records are not saved as prior to the record being saved,
2 memo records are created. The first is cs_memo which has the tracking
number assigned to the parent record in cstrack and in market_memo which has
the tracking number as part of the memo. In all instances, I have been
advised, the problem occurs during the freechain rebuild.
I have checked all of the programs that either access this file or write to
this file, all lookup are protected. Records are added through a system
call using an input program called "enter". The basic difference between
this program and the input program is the lack of @key functions and the use
of EXIT after a tracking record has been added.
The Lookup to this file from their marketing file is a browse and only lists
open tracking items. There is no posting to this file from marketing. Any
updating of a cstrack record occurs directly through IUA in that file.
I am a loss as to why this file, which is fairly small, is having a
freechain problem.
The only thing I can think of is that the problem may be caused by problems
with the remote session. They were having some weather related issues today
with their internet connections.
Richard
More information about the Filepro-list
mailing list