Either the parameter @objname is ambiguous or ...

181deepak
181deepak Member Posts: 95
edited 2014-02-12 in NAV Three Tier
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...

Comments

  • John_N
    John_N Member Posts: 5
    Did you restart the service tier?
  • 181deepak
    181deepak Member Posts: 95
    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
    John_N Member Posts: 5
    if this is a new installation please confirm that the service tier domain account has all necessary permissions in sql
  • 181deepak
    181deepak Member Posts: 95
    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
    John_N Member Posts: 5
    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
    Yashojit_Pandhare Member Posts: 38
    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

Categories