Getting Session Error

palanpalan Member Posts: 26
edited 2007-06-22 in SQL General

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.


  • 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.
Sign In or Register to comment.