Difference of two datetime columns caused overflow at runtim

alijarte

Lads,

I got this error whenever a user tries to connect to Navision.
A huge window pops-up with an SQL server error as follows:

"Difference of two datetime columns caused overflow at runtime"
"The statement has been terminated"

Followed by a massive error message which you can see at:

http://www.keg.com/HyperNewsPics/granerror.jpg

Anyone?any idea?

Thanks,
Ch.

DenSter

That link says I don't have permissions to view the picture.

kine

It is problem of some long time idle session on MS SQL server... the session view is calculating the IdleTime in ms and tthe result is bigger than used datatype. Look on MS SQL Enterprise manager into sessions and kill the long time idle session.... or modify the Session view in Navision DB to cut the no to biggest bigint no...

alijarte

Excuse my ignorance, but how could I be sure that a process is idle? To calculate idle time, shall I compare "login time" and "last batch" within the current activity --> process info?
Or simply the "last batch" shows the last time the user executed something?

Any other way?

Thanks,
Ch.

Timo_Lässer

DenSter wrote:

That link says I don't have permissions to view the picture.

I got the same error by entering the page. You have to reload the page, then it will show the image.
(I think they check the referer?)

kine

alijarte wrote:

To calculate idle time, shall I compare "login time" and "last batch" within the current activity --> process info?
Or simply the "last batch" shows the last time the user executed something?

Yes, last batch is when was last query executed...

IngEolRuin

kine wrote:

or modify the Session view in Navision DB to cut the no to biggest bigint no...

Yes, but the Session View (and the session table) is a system object which cannot be altered by using the normal object designer ?

How to accomplish this ?

kine

By editing the view by SQL tools... it is common view, connected into Navision... (for example by Enterprise Manager)

IngEolRuin

Hmm, definitly quite a hack

But surely possible. Thanks.