V5.0 Session problem under SQL2005 64 bit

Business Central/NAV Technical Forum
1

I’ve a customer technically migrated from NAV 3,70 (SQL2000) to V5.0 (SQL2005 SP2 (64 bit)).

I’ve first created the new database V5 inside SQL2005 , and then I’ve restored the 3.70 NAV backup.

From a NAV 5.0 client I can open DataBase–>Information → Session–> Current Session , and with the drill down button I can see the active session in SQL2005.

But as soon as I try to move in the database session window , it hangs and I only can close the NAV client.

In Management Studio (with SP_who2) I see the session (NAV client) in the SUSPENDED state , NOT growing cpu time or diskIO.

I can normally open the dbo.Session View inside the database.

I suppose a 64 bit problem , but is there anyone helping me to solve?

Thank you in advance.

2

There is a bug if you select last session. Check in partnersource https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYLSVQUSPTNTNSMQPYKLPKZRXKUPYZULLLWORXTTMVQTWYRUWN

3

Thanks a lot!!! For everyone interested: Now, there is a hotfix to solve the problem.

4

This is great, I guess every 5.00 client needs this.

Can you post a link to the hot fix.

5

binary upgrade… Must be asked to MS…[:(]