Need Help urgent

Krithika_92

Hi all,

I am trying to upgrade a db from NAV 2009 R2 to NAV 2013 R2. i had merged complied and all set to use the upgraded DB. But when i try to open my RTC client i get an error that "The following SQL error was unexpected.
Invalid column name 'Credit'." I want help to solve this error. Awaiting reply eagerly....

postsaurav

Hi Krithika,

Run Sync Tenant as discussed below.

** Before Running Sync Tenant, change the SqlCommandTimeout From 00:30:00 to 10:00:00 in General Tab Tier of Service Instance.
** Restart the service after changes.

http://saurav-nav.blogspot.in/2014/05/nav-2013-r2-how-to-sync-tenant.html

** Sync Tenant will take time to complete.
** Hope you are using NAV 2013 R2 exe Build with CU 6 or higher.

Let me know if any issues.

Krithika_92

Hi Saurav,
Thanks for your reply i will try the above and get back to you.

Regards
Krithika.N

Krithika_92

Hi Saurav
It worked thank you loads for your help

Regards
Krithika.N

postsaurav

Hi Krithika,
Great to hear that, Please mark question as closed.