SQL Error

cincai

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

garak

SQL 2005 and Nav 4.00:?:

cincai

Hi,

My client is using SQL2000.

kriki

[Topic moved from Navision forum to SQL General forum]

garak

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