Generating Output Count

[Nancy Palmquist]

Bruce Easton wrote:
> 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.
>   
You are correct,  I am taking records out of  driver/key and putting 
them in driver/key07 or some other qualifier.
This is associated with an order and it depends on where the order was 
archived.  Most every record was archived to 07 because I selected 
records created in 07 and stuff usually happens really fast with 
orders.  I check the live order data, if it is there, nothing happens, 
the record is not archived.  I check 07, if it is there (and it was all 
but 300 times out of 21,000 records)it gets moved and ends or I check 
08, and 09 and if it is not in any file, I move it to keybad.  These are 
orders that might have been deleted or cleared out for some reason.

Simple logic really, I have done it many times.  This logic has been 
generalized and I copy it to all the support files that have this same 
connection. 

> 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.
>   
This is not possible.  There is no exit.  Only one END and it would just 
move to the next record.
There are only three lines in the @DONE
@DONE 
msgbox "Finished moving XXXXX records"
end

That is about it, so there is nothing to jump into.

> 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.
>
>   
Yes I archive to qualifiers.
> 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.
>
>   
Screen looked perfect.  It was just displaying the @done message, and 
the screen still showed that there was a large number in the Generating 
Output count.  It should have been 0.

I selected a 2 week part of the month I tried in the first crash, and it 
ran to 0 as it should.  I kind of watched it, out of the corner of my 
eye to see if it hit that done message.  Worked great.

Thanks for the comments.  I got nothing else.  And it seems I can not 
duplicate it on command.  I am not going to tweak the programming any 
more and need to run it a few more times.  The archiving is slow on this 
file and I can not have something running too long.  So I will do it by 
subsets until I get 2007 done.

Nancy
> Bruce
>
> Bruce Easton
> STN, Inc.
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>   


-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20091202/feede697/attachment-0001.html