Error upgrading 2013R2 to 2018 - Alter Table Drop column failed

Djou2424
Djou2424 Member Posts: 76
in NAV Three Tier
We are in the process of upgrading one of our client from Navision 2013R2 to 2018.
During the Sync-NAVtenant step, it fails with the following error:
alter table drop column failed because one or more objects access this column

How can I track which object it is?
What can I do to be able to complete the Sync-NAVTenant step.

Answers

  • Phogue
    Phogue Member Posts: 76
    edited 2019-09-03
    Which parameters are you providing Sync-NavTenant with?
  • Djou2424
    Djou2424 Member Posts: 76
    Phogue wrote: »
    Which parameters are you providing Sync-NavTenant with?

    Just the ServerInstance
    Should I specify other parameters?
  • SanderDk
    SanderDk Member Posts: 507
    What is the result if you run it with -mode Checkonly?
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • Djou2424
    Djou2424 Member Posts: 76
    This has been resolved. Indexes had been added manually by the client directly into SQL
    Once those indexes were dropped, I was able to complete the sync process

Categories