SQL Error

klum

klum Member Posts: 102

2007-03-29 edited 2007-03-31 in NAV/Navision Classic Client

I got an error about SQL,
It show me this error :

The Following SQL Server error(s) occurred while accessing the session table: 535,"22003",[Microsoft][ODBC SQL Server Driver][SQL Server] Difference for two datetime colunm caused overflow at runtime.

i got this error when i want to check current session by click Drill down;
I use "SQL Server 2000" on "Window Server2003" Navision V.4.0

How can I Fix this error?

Thanks in Advance

0

Comments

Marije_Brummel Member, Moderators Design Patterns Posts: 4,262

2007-03-29

There are several posts about this error. Please use the searchfunction

Marije Brummel | Freelance Business Central Specialist
0
thayoot Member Posts: 2

2007-03-30

I can not find the result for this error.
Please give me the link that can fix this error .

Thank You very much...

0
ara3n Member Posts: 9,258

2007-03-30

http://www.mibuso.com/forum/viewtopic.php?t=12606&highlight=session+difference+two+datetime

http://www.mibuso.com/forum/viewtopic.php?t=6962&highlight=session+difference+two+datetime

Ahmed Rashed Amini
Independent Consultant/Developer

blog: https://dynamicsuser.net/nav/b/ara3n
0
davmac1 Member Posts: 1,283

2007-03-30

Depending on your SP level this might be a table and not a view. If it is a table, you need to get a patch from Microsoft.

David Machanick
http://mibuso.com/blogs/davidmachanick/
0
ara3n Member Posts: 9,258

2007-03-30

the session is a view in all navision version.

Ahmed Rashed Amini
Independent Consultant/Developer

blog: https://dynamicsuser.net/nav/b/ara3n
0
thayoot Member Posts: 2

2007-03-31

Thank you very much,Every Body

0

Categories