US - Oregon Portland CRM

 View Only

8.2 to 9.1 upgrade errors (On-premise)

  • 1.  8.2 to 9.1 upgrade errors (On-premise)

    Posted Jun 21, 2022 02:07 PM
    We tried to upgrade our first environment from 8.2 On-premises to 9.1 On-premises and got errors.

    Install went fine and imported org fine as part of the install process, but then when we clicked Upgrade Org we got the following error:

    10:22:05|   Info| CrmAction execution time; UpgradeDatabaseAction; 00:01:04.6766865

    10:22:05|  Error| Installer Complete: OrganizationUpgrader - Error encountered

    10:22:05|  Error| Exception occurred during Microsoft.Crm.Tools.Admin.OrganizationUpgrader: Error.ActionFailed Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction


    Microsoft.Crm.CrmException: Error in Action: Bin\Microsoft.Crm.DataUpgrade.dll:TrackCustomDatabaseObjects on attempt 3. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.


    Did a little research and found someone with the same error suggesting to install these two items:

    1. Install Microsoft SQL Server System CLR Types.(X86 Package,X64 Package)
    2. Install Microsoft SQL Server Shared Management Objects.(X86 Package,X64 Package)

    We did that and reran upgrade process and still got the same error.

    Now when we try to reimport the org we a long list of errors about columns that are marked as "inconsistent with Dynamics 365 columns".


    tablename:                              actioncardbase

    columnname:                             recordidobjecttypecode2

    remark:                                 deleted column

    #DeploymentandImplementation #CustomerEngagement


    Allison Briden
    Business Systems Analyst
    Energy Trust of Oregon
    Portland OR

If you've found this thread useful, dive deeper into User Group community content by role