Difference of two datetime columns caused overflow at runtim

alijartealijarte Member Posts: 30
edited 2005-10-13 in Navision Attain
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.
Ch.

Comments

  • DenSterDenSter Member Posts: 8,304
    That link says I don't have permissions to view the picture.
  • kinekine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • alijartealijarte Member Posts: 30
    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.
    Ch.
  • Timo_LässerTimo_Lässer Member Posts: 481
    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?)
    Timo Lässer
    Microsoft Dynamics NAV Developer since 1997
    MSDynamics.de - German Microsoft Dynamics Community - member of [clip]
  • kinekine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • IngEolRuinIngEolRuin Member Posts: 23
    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 ?
    =(there is no question that cannot be used if we use our brain)=
  • kinekine Member Posts: 12,562
    By editing the view by SQL tools... it is common view, connected into Navision... (for example by Enterprise Manager)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • IngEolRuinIngEolRuin Member Posts: 23
    Hmm, definitly quite a hack ;)

    But surely possible. Thanks.
    =(there is no question that cannot be used if we use our brain)=
Sign In or Register to comment.