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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Upgrade from BC14 to BC18 failure Invalid Column Name $systemCreatedAt

(0) ShareShare
ReportReport
Posted on by 22

I am working on a NAV2018 to BC18 conversion for a client for OnPremises deployment.  The deployment worked flawlessly when running on a test server, but failed when we tried to do the production system upgrade.  Not sure what went wrong, but at the step when we try to run the Upgrade function, it errors out with the following:

pastedimage1623707738936v1.png

Note, it doesn't seem to uniformly fail at the same exact place, but it always fail with the task relating to the four new columns created in 2020 wave2 plus relating to these fields.

We have attempted to restart the process several times from the NAV2018 db and it keeps failing at about this stage of the process.  Timeout for SQL commands has been increased from 30min to 4h just in case.

OVerall the upgrade task fails at 58-65%.

I have the same question (0)
  • Frank Cormier Profile Picture
    22 on at
    RE: Upgrade from BC14 to BC18 failure Invalid Column Name $systemCreatedAt

    Thanks.  Running 18.2 resolved the issue.

  • Verified answer
    Gearoid Profile Picture
    on at
    RE: Upgrade from BC14 to BC18 failure Invalid Column Name $systemCreatedAt

    Hi Frank,

    There is a known issue with this error happening when UsePermissionSetsFromExtensions = False in the BC 18.x CustomSetting.config file. 

    I believe this was fixed in cumulative update 2 for BC 18.x. This can be downloaded from here: Download Update 18.2 for Microsoft Dynamics 365 Business Central 2021 Release Wave 1 from Official Microsoft Download Center 

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,846

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,683 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,214 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans