Data type not compatible with the SQL Server data type

Votuc

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?

kine

It looks like somebody changed the field length directly on SQL. Change it on SQL to be same as in NAV again...

GoMaD

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.