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