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

Announcements

News and Announcements icon
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)
  • Verified answer
    Gearoid Profile Picture
    Microsoft Employee on at

    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 

  • Frank Cormier Profile Picture
    22 on at

    Thanks.  Running 18.2 resolved the issue.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,869 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,182 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,109 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans