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

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: -

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
I'm getting "Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong" when running Sync-NAVApp as follows: -

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
0
Best 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.0
Answers
-
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.0
-
Hi any solution for this issue?
i have the same problem0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions