Foxpro for Windows 2.6a - Report Form Printing Hangs Up 1

[RandyDeWitt]

Thanks in advance for any assistance!

I am experiencing random system hang ups showing a dialog box saying "Printing ????.frx." I am using report forms launched with a "report form ? to print noconsole" statement.

I have a Windows 2000 File Server providing the shared data drive. There are 20 work stations running Win2k or XP whose startup icons point to the shared drive and run the executable from the local hard drive. This application has been around for 13 years with weekly updates to the code base. I have experienced these random events prior, but they have gone away by rebuilding the executable and reloading the work station versions.

I am using the 3/7/2000 version of the Foxw2600.esl file.

I've deleted the foxuser.dbf and fpt files, erased the temporary directory and deleted all files in the winnt\system32\spool\printers directory.

I've rebuilt all 199 report forms and validated that all workstations are using the same printer driver. The problem happens predominantly on printing, but has locked up when trying to preview the report forms.

The issue is truly random, not all workstations experience the problem, and those that do have a problem, do not hang on the same report form.

I've brought down the entire network and shut off all hardware thinking I might have something funny going on inside the LAN. That did not resolve the issue.

I am out of ideas, any assistance would be greatly appreciated.

Randy DeWitt
randy.dewitt@adeccona.com

 

[DSummZZZ]

Hmmm. That's a toughie.
Have you also recreated all indexes from scratch? Not just REINDEX, but INDEX ON ...
Also, screen resolution can cause grief at times for printer drivers. Are they all set to the same resolution?
What about network throughput? Any issues with speed?


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[RandyDeWitt]

Thanks Dave for taking the time to respond to my post. I truly appreciate it.

I haven't thought about implications of a bad index on the tables. I'll recreate all indexes this evening.

I will also validate the screen resolutions on the machines having the lock up issues. Do you have any suggestions on the maximum resolution tolerated by Foxpro?

As far as speed is concerned, the reports generate consistently and in the same general time frame on machines which print and machines that hang up.

The mystery is not all machines hang up running the identical report. It is always at the dialog box when Foxpro is handing off the Print Output to the windows spooler.

 

[DSummZZZ]

You're welcome. I'm glad to help where I can.

I've found in the past that anything more than 800x600 is iffy. Nothing concrete, but that seems to be the limit.

You already said you erased the temp directory, but have you also erased any stray .tmp files that may have been created somewhere not in the temp directory?

You may also want to try a more generic printer driver if you aren't already. For example, try using something like an old LaserJet III or 4+ driver if you can. See if that makes any difference.



-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm