Database Sessions List in Nav 5.0 hangs

Poltergeist

On NAV 5.0, connected to a Windows 2003 SP2 server with SQL Server 2005 with SP2 and the latest updates, if I go to database->information, and drill down the sessions, the screen appears allright. However, I see a lot of connection ID-s double or even three times in this list.

if I want to scroll down, Nav 5.0 hangs completely. Also, the processor is going crazy, eating all the power of the processor - or the core, in most cases. The only way to quit Navision, is to shut it down via taskmanager.

If I connect to the same server using NAV4.0 SP3, it's all working like a charm.

I have this problem on several (I even think, all)- just installed - servers. Any clue what I can do about it, or what I am doing wrong?

ara3n

there is another thread that mentions the same thing. It's a bug, you should report it to MS.

ara3n

here is the link.

http://www.mibuso.com/forum/viewtopic.php?t=17187&highlight=session+hang

Scott_Frappier

Poltergeist:

I posted a workaround at the link that ara3n mentioned...please examine and give us your feedback if it does not work.

Thanks!

- Scott