Getting Error: accessing sessions table

twdavis

running Nav.4.0, on sql2000,
I get the following error when I go to File\database\information\Sessions tab and click on the down arrow for the number of sessions.

The following sql error occurred while accessing the Sessions table:
535,"22003",Microsoft,[ODBC SQL Server Driver][SQL Server] Difference of two datetime columns caused overflow at runtime.


Since this is a virtual table, unable to debug,
any suggestions as to what can I do to resolve?

Thanks

davmac1

Get hotfix from Microsoft.

I had this problem a year ago - was caused by non Navision applications accessing the same database. The hotfix addresses this problem and is a quick fix.

nunomaia

Check this post
http://www.mibuso.com/forum/viewtopic.php?t=6962

twdavis

thank you, modifying the sql query for the sessions view, did it.

nunomaia

I think if you upgrade client to lasted version that bug it's solved

twdavis

Thanks for the input. I modified the SQL view and problem was resolved.