I have an older VB6 app which uses Crystal Reports 8.5 to create some
invoice documents. The application simply gathers data from the SQL
Server DB and creates a summary report which is then exported as a
Word document to be saved. It also creates two different detail
documents. These detail documents are also created as Crystal Reports
then exported to Excel to be saved. This process is repeated for
however many invoices need to be created. Sometimes the app will
simply hang when exporting. The only thing one can do at this point
is to terminate the app (via Task Manager). Then when the app is
restarted, it will pick-up right where it left of and complete without
issue.
This application has been running for several years without issue and
only started this behavior recently. I have, as yet, been unable to
find any thing common about the times when it hangs. It may hang when
exporting the Word doc this time and next time it might be when
exporting the Excel spreadsheet. It may go several days without
hanging or it may do it several time in a single run.
At this point I do not even know what to do to trace this down. I
have put trace statements (simply writing debug statements to a log
file) throughout the process. This is in fact how I have been able to
determine that it is the export that causes the problem. However as I
say that (the fact that it happens on the call to Crystal's Export function)
is the only commonality between the occurrances.
Anybody got any ideas?
Thanks,
Steve
Edited by sredmyer - 30 Apr 2010 at 1:28am