Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 670

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.

  • Nick Webb Profile Picture
    Nick Webb 670 on at
    RE: Upgrade from Business Central On-Premise V14.12 to V20 On-Premise

    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?

  • Jeffrey Bulanadi Profile Picture
    Jeffrey Bulanadi 644 on at
    RE: Upgrade from Business Central On-Premise V14.12 to V20 On-Premise

    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 670 on at
    RE: Upgrade from Business Central On-Premise V14.12 to V20 On-Premise

    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?

  • Nick Webb Profile Picture
    Nick Webb 670 on at
    RE: Upgrade from Business Central On-Premise V14.12 to V20 On-Premise

    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 670 on at
    RE: Upgrade from Business Central On-Premise V14.12 to V20 On-Premise

    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.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Upgrade from Business Central On-Premise V14.12 to V20 On-Premise

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans