Either the parameter @objname is ambiguous or ...

181deepak

Hi Experts

When I am try to run Nav 2013 R2 or when I try to compile
I got the following error...

---

Microsoft Dynamics NAV Development Environment

---

The following SQL error was unexpected.

Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.

.

---

OK

---

Please Help me...

John_N

Did you restart the service tier?

181deepak

thanks for your reply

yes I already restart services,

I am not able to compile table 36 and when I modify something in any other table then also I get same error....

I also take backup of same data base and restore it to new database but same error exist...

John_N

if this is a new installation please confirm that the service tier domain account has all necessary permissions in sql

181deepak

no this is not a new installation, this is a running project..
and when I try to deploy some new objects then I get this error...

John_N

stab in the dark here ](*,)

can you compare table 36 in nav and the same table in sql i.e. are the table structures the same?

When I last came across sql errors, permissions, generating the metadata and restarting the service tier seemed to do the trick. So..

ensure Prevent data loss from table changes is checked

ensure Service tier account has sql permission (make it dbowner if its dev environment)

Build Server Application Objects

compile all objects

Yashojit_Pandhare

The object metadata in Sql sever could be different from that of your object.
One way could be, delete the record from Object Metada table in Sql server corresponding to the Object Type and Object ID for which you are encountering the problem.

Then compile the object again and run the NAV application.

[-o<

Regards,
Yashojit A. Pandhare