Generating Output Count

Bruce Easton bruce at stn.com
Wed Dec 2 12:00:20 PST 2009


Nancy Palmquist wrote Wednesday, December 02, 2009 11:26 AM:
> 
> Guys,
> 
> I am wondering how I got this result.
> 
> I am watching a report process.  The screen displays something like:
> 
> Records Selected: 29953
> 
> Generating Output: 21900
> 
> And all of a sudden, I get the message that is activated by 
> @done processing and the report ends.
> 
> It has happened twice now, and I had to start again.  Counts 
> are different but Generating Output is no where near zero.
> 
> The processing is archiving data and everything looks exactly 
> right until it stops.  If I select the same records again (at 
> least the ones that did not archive on the earlier pass) it 
> processes the remaining records exactly as it should.
> 
> I could understand if it threw an error or something, but 
> everything looks perfect.
> 
> Anyone else seen behavior like this and has some idea what 
> might be going on?.
> 
> BTW: Windows Server 2003, 5.0 filepro.
> 
> Nancy
> 

Nancy, I'm assuming that since you say archiving that 
this process is deleting records (after archival)?  Not that 
that should be a problem, but I'm just curious about how 
much is involved in that one step.

Even for a simple report that didn't post or delete, my 
first instinct would be to say that something jumps 
unexpectedly to @done or a label after @done where it 
encounters an exit--maybe even conditional on data.  But
you say two runs against the same data behave differently--
so that makes me think it's something else.

Are you archiving to qualified file of the file you're 
running out of?  There's that weird thing in Windows fp 
about one qualifiers lock having potential of making 
other locks look bad.  But I would think you would get 
some kind of error msg if that was the problem.

Also, does the screen go blank for quite a bit when 
it bombs out?  I've seen where the process is actually 
finishing on windows fp, but the screen just won't 
show a good bit of the last part of the count down.

Bruce

Bruce Easton
STN, Inc.




More information about the Filepro-list mailing list