Upgrade BC14 to BC19: Either the parameter @objname is ambiguous or the claimed @objtype (INDEX)

RodtmcleanRodtmclean Member Posts: 79
Hi,

I'm getting "Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong" when running Sync-NAVApp as follows: -

i9erksg312px.png

I'm upgrading a modified base app to a modified base app + extension. I've been able to track the error in the event log but as it stops and reports each table individually it is taking a long time to sort. I'm in essence removing the secondary index from the Table Migration App to fix at the moment.

Regards & Thanks
Roddy

Best Answer

  • RodtmcleanRodtmclean Member Posts: 79
    Answer ✓
    It looks like this is caused by missing indexes in the SQL table. So BC metadata have say 10 indexes but the underlying sql table has 5. Someone may have been deleting them from the SQL side.

Answers

  • RodtmcleanRodtmclean Member Posts: 79
    Answer ✓
    It looks like this is caused by missing indexes in the SQL table. So BC metadata have say 10 indexes but the underlying sql table has 5. Someone may have been deleting them from the SQL side.
Sign In or Register to comment.