Error message after restoring a database

schwenth
schwenth Member Posts: 11
edited 2007-10-25 in NAV/Navision Classic Client
Hi all,

we use NAV 4.03 together with MS SQL Server 2005. I just restored a database on the server, and the restore was finished without errors. The application was working well. After I logged off, I tried to log in again and got the following error after typing my user/password:

The session table contains a Microsoft Business Solutions-Navision data type that is not compatible with the SQL Server data type:

Field: Wait time(MS)
Type:Integer
SQL type:BIGINT

But I simply restored the database from a backup.... ](*,)

Thank you for your help....


Thilo

Comments

  • kine
    kine Member Posts: 12,562
    edited 2007-10-25
    [edited]
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DenSter
    DenSter Member Posts: 8,307
    Sometimes there's a problem where the views are not all restored. You'll need to copy it to your new database. In the original database, in Enterprise manager/Management Studio, find a view called 'Session'. Script this view as a CREATE script and copy it to the new database. You may have to repeat that for the "Session (SQL)" view.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories