Output table freezing

[Richard Kreiss]

Top Post:

Had the same issue of program running with dclerk and not rclerk.

Sometimes I could find the problem with the debugger other times not.  What I usually do in this case is put up a show statement showing the record number and a key value.  The issue is that most times the show statement is for the record before the one causing the issue.  When you know the sort sequence, you can then find the next record and check it for bad data which can cause the process to hang.


Richard Kreiss
GCC Consulting



> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Boaz
> Bezborodko via Filepro-list
> Sent: Wednesday, December 20, 2017 12:22 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: Output table freezing
> 
> 
> Date: Tue, 19 Dec 2017 17:20:06 +0000 (UTC)
> > From: Richard Tartaglia <fp_rich at yahoo.com>
> > To: FP List <Filepro-list at lists.celestial.com>
> > Subject: Output table freezing
> > Message-ID: <837793377.1240627.1513704006974 at mail.yahoo.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > Hello to everyone. Happy Hanukkah Merry Christmas I am running Fileprp
> > 5.0.14 on a Server running Windows 2013 operating system.
> > Filepro is on a mapped drive to my desktop running Windows 7.
> > I have a Filepro database that uses an alien file that is deleted and downloaded
> for each run. All of my other tables in this file run fine.
> > The table that is stopping without an error, just stalls at different points is 264
> lines long with 12500 records.
> > I thought it was looping somewhere and ran it in debug mode.? It ran fine in
> debug mode. Problem is it will take 20 hours to run the table in debug mode.
> > I am at a loss. Any thoughts would be greatly appreciated.
> > Tha
> >
> > Rich Tartaglia
> >
> > Go easy on me Mark. I am hoping I stated the problem okay.?
> >
> >
> > ?
> >
> >
> > |  | Virus-free. www.avg.com  |
> >
> > -------------- next part -------------- An HTML attachment was
> > scrubbed...
> > URL:
> > <http://mailman.celestial.com/pipermail/filepro-list/attachments/20171
> > 219/1c99189f/attachment.html>
> >
> > ------------------------------
> >
> >
> 
> Are you running the program with rclerk as opposed to dclerk?
> I've had a few rare occurrences where running a program with dclerk (what
> debug uses) instead of rclerk made the program run correctly as it would under
> debug.
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 13878 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20171221/91993dae/attachment.bin>