Run-ALCops : The target table of table extension 'XXX Source Code Setup' has changed from 'MissingTypeSymbol' without breaking change

[iti-mikolaj-sledz]

PLEASE DO NOT INCLUDE ANY PASSWORDS OR TOKENS IN YOUR ISSUE!!!

Describe the issue
We have a problem when running Run-ALCops for our app, but with a table extension that hasn’t been changed for several releases. The issue only occurs on version 23; it does not occur on higher versions of Business Central.

##[error]./C:/ProgramData/BcContainerHelper/e739898c-0903-4e6c-a952-9c7241ecd6db/src/src/tableextension/XXXSourceCodeSetup.TableExt.al(1,25): error AS0068: The target table of table extension 'XXX Source Code Setup' has changed from 'MissingTypeSymbol' to 'Source Code Setup'. Changing the target of a table extension that has been published is not allowed, because this might break the upgrade of existing installations.

Scripts used to create container and cause the issue
$user = 'admin'
$password = ConvertTo-SecureString -AsPlainText -Force -String 'admin'
$credential = New-Object pscredential $user, $password

New-NavContainer -accept_eula
-accept_outdated -accept_insiderEula
-containerName 'bc' -artifactUrl (Get-BCArtifactUrl -type Sandbox -country w1 -select Latest -version 23.0)
-licenseFile ('dev-license.bclicense') -auth UserPassword
-Credential $credential -isolation process
-multitenant:$false -doNotExportObjectsToText
-updateHosts -vsixFile (Get-LatestAlLanguageExtensionUrl)
-enableTaskScheduler

Full output of scripts
2025-01-16T13:39:23.4527992Z ##[command]Importing BcContainerHelper module
2025-01-16T13:39:23.5553505Z BcContainerHelper version 6.0.30
2025-01-16T13:39:23.8246792Z BC.HelperFunctions emits usage statistics telemetry to Microsoft
2025-01-16T13:39:23.8579388Z Running on Windows, PowerShell 7.2.24
2025-01-16T13:39:24.5094395Z �[33;1mWARNING: The names of some imported commands from the module 'BcContainerHelper' include unapproved verbs that might make them less discoverable. To find the commands with unapproved verbs, run the Import-Module command again with the Verbose parameter. For a list of approved verbs, type Get-Verb.�[0m
2025-01-16T13:39:24.5121279Z ##[command]Setting UsePsSession to false
2025-01-16T13:39:24.5138990Z ##[command]UsePsSession: False
2025-01-16T13:39:24.5243747Z C:\PipelineWorkspace\PreviousRelease\1.7.1.1\Applications\MYAPP_1.7.1.1.app
2025-01-16T13:39:24.5246665Z C:\Source\Apps\Application\Artifacts\Applications\MYAPP_1.7.1.3.app
2025-01-16T13:39:24.5255115Z ##[command]Specified SupportedCountries: pl
2025-01-16T13:39:25.0960070Z Copying previous apps to packages folder
2025-01-16T13:39:25.3592738Z Extracting C:\ProgramData\BcContainerHelper\f5f5d87e-0f2b-4714-b6a3-b112db4372ab\MYAPP_1.7.1.1.app
2025-01-16T13:39:25.5904082Z XXX_MYAPP = 1.7.1.1
2025-01-16T13:39:26.2802197Z Downloading AL Language Extension (Prerelease) to C:\ProgramData\BcContainerHelper\alLanguageExtension\15.0.1275389.zip
2025-01-16T13:39:27.3347558Z using 7zip
2025-01-16T13:39:33.7464062Z Latest Supported Runtime Version: 12.2
2025-01-16T13:39:33.7523657Z Extracting C:\ProgramData\BcContainerHelper\26bffec1-c8cd-44b2-bfa3-d258ebebc81e\MYAPP_1.7.1.3.app
2025-01-16T13:39:33.8270575Z App Runtime Version is '12.0'
2025-01-16T13:39:33.8893661Z Analyzing: MYAPP_1.7.1.3.app
2025-01-16T13:39:33.8919738Z Using affixes: XXX
2025-01-16T13:39:33.8937248Z Using supportedCountries: pl
2025-01-16T13:39:33.8954236Z Using previous app: XXX_MYAPP_1.7.1.1.app
2025-01-16T13:39:33.9512952Z AppSourceCop.json content:
2025-01-16T13:39:33.9966060Z {
2025-01-16T13:39:33.9968816Z "supportedCountries": [
2025-01-16T13:39:33.9969745Z "pl"
2025-01-16T13:39:33.9971986Z ],
2025-01-16T13:39:33.9972671Z "Publisher": "XXX",
2025-01-16T13:39:33.9973304Z "Name": "MYAPP",
2025-01-16T13:39:33.9973921Z "mandatoryAffixes": [
2025-01-16T13:39:33.9977131Z "XXX"
2025-01-16T13:39:33.9978090Z ],
2025-01-16T13:39:33.9979460Z "Version": "1.7.1.1"
2025-01-16T13:39:33.9980089Z }
2025-01-16T13:39:33.9985106Z Ruleset.json content:
2025-01-16T13:39:34.0036955Z {
2025-01-16T13:39:34.0037529Z "name": "Run-AlCops RuleSet",
2025-01-16T13:39:34.0037974Z "description": "Generated by Run-AlCops",
2025-01-16T13:39:34.0038396Z "includedRuleSets": [
2025-01-16T13:39:34.0038768Z {
2025-01-16T13:39:34.0039137Z "action": "Default",
2025-01-16T13:39:34.0039633Z "path": "C:\ProgramData\BcContainerHelper\6a0b0534-6f5f-472c-bc5c-00937d1f0622\appsource.default.ruleset.json"
2025-01-16T13:39:34.0040090Z }
2025-01-16T13:39:34.0040429Z ]
2025-01-16T13:39:34.0040772Z }
2025-01-16T13:39:34.8723968Z Using Symbols Folder: C:\ProgramData\BcContainerHelper\f5f5d87e-0f2b-4714-b6a3-b112db4372ab
2025-01-16T13:39:35.4967301Z Copying System.app from Container
2025-01-16T13:39:35.5495194Z Copying Microsoft_Any_23.0.12034.23046.app from Container
2025-01-16T13:39:35.5532788Z Copying Microsoft_API - Cross Environment Intercompany_23.0.12034.23046.app from Container
2025-01-16T13:39:35.5563319Z Copying Microsoft_API Reports - Finance_23.0.12034.23046.app from Container
2025-01-16T13:39:35.5577341Z Copying Microsoft_Application_23.0.12034.23046.app from Container
2025-01-16T13:39:35.5598648Z Copying Microsoft_Audit File Export_23.0.12034.23046.app from Container
2025-01-16T13:39:35.5621244Z Copying Microsoft_Base Application_23.0.12034.23046.app from Container
2025-01-16T13:39:35.7023540Z Copying Microsoft_Business Central Cloud Migration - Previous Release_23.0.12034.23046.app from Container
2025-01-16T13:39:35.7042299Z Copying Microsoft_Business Central Cloud Migration API_23.0.12034.23046.app from Container
2025-01-16T13:39:35.7065106Z Copying Microsoft_Business Central Intelligent Cloud_23.0.12034.23046.app from Container
2025-01-16T13:39:35.7087268Z Copying Microsoft_Company Hub_23.0.12034.23046.app from Container
2025-01-16T13:39:35.7109725Z Copying Microsoft_Contoso Coffee Demo Dataset_23.0.12034.23046.app from Container
2025-01-16T13:39:35.7136890Z Copying Microsoft_Czech language (Czechia)_23.0.12034.23046.app from Container
2025-01-16T13:39:35.7499161Z Copying Microsoft_Danish language (Denmark)_23.0.12034.23046.app from Container
2025-01-16T13:39:35.7544854Z Copying Microsoft_Data Archive_23.0.12034.23046.app from Container
2025-01-16T13:39:35.7577723Z Copying Microsoft_Data Search_23.0.12034.23046.app from Container
2025-01-16T13:39:35.7961319Z Copying Microsoft_Dutch language (Belgium)_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8021407Z Copying Microsoft_Dutch language (Netherlands)_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8451603Z Copying Microsoft_E-Document Core_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8475039Z Copying Microsoft_Email - Current User Connector_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8497023Z Copying Microsoft_Email - Microsoft 365 Connector_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8515758Z Copying Microsoft_Email - Outlook REST API_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8537848Z Copying Microsoft_Email - SMTP API_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8558755Z Copying Microsoft_Email - SMTP Connector_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8582016Z Copying Microsoft_English language (Australia)_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8628388Z Copying Microsoft_English language (Canada)_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8935049Z Copying Microsoft_English language (New Zealand)_23.0.12034.23046.app from Container
2025-01-16T13:39:35.8976393Z Copying Microsoft_English language (United Kingdom)_23.0.12034.23046.app from Container
2025-01-16T13:39:35.9416459Z Copying Microsoft_English language (United States)_23.0.12034.23046.app from Container
2025-01-16T13:39:35.9473903Z Copying Microsoft_Error Messages with Recommendations_23.0.12034.23046.app from Container
2025-01-16T13:39:35.9504176Z Copying Microsoft_Essential Business Headlines_23.0.12034.23046.app from Container
2025-01-16T13:39:35.9643776Z Copying Microsoft_EU 3-Party Trade Purchase_23.0.12034.23046.app from Container
2025-01-16T13:39:35.9668595Z Copying Microsoft_Finnish language (Finland)_23.0.12034.23046.app from Container
2025-01-16T13:39:35.9905410Z Copying Microsoft_French language (Belgium)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.0527052Z Copying Microsoft_French language (Canada)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.0594115Z Copying Microsoft_French language (France)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.1026761Z Copying Microsoft_French language (Switzerland)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.1083871Z Copying Microsoft_German language (Austria)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.1522904Z Copying Microsoft_German language (Germany)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.1991079Z Copying Microsoft_German language (Switzerland)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.2050344Z Copying Microsoft_Icelandic language (Iceland)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.2543638Z Copying Microsoft_Intelligent Cloud Base_23.0.12034.23046.app from Container
2025-01-16T13:39:36.2554818Z Copying Microsoft_Intrastat Core_23.0.12034.23046.app from Container
2025-01-16T13:39:36.2586367Z Copying Microsoft_Italian language (Italy)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.2899601Z Copying Microsoft_Italian language (Switzerland)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3426348Z Copying Microsoft_Late Payment Prediction_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3448371Z Copying Microsoft_Library Assert_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3470914Z Copying Microsoft_Library Variable Storage_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3489367Z Copying Microsoft_Microsoft Pay Payments_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3510300Z Copying Microsoft_Norwegian language (Norway)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3566507Z Copying Microsoft_Payment Links to PayPal_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3905991Z Copying Microsoft_Payment Practices_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3928741Z Copying Microsoft_Performance Toolkit_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3950658Z Copying Microsoft_Permissions Mock_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3968394Z Copying Microsoft_Recommended Apps_23.0.12034.23046.app from Container
2025-01-16T13:39:36.3991459Z Copying Microsoft_Russian language (Russia)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.4394574Z Copying Microsoft_SAF-T_23.0.12034.23046.app from Container
2025-01-16T13:39:36.4414620Z Copying Microsoft_Sales and Inventory Forecast_23.0.12034.23046.app from Container
2025-01-16T13:39:36.4437992Z Copying Microsoft_Send remittance advice by email_23.0.12034.23046.app from Container
2025-01-16T13:39:36.4457756Z Copying Microsoft_Send To Email Printer_23.0.12034.23046.app from Container
2025-01-16T13:39:36.4479334Z Copying Microsoft_Service Declaration_23.0.12034.23046.app from Container
2025-01-16T13:39:36.4504261Z Copying Microsoft_Shopify Connector_23.0.12034.23046.app from Container
2025-01-16T13:39:36.4543447Z Copying Microsoft_Simplified Bank Statement Import_23.0.12034.23046.app from Container
2025-01-16T13:39:36.4564717Z Copying Microsoft_Spanish language (Mexico)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.5042398Z Copying Microsoft_Spanish language (Spain)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.5508950Z Copying Microsoft_Statistical Accounts_23.0.12034.23046.app from Container
2025-01-16T13:39:36.5530074Z Copying Microsoft_Swedish language (Sweden)_23.0.12034.23046.app from Container
2025-01-16T13:39:36.5592088Z Copying Microsoft_System Application_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6005258Z Copying Microsoft_Test Runner_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6023477Z Copying Microsoft_Troubleshoot FA Ledger Entries_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6244780Z Copying Microsoft_Universal Print Integration_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6264604Z Copying Microsoft_VAT Group Management_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6287978Z Copying Microsoft__Exclude_APIV1__23.0.12034.23046.app from Container
2025-01-16T13:39:36.6308319Z Copying Microsoft__Exclude_APIV2__23.0.12034.23046.app from Container
2025-01-16T13:39:36.6471561Z Copying Microsoft__Exclude_Bank Deposits_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6497334Z Copying Microsoft__Exclude_Business_Events__23.0.12034.23046.app from Container
2025-01-16T13:39:36.6517997Z Copying Microsoft__Exclude_ClientAddIns__23.0.12034.23046.app from Container
2025-01-16T13:39:36.6535585Z Copying Microsoft__Exclude_Connectivity Apps_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6561315Z Copying Microsoft__Exclude_Email Logging Using Graph API_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6582372Z Copying Microsoft__Exclude_Master_Data_Management_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6606817Z Copying Microsoft__Exclude_Microsoft Dynamics 365 - SmartList_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6628483Z Copying Microsoft__Exclude_Onboarding Signals_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6649078Z Copying Microsoft__Exclude_PlanConfiguration__23.0.12034.23046.app from Container
2025-01-16T13:39:36.6668030Z Copying Microsoft__Exclude_ReportLayouts_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6689901Z Copying Microsoft__Exclude_Review_General_Ledger_Entries_23.0.12034.23046.app from Container
2025-01-16T13:39:36.6711918Z Copying Microsoft__Exclude_SyncBaseApp__23.0.12034.23046.app from Container
2025-01-16T13:39:58.5445296Z Processing dependency Microsoft_Application_23.0.0.0 ()
2025-01-16T13:39:58.5581463Z Dependency App exists
2025-01-16T13:39:58.5610060Z Adding dependency to System Application from Microsoft
2025-01-16T13:39:58.5621654Z Adding dependency to Base Application from Microsoft
2025-01-16T13:39:58.5629755Z Processing dependency Microsoft_System_23.0.0.0 ()
2025-01-16T13:39:58.5647422Z Dependency App exists
2025-01-16T13:39:58.5660887Z Processing dependency Microsoft_System Application_23.0.0.0 (63ca2fa4-4f03-4f2b-a480-172fef340d3f)
2025-01-16T13:39:58.5699297Z Dependency App exists
2025-01-16T13:39:58.5699999Z Processing dependency Microsoft_Base Application_23.0.0.0 (437dbf0e-84ff-417a-965d-ed2bb9650972)
2025-01-16T13:39:58.5717069Z Dependency App exists
2025-01-16T13:39:59.1307815Z Compiling...
2025-01-16T13:39:59.1624938Z .\alc.exe /project:"C:\ProgramData\BcContainerHelper\6a0b0534-6f5f-472c-bc5c-00937d1f0622" /packagecachepath:"C:\ProgramData\BcContainerHelper\f5f5d87e-0f2b-4714-b6a3-b112db4372ab" /out:"C:\ProgramData\BcContainerHelper\6a0b0534-6f5f-472c-bc5c-00937d1f0622\XXX_MYAPP_1.7.1.3.app" /GenerateReportLayout- /analyzer:C:\build\vsix\extension\bin\Analyzers\Microsoft.Dynamics.Nav.CodeCop.dll /analyzer:C:\build\vsix\extension\bin\Analyzers\Microsoft.Dynamics.Nav.AppSourceCop.dll /ruleset:C:\ProgramData\BcContainerHelper\6a0b0534-6f5f-472c-bc5c-00937d1f0622\ruleset.json /reportsuppresseddiagnostics /BuildBy:"BcContainerHelper,6.0.30" /assemblyprobingpaths:"C:\Program Files\dotnet\shared","C:\ProgramData\BcContainerHelper\Extensions\minimal.netPackages\Service"
2025-01-16T13:40:07.7188899Z Microsoft (R) AL Compiler version 14.2.19.4832
2025-01-16T13:40:07.7210001Z Copyright (C) Microsoft Corporation. All rights reserved
2025-01-16T13:40:07.7219793Z
2025-01-16T13:40:07.7230693Z Compilation started for project 'MYAPP' containing '70' files at '13:39:59.385'.
2025-01-16T13:40:07.7239797Z
2025-01-16T13:40:07.7517392Z ##[error]./C:/ProgramData/BcContainerHelper/6a0b0534-6f5f-472c-bc5c-00937d1f0622/src/src/tableextension/XXXSourceCodeSetup.TableExt.al(1,25): error AS0068: The target table of table extension 'XXX Source Code Setup' has changed from 'MissingTypeSymbol' to 'Source Code Setup'. Changing the target of a table extension that has been published is not allowed, because this might break the upgrade of existing installations.
2025-01-16T13:40:07.7519177Z
2025-01-16T13:40:07.7545603Z Compilation ended at '13:40:07.534'.
2025-01-16T13:40:07.7550870Z
2025-01-16T13:40:07.7591783Z App generation failed with exit code 1
2025-01-16T13:40:08.2696449Z Compile-AppInBcContainer Telemetry Correlation Id: e795fff9-515f-4900-b702-90fc51b964a5
2025-01-16T13:40:08.2733693Z ERROR App generation failed with exit code 1
2025-01-16T13:40:08.2737060Z Ignoring warnings
2025-01-16T13:40:08.2743373Z Ignoring infos
2025-01-16T13:40:08.8846355Z Copy C:\ProgramData\BcContainerHelper\26bffec1-c8cd-44b2-bfa3-d258ebebc81e\MYAPP_1.7.1.3.app to C:\ProgramData\BcContainerHelper\f5f5d87e-0f2b-4714-b6a3-b112db4372ab
2025-01-16T13:40:09.1953136Z 1 errors found in MYAPP_1.7.1.3.app on https://bcartifacts-exdbf9fwegejdqak.b02.azurefd.net/sandbox/23.0.12034.23046/w1:
2025-01-16T13:40:09.1963354Z App generation failed with exit code 1
2025-01-16T13:40:09.1963907Z
2025-01-16T13:40:09.1972324Z 1 errors found in MYAPP_1.7.1.3.app on https://bcartifacts-exdbf9fwegejdqak.b02.azurefd.net/sandbox/23.0.12034.23046/w1:
2025-01-16T13:40:09.1976425Z App generation failed with exit code 1
2025-01-16T13:40:09.1979990Z
2025-01-16T13:40:09.3097163Z ##[error]�[31;1m1 errors found in MYAPP_1.7.1.3.app on https://bcartifacts-exdbf9fwegejdqak.b02.azurefd.net/sandbox/23.0.12034.23046/w1:
App generation failed with exit code 1

Screenshots - CODE
Object is simple single field exrtension that hasn’t been changed for several releases.

tableextension YYYYYYYYYY "XXX Source Code Setup" extends "Source Code Setup"
{
    fields
    {
        field(YYYYYYYYYY ; "Field Name"; Code[10])
        {
            Caption = 'Field Name';
            DataClassification = CustomerContent;
            TableRelation = "Source Code";
        }
    }
}

Additional context

• it only happens on bc23

[freddydk]

Are you saying that it works in 24 and 25?
Then I will see that as a bug in v23 which has been fixed - not something I want to spend time on pursuing
If you have something that fails in the latest version like this - I would probably need a small example app, which shows the failure - it seems like I could be spending many days without ever finding the cause of this.

[iti-mikolaj-sledz]

Yes, we do not have this error on higher versions. However, our app needs to be compatible with 23, which is why we want to run ALCops on this version as well. Additionally, we have set the application and platform to 23 in the app.json file, which means that AppSource also validates on this version. Yesterday, we released a new version of this application on AppSource, and we wanted to check if the AppSource validation would also find this error. The app validated without any issues, so I assume it is a problem with Run-ALValidation itself.

[freddydk]

I assume that it is an error in the AL Language extension from that version.
You can try to add -vsixFile (Get-LatestAlLanguageExtensionUrl) to your Run-AlValidation, which will still validate for the version you specify, but use a newer AL Language Extension.