Sometimes VB 6.0 developed exe Hangs on Exit Sub

Hi All,
I have an application written in VB 6.0. the application does not contain any forms. The application fetches a request (XML) from a table , process it and generates an output xml and stores it back in table and exits. But sometimes after storing it in table it hangs. We analyzed by putting debug messages into log files and we found that it hangs in the last exit sub statement. We tried to replace it with End , but still hangs while executing it.

It does not always hang , some times ... may be after 4-5 requests.

Please give me some inputs to solve it

Welcome to the forums. :wave:

Have you discovered any consistencies? If you try, can you replicate the problem?

Try adding DoEvents before the Exit Sub line.

Hey Hack ,
Thanks for your reply. In some servers we are not able to replicate. But in some servers the application hangs and we have to kill it manually. We tried doing all sorts of termination etc etc... but it hangs during the execution of last line. I'll try that and let you know.

Hell Loard ,
I'll try that ... Have u ever faced this situation before ..

Yes, and it is a bugger to track down. There is no one specific thing. It generally comes down to trial and error.

The thing is that I wouldn't be looking at the application itself. If there were something wrong with the code it would happen ALL the time.