Error when Opening RTC NAV 2013 R2

shrekut

I have upgraded a client from NAV 5.01 (running 2009 R2 Executables) to NAV 2013 R2. I ran into several errors along the way, but was able to work through them all except this one (see below).

---

Microsoft Dynamics NAV

---

The following SQL error was unexpected.

Invalid object name 'MLC-NAV71-Live.dbo.1560 N_ Orange Ltd (new)$Marketing Setup'.

Statement(s) could not be prepared.

---

OK


Any help would be appreciated.

kylehardin

If you can connect with the dev client, try compiling the table called Marketing Setup.

mohana_cse06

If I remember correct then some builds were having issues with company name having ().
can you try removing them?

shrekut

Thank you very much I will experiment with that some. I hope it's not "()" in the company name. There are 157 companies in this database and most of them have that.

RockWithNAV

Hey Shrekut,

I believe your assumption may be correct as its a SQL error and some special characters might be the cause.