MapForums

I have an application (VB) that uses map point to verify address based on GPS information (gets lat and long and verifies address ...) but map point crashes on the server when the traffic is high (two requests per second) and I get the 11014 error message. In this case I see map point gets a lot of memory in the server (from process list in task manager) and I have to restart map point and my application. I appreciate any ideas.

Hi ...

I haven't seen that error # before.
Does it simply happen at random times?
Are you already using On Error Resume Next?
(VB6 or that new ???)

Mike Mattys

The application crashes randomly but when I increased the number of requests, it started to crash more often like as I have about 2 request per second, map point crashes every 3-4 hours. I see that error message in event viewer in Windows.

Hmm ...
If saving to any Microsoft file (mdb), I'd recommend
stop and compact/repair at regular intevals.

No other guesses, sorry.

Mike Mattys

I'm not sure the error code off hand (did you try looking it up?)
But I've seen something with Excel.

The problem was that my code was feeding data to Excel quicker than it could handle it (eg. because the user is using scroll bar, or my code was particularly quick). This produced an error code that meant "busy" or something like that. Later versions of Excel are more susceptible.

The solution is like Mike says: use an ON ERROR block.
I trapped all errors, checked the error code for the "busy" code. If it was something else, then throw an exception ("Excel died" or something similar).
If it is the busy code then sleep for 100ms or so and try again.
If you're seeing your error twice a second, then I'd wait for 0.6 seconds.

Richard

__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009

Thanks for the tip, I use SQL DB but it is not getting updated just some info is there and I use them.

Thanks,