SQL Error

cincai
cincai Member Posts: 24
edited 2008-09-14 in SQL General
Hi all,

I encounter the following error while I try to drill down to look at the session.

'SQL Error While accessing the session table. 535.22003 Microsoft ODBC sql server driver. Different of two datetime column. Cause overflow by run time.

Thank you

Comments

  • garak
    garak Member Posts: 3,263
    edited 2008-09-14
    SQL 2005 and Nav 4.00:?:
    Do you make it right, it works too!
  • cincai
    cincai Member Posts: 24
    Hi,

    My client is using SQL2000.
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • garak
    garak Member Posts: 3,263
    I belive u use 4.00. So the problem was, when i read my notes correctly, it was a problem of the 4.00 client. These bug was solved in, i think it was, 4.03. The problem is, that NAV use the SQL Function "DATEDIFF" wrong :-(
    DATEDIFF produces an error if the result is out of range for integer values

    So, the problem is that in the SQL View SESSION (it's an Navision view in your Navision database) the following code is ...
    CASE WHEN SP.[cmd] = 'AWAITING COMMAND' THEN CAST(DATEDIFF(SECOND, SP.[last_batch], GETDATE()) AS BIGINT) * 1000 ELSE 0 END AS [Idle Time]

    you can modify that sql command (...CAST(0 AS BIGINT) ELSE 0 END AS [Idle Time])

    or u use SP3. Before u use SP3, read topics about these SP here in the forum.

    Regards
    Do you make it right, it works too!

Categories