Data type not compatible with the SQL Server data type

Votuc
Votuc Member Posts: 206
edited 2011-05-17 in NAV Three Tier
When I try to open the RTC, I get the following error:


The Purchase Header table contains a Microsoft Dynamics NAV Classic field data type that is not compatible with the SQL Server data type: Field: Name Type: Text50 SQL type: VARCHAR(60)

Page VEC Sales "Activities" must close.


I did a search and I did find some people with this error - but they were running NAV 3.70 and just told to upgrade to NAV 4. This is NAV 2009 SP1. Is there a way I can get around this?

Comments

  • kine
    kine Member Posts: 12,562
    It looks like somebody changed the field length directly on SQL. Change it on SQL to be same as in NAV again...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • GoMaD
    GoMaD Member Posts: 313
    1. Close all the client connections (RTC and Classic) to your database, except your own classic client.
    2. Shut down all the services (NAV middle tier and NAV web-service).
    3. Search for the record in the table 2000000071 "Object Metadata" that is linked to the object that throws the error and delete it.
    4. Open your Object Designer and search for the object that's causing the error, open it in design mode and save & compile it.
    5. Start all your services again
    6. Try to reconnect.

    This helped for me.

    It seems that a connection keeps the old table structure alive in the cache and refuses to release it.
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!

Categories