Dynamics 365 (on-premises), version 8.2 upgrade/import to v9.0.2 Failure

I have recently downloaded the MS on-premise installer for 9.0 which was released a few days ago, and I existing CRM servers set up and meeting the pre-requisites as stated here https://www.microsoft.com/en-us/download/details.aspx?id=57478&WT.mc_id=rss_alldownloads_all under System Requirements

The installation was successful, and I was able to create new vanilla organizations with no issues, but I cannot import (upgrade) any of the organizations from 8.2.2.  Here are some of the errors:

The following connections need to be closed before setup can continue:  Login: server\Administrator, Host: serverxxx.mmc, Database: xxxx_MSCRM  User: Administrator, Program: MSCRMmmc (seems like this is deployment manager?)
Error| Upgrade Organization with Id=xxxxxxxxxxxxxxxxx failed with Exception:

System.Exception: 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=11.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxx' or one of its dependencies. The system cannot find the file specified.
   at Microsoft.Crm.DataUpgrade.DatabaseObjectChangeTracker.GenerateScriptForIndex(String tableName, String indexName, ISqlExecutionContext sqlContext)
   at Microsoft.Crm.DataUpgrade.DatabaseObjectChangeTracker.InsertObjectTrackerTableInput(List`1 inputData, String tableName, ISqlExecutionContext sqlContext)
   at Microsoft.Crm.DataUpgrade.DatabaseChangeTracker.TrackCustomDatabaseObjects()
   --- End of inner exception stack trace ---

The AttributeLookupValue (Id=81cde1dc-2241-db11-898a-0007e9e17ebd) entity or component has attempted to transition from an invalid state: ComponentStateName: Solution; ComponentOperation: Delete; ComponentSolutionType: Active; SolutionOperationContext: MoveSystemComponentToFirstPartySolution; IsProtected: False; FinalComponentState: Publish.

 An error occurred when trying import and upgrade organization database server.xxxxxx_MSCRM:
Microsoft.Crm.CrmException: Upgrade Organization with Id=1xxxxxxxxxxxxxxxxxx failed with Exception:
System.Exception: 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=11.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxx' or one of its dependencies. The system cannot find the file specified.

Therefore at present  8.2.2 org imports will fail when you attempt to do so and this looks a bug with the v9 on premise package.

Solution:


From  the Server Version 3020 (Insider) and 3034 (release). There is a bug in the Marketing Managed Solution. The script is the same but the version of the solution is a another.

This affected solution is found here: C:\Program Files\Dynamics 365\Setup\Serviceability\Latest\Actions_Org\Install\Packages\CRMApps\PkgCache_9_0_0002_3034\msdynce_MarketingSales\msdynce_MarketingSales

Option B:

Another option will be uncomment the marketingsales upgrade package in:

C:\Program Files\Dynamics
365\Setup\Serviceability\Latest\Actions_Org\Install\Packages\CRMApps\PkgCache_9_0_0002_3034\msdynce_MarketingSales\msdynce_MarketingSales\ImportConfig.xml

<!--<configsolutionfile solutionpackagefilename="msdynce_MarketingSalesPatch_managed.cab" publishworkflowsandactivateplugins="true" />-->

One of the above solutions will fix your issue.

Enjoy V9 on-prem



Comments

Popular posts from this blog

Dynamics 365 - Dashboards – You do not have enough privileges to access the Microsoft Dynamics CRM object or perform the requested operation.

Dynamics 365 App for Outlook 404 Authentication Issue from Outlook Desktop