Upgrade BC14 to BC24 error

Business Central/NAV
1

Hello,

I am trying to upgrade a Business Central 14 (BC14) database to Business Central 24 (BC24).
When I run the following command in the BC Admin Shell:

Invoke-NAVApplicationDatabaseConversion -DatabaseServer $DatabaseServer -DatabaseName $DatabaseName

I always get this error:

The database create operation failed due to the following error returned by SQL Server:
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.PteIsolation_ConvertScopeAndTenantIdComboToPublishedAsField", or the name is ambiguous.

I tried:

  • Going directly from BC14 → BC24

  • Going step-by-step (BC14 → BC19 → BC23 → BC24)

  • Always using the matching Admin Shell for the target version

  • Restoring the BC14 database fresh before each attempt

But the same error appears every time.

Has anyone encountered this issue before?

Any help or guidance would be much appreciated.

Thanks!

1 Like
3

Hi,

Yes, we’ve seen this error before during older BC upgrades. It’s usually not an upgrade-path issue, but a platform dependency problem.

What’s happening is that newer BC versions expect the function
dbo.PteIsolation_ConvertScopeAndTenantIdComboToPublishedAsField, which does not exist in a BC14 database. When the conversion runs, it looks for this function and fails.

What has worked in real cases:

  • Start from a clean BC14 backup (no failed conversions reused)

  • Make sure the database is clean: no old test companies, no partial upgrades, no extensions published

  • Run the database conversion first using a supported intermediate platform (BC19 or BC20), then move forward

  • Keep all extensions out until after the database conversion is fully completed

  • Avoid reusing a database where the conversion has already failed once

We resolved this exact error last year for a customer by restoring a fresh BC14 backup and converting it first on an intermediate version before continuing. It’s a platform-level issue, not a data issue.

We’re a Microsoft partner and have been handling Business Central and NAV upgrades and migrations for more than a decade, so if you need help reviewing or executing this upgrade, we’d be happy to support you.

4

Hi @kemp1445

Have you got this issue sorted, or is there something we can help?

5

Seems some custom process is preventing this seems.

Did you force the process somewhere in between or it accidently stopped?
Try a fresh conversion, that’s the best way out attempt.