Thursday, July 28, 2011

RTC Connection to SQL Server

Have you ever had problems with NAV upgrade and RTC connection?

Today we've just finished wih upgrade from NAV 4.0 SP4 to NAV 2006 R2 and had wierdes problem. After upgrade, testing classic client functionalities and RTC functionalities we decided that it's time to upload ugraded database to client server.

After setting up server, installing new clients and testing of classic functionalities we moved on to RTC testing. Of course we thought that we aren't going to experience any problems because of previous hard RTC tesing. And we were wrong.

We got our first error and eaven didn't start RTC on client side. Even we installed Demo database (Cronus International Ltd.) and showed it to he users and modified connection string to our database we  got this error:



And then we started mining for solution. This is what we tried:
  • deleting user personalization table (2000000071),
  • restarted NAV services,
  • restarted Windows server,
  • deleted and updated object medatada table (2000000071) from Cronus databas for common objects.

Last thing that we tried (and that did the trick) was deleting Object metadata table and compiling all objects from Object designer.

No comments:

Post a Comment