web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Upgrade from Business ...
Small and medium business | Business Central, N...
Suggested Answer

Upgrade from Business Central On-Premise V14.12 to V20 On-Premise

(0) ShareShare
ReportReport
Posted on by Nick Webb 891

I'm following the procedure on the web page below:-

Upgrading Customized C/AL Application to Microsoft Base Application for version 20 - Business Central | Microsoft Docs

I've got to the section titled: Task 5: Create table migration extension - Create the first version - tables only.

I've reached the last step of the section (11) 'Build the extension package for the first version.' and it fails to build and reports 18,032 errors & 24 warnings. See the first 5 errors below:-

c:\Utils\VSCode\AL\TableMigration01\LoggedSegment.Table.al(22,34): error AL0275: 'Interaction Log Entry' is an ambiguous reference between 'Interaction Log Entry' defined by the extension 'TableMigration01 by Oakley Global Business Solutions Ltd (1.0.0.0)' and 'Interaction Log Entry' defined by the extension 'Base Application by Microsoft (20.0.37253.38230)'.
c:\Utils\VSCode\AL\TableMigration01\LoggedSegment.Table.al(30,34): error AL0275: 'Campaign Entry' is an ambiguous reference between 'Campaign Entry' defined by the extension 'TableMigration01 by Oakley Global Business Solutions Ltd (1.0.0.0)' and 'Campaign Entry' defined by the extension 'Base Application by Microsoft (20.0.37253.38230)'.
c:\Utils\VSCode\AL\TableMigration01\DimensionBuffer.Table.al(24,29): error AL0275: 'Dimension' is an ambiguous reference between 'Dimension' defined by the extension 'TableMigration01 by Oakley Global Business Solutions Ltd (1.0.0.0)' and 'Dimension' defined by the extension 'Base Application by Microsoft (20.0.37253.38230)'.
c:\Utils\VSCode\AL\TableMigration01\DimensionBuffer.Table.al(24,29): error AL0185: Table 'Dimension' is missing
c:\Utils\VSCode\AL\TableMigration01\AccountingPeriod.Table.al(32,44): error AL0275: 'Item' is an ambiguous reference between 'Item' defined by the extension 'TableMigration01 by Oakley Global Business Solutions Ltd (1.0.0.0)' and 'Item' defined by the extension 'Base Application by Microsoft (20.0.37253.38230)'.

Clearly I've gone badly wrong. Does anyone have any idea where?

anydesk00232.png

Any help would be greatly appreciated.

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,708 Moderator on at

    Hi,

    Try to open your Business central version and manually go to Extension management, and try to install the Extension, Base Application and System Application.

    See if you can do the above steps.

    Thanks.

  • Nick Webb Profile Picture
    Nick Webb 891 on at

    Should I be able to run V20 yet? I was under the impression I wouldn't be able to do that until the upgrade was complete. The service does start OK and VSCode has download symbols from it, but if I try and run BC V20 it reports 'An error has occurred'.

    In the event viewer it reports:  There is a communication protocol mismatch between the client and the server.

  • Nick Webb Profile Picture
    Nick Webb 891 on at

    I uninstalled BC V20 and re-installed and now it opens successfully and the Base and System Application Extensions are installed. However, this has made no difference to my VSCode project. Still the same number of errors and warnings.

  • Nick Webb Profile Picture
    Nick Webb 891 on at

    When you summarise the steps in 'Task 5: Create table migration extension - Create the first version - tables only', it doesn't make sense. It does the following:-

    (a) Export V14 schema info to a text file.

    (b) Convert the text-file to V14 specific AL files.

    (c) Create a VSCode project that is targeted to V20 (runtime 9)

    (d) Copy the V14 specific AL files into the VSCode project.

    (e) Download the V20 symbols and attempt to compile.

    For me, it's no surprise that there are thousands of syntax errors. Where's the conversion of V14 AL Code to V20 AL Code?

  • Jeffrey Bulanadi Profile Picture
    Jeffrey Bulanadi 8,760 on at

    Hi Nick Webb ,


    As i can see you even created the tables for the standard ones. 

    If the table is affected due to custom field then you need to create a table extension instead, also make sure you only a custom extension for those modified tables only using the txt2al executable.

    Let me know how you go. Happy to assist you.

    Cheers

  • Nick Webb Profile Picture
    Nick Webb 891 on at

    The procedure says to run these commands:- 

    Export-NAVApplicationObject -DatabaseServer BCTESTUPGRADE\BCDEMO -DatabaseName "BC14A" -ExportToNewSyntax -Path "C:\Utils\export2al\bc14tablesonly\exportedbc14-tables.txt" -Filter 'Type=Table;Id=1..1999999999'

    and then:-


    "C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\140\RoleTailored Client\txt2al.exe" --source=C:\Utils\export2al\bc14tablesonly --target=C:\Utils\export2al\bc14tablesonly\al --tableDataOnly

    ... and that's what I've done.

    Note, the filter argument says: -Filter 'Type=Table;Id=1..1999999999' . That's all tables isn't it?
    Also note, as per the procedure, all extensions have been uninstalled.

    Should I not be processing all tables?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,606

#2
YUN ZHU Profile Picture

YUN ZHU 931 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans