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

Rodtmclean
Rodtmclean Member Posts: 89
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

  • Rodtmclean
    Rodtmclean Member Posts: 89
    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

  • Rodtmclean
    Rodtmclean Member Posts: 89
    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.
  • julkifli33
    julkifli33 Member Posts: 1,092
    Hi any solution for this issue?
    i have the same problem