Business Central tenant upgrade 2018 Cu2 to BC On Prem

MaW
MaW Member Posts: 74
in NAV Three Tier
Trying to update an tenant from multitenant solution to BC on Prem.
When following MS guide is says to:
0: Import upgrade toolkit
1: Mount Tenant
2: Sync-Navtenant
3: Start-NavDataupgrade

However when I sync tenant, i get following error:
Sync-NAVTenant : Following SQL-error was unexpected:
Invalid column name 'Schema Hash'.

It is in table 2000000071 Object Metadata in tenant database, that no such field exist.
I must miss a step, where this field is added to database, but where?

Answers

  • nikhil01993
    nikhil01993 Member Posts: 7
    Try to compile all system tables before Sync-NAVtenant with Force.
    In my case the issue was with : Table 2000000111 - Session Event
  • MaW
    MaW Member Posts: 74
    Thanks for input. Seems to go wrong the same way as before.
    Would a default tenant mounted on APP instance make a difference? I tried my initial upgrade with a default tenant mountet.
    I tried compiling all tables with sync-later option this last time with only my 2018 tenant mountet as other than default id...

Categories