Dynamics Community Forum Thread Details

Getting Start-Navappdataupgrade error in BC22

Getting below error while upgrading base application

Start-NAVAppDataUpgrade : Could not upgrade the extension 'Base Application' by 'Microsoft' from version '18.2.241521.0' to '22.1.241901.0' for tenant 'default' and company '' due to the following error: 'An
unexpected error occurred after a database command was cancelled.' and AL stack trace:
"Upgrade Plan Permissions"(CodeUnit 104030).AddPermissionSetToUserGroup line 6 - Base Application by Microsoft
"Upgrade Plan Permissions"(CodeUnit 104030).CreateMicrosoft365Permissions line 18 - Base Application by Microsoft
"Upgrade Plan Permissions"(CodeUnit 104030).RunUpgrade line 15 - Base Application by Microsoft
"Upgrade Plan Permissions"(CodeUnit 104030).OnUpgradePerDatabase line 2 - Base Application by Microsoft
"Upgrade Triggers"(CodeUnit 2000000008).OnUpgradePerDatabase(Event) line 2

Event viewer:

Statement: SELECT "2000000004"."timestamp","2000000004"."Role ID","2000000004"."Name","2000000004"."Hash","2000000004"."$systemId","2000000004"."$systemCreatedAt","2000000004"."$systemCreatedBy","2000000004"."$systemModifiedAt","2000000004"."$systemModifiedBy" FROM "SQLDATABASE".dbo."Permission Set" "2000000004" WITH(READUNCOMMITTED) ORDER BY "Role ID" ASC OPTION(FAST 50)
AppObjectType: CodeUnit
AppObjectId: 104030
AL CallStack: "Upgrade Plan Permissions"(CodeUnit 104030).AddPermissionSetToUserGroup line 6 - Base Application by Microsoft
"Upgrade Plan Permissions"(CodeUnit 104030).CreateMicrosoft365Permissions line 18 - Base Application by Microsoft
"Upgrade Plan Permissions"(CodeUnit 104030).RunUpgrade line 15 - Base Application by Microsoft
"Upgrade Plan Permissions"(CodeUnit 104030).OnUpgradePerDatabase line 2 - Base Application by Microsoft
"Upgrade Triggers"(CodeUnit 2000000008).OnUpgradePerDatabase(Event) line 2

RootException: SqlException
Invalid column name '$systemCreatedAt'.
Invalid column name '$systemCreatedBy'.
Invalid column name '$systemModifiedAt'.
Invalid column name '$systemModifiedBy'.

Categories:

Data Migrations

Quick Links

Leaderboard