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
2

Hi Kemp,

I saw your query about the error you’re getting during the BC14 → BC24 upgrade. This usually happens when there’s something missing or different in the database. A few things you could try:

  • Check updates: Make sure your BC14 database has the latest updates before upgrading.

  • Look for missing functions: The error mentions a function that might be missing. You can check if it exists in your database.

  • Consider step-by-step upgrade: Sometimes upgrading through intermediate versions (like BC14 → BC19 → BC23 → BC24) helps avoid issues.

  • Review customizations: If you have customizations, especially in the Company table, make sure the required fields (like GUIDs) are correctly set.

We’ve seen similar situations with one of our customers, and following these steps helped them, though your setup may behave differently. If this doesn’t work, it might be good to get help from Microsoft support or a Dynamics 365 partner.

Hope this helps!