Error when opening 3.70 db in 4.00

Business Central/NAV Technical Forum
1

I get this error when I’m trying to open 3.70 SQL database with a 4.00 client:

“The Session (SQL) table does not exist as the required object name of mydatabase.Session (SQL) in this database”

This happens after I say yes to convert the db to 4.00.

And when I now try to open the db again with the 3.70 client I get this error:
“The file DCMEMSTRAM contains a record that cannot be read completely”.

Does anyone know these errors?

2

Hi Erik

I have not seen the error before but I think I know what you issue is.

The Session (SQL) table is part of the Performance Troubleshooting Guide. It is a linked table linked to the Session (SQL) view on SQL server.

I guess you get your error when opening the 3.70 database with 4.0 client since the Session (SQL) view has been deleted from the SQL server. You will have to delete the Session (SQL) in Navision but you can’t do this the normal way since you can’t open the database.

  1. Make a SQL backup of you database

  2. Open the table “Object” from Enterprise Manager and delete the records related to the Session (SQL) table. There might be two record

a. Type=0 and Name= Session (SQL)

b. Type=1 and Name= Session (SQL)

  1. Try to open the database with the 4.0 client

I don’t know the second error but I assume it is caused by a partly converted database.

Regards

Claus

3

Hi Erik

I was just thinking about another way of fixing your issue. Simply restore the deleted Sessions (SQL) view from Enterprise Manager. It is safer to do this than to delete records directly from the Object table.

Regards

Claus

4

Hi Erik,

Have You ever found the reason for the “session table”-error?

I Just had the same error, after importing the Session Monitor (SQL)-objects from the Performance Troubleshooting Guide, into a 4.02 DB.

regards,

Alexander

5

[:^)]

How come I didn’t see Claus’ replies, even after pressing “View complete thread”.

I can see that Claus provides the solution.

// Alexander