Error in checking number of sessions

write2sourav

Hi,
I was trying to check the number of active sessions in the Database Information window. When in the Sessions tab, i clicked the Drill down besides the number of sessions label, an SQL Server error occured showing 535,"22003"[Microsoft][ODBC SQL Server Driver][SQL Server]Difference of two datetime columns caused overflow at runtime. How do i rectify the issue. Plz Help.

vjac

Check out this post, there are a couple of ways to correct the problem:
http://www.mibuso.com/forum/viewtopic.p ... me+columns

And remember, use the search

Cheers,
v.

andy76

Hello,

I don't have errors but the system block itself (hourglass).

Making :
select * from Session in Sql analyzer I don't have error and have the entire list

Why?

David_Singleton

andy76 wrote:

Hello,

I don't have errors but the system block itself (hourglass).

Making :
select * from Session in Sql analyzer I don't have error and have the entire list

Why?

This is a known bug in 5.00. Check out Waldo's blog for the fix you need:

Platform updates overview - 3.70.B - NAV2009 CTP3 (Update 2)

Assuming you are on 5.00.

ara3n

another solution is to change the select to select distinct

andy76

Where is it possible to change the select?
In Navision?

ara3n

in sql.

Go to the database in SQL Management Studio.

Click on the views and you'll see a session view.

Right click scrip it to modify in a new windows and change the select to select distinct.