Getting Session Error

palan

Hi,

I am getting session error when i try to login using navision 3.1 to sql 2000 database and the error message is as below:

The following SQL Server error(s) occurred while accessing the Session table:

8152,"22001",[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
3621,"01000",[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.


Can some one help me with this issue. Thanks.

colin_leversuch-roberts

from a sql point of view this means you are trying to put data that is too big into a column. e.g. putting a string of 20 chars into a char(10) column. The error is a bit generic however and can also refer to date time data.
how this relates to the navision error I couldn't say but this is what sql server is complaining about. You could try using profiler to capture the sql being sent.