Rules to Better CRM Migration from 2015 to 2016 - 2 Rules

Make sure CRM 2015 update rollup 1 has been applied before upgrading to CRM 2016.

Note: You might come accross the error below while applying CRM 2015 update rollup 1.

Database update install failed for orgId = 011d5962-3475-4df9-a123-c3ecaf88b048. Continuing with other orgs. Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.</div><div>Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.

Solution:

• Make a backup of the file MetadataDiffs.xml from “C:\Program Files\Microsoft Dynamics CRM\Setup\Serviceability\Latest\Actions_Org\Install”
• Open the file MetadataDiffs.xml from “C:\Program Files\Microsoft Dynamics CRM\Setup\Serviceability\Latest\Actions_Org\Install”

• Remove the entry about the index “cndx_BusinessDataLocalizedLabel”. This is found at the very end of the file:

  <index Name="cndx_BusinessDataLocalizedLabel">
   <EntityId&gt;4ba1569e-3c9c-4d9f-99ea-b61fb08d7f97&lt;/EntityId>
   <IsClustered>1</IsClustered>
   <IsUnique>1</IsUnique>
   <IndexType>6</IndexType&gt;
  <IsPrimaryKey>0</IsPrimaryKe>
   <attributes>
     <attribute AttributeId="d88e1df3-b5b3-42f3-9ffa-007f22951dd4" IsSystemManaged="1" order="0" />
     <attribute AttributeId="bb23d3c8-8d18-40d3-9519-66101a8cae34" IsSystemManaged="1" order="1" />
     <attribute AttributeId="976e1053-5faa-4c3f-be6e-669acfec9d5a" IsSystemManaged="1" order="2" />
     <attribute AttributeId="e81341c4-4d4a-4977-98eb-6597fcde2cc4" IsSystemManaged="1" order="3" />
  </attributes>
  </index>

• Close Deployment Manager
• Start Deployment Manager
• Start the organization update from Deployment manager

• Run the following query on the organization DB to manually recreate the index

  IF EXISTS (SELECT * FROM sys.indexes WHERE name = 'cndx_BusinessDataLocalizedLabel' AND OBJECT_NAME(object_id) = 'BusinessDataLocalizedLabelBase') DROP INDEX [cndx_BusinessDataLocalizedLabel] ON [BusinessDataLocalizedLabelBase];
  IF NOT EXISTS (SELECT * FROM sys.indexes WHERE NAME = 'cndx_BusinessDataLocalizedLabel' AND OBJECT_NAME(object_id) = 'BusinessDataLocalizedLabelBase')
  BEGIN TRY
  CREATE UNIQUE CLUSTERED INDEX [cndx_BusinessDataLocalizedLabel] ON [BusinessDataLocalizedLabelBase]([ObjectId] ASC, [ObjectIdTypeCode] ASC, [ObjectColumnNumber] ASC, [LanguageId] ASC) WITH (FILLFACTOR = 80, MAXDOP = 4, SORT_IN_TEMPDB = ON, ONLINE = ON)
  END TRY
  BEGIN CATCH
  CREATE UNIQUE CLUSTERED INDEX [cndx_BusinessDataLocalizedLabel] ON [BusinessDataLocalizedLabelBase]([ObjectId] ASC, [ObjectIdTypeCode] ASC, [ObjectColumnNumber] ASC, [LanguageId] ASC) WITH (FILLFACTOR = 80, MAXDOP = 4, SORT_IN_TEMPDB = ON)
  END CATCH

• Restore the file MetadataDiffs.xml to its original state using the backup taken at step 1

Source: Error updating Microsoft Dynamics CRM 2015 0.1

CRM 2016 has many improvements over it's predecessors, including Power BI integration, improved navigation, and the new Outlook extension.

The procedure for upgrading CRM 2015 to 2016 is:

1. Apply Windows Update on CRM and Database servers
2. Go to CRM server | Deployment Manager | Disable CRM organization

   

3. Back up CRM organization database and configuration database
4. Go to CRM server | Control Panel | Uninstall "Microsoft Dynamics CRM Reporting Extensions"

   

5. Download CRM 2016 Server installation file and start the upgrade

   

   Note: It's better to have an empty demo organization to be upgraded first, so that you can test if the server upgrade has no issues.

   

   

   

   

6. Go to CRM setup directory | SrsDataConnector | Install 'Microsoft Dynamics CRM Reporting Extensions"

   

   

7. Go to CRM server | Uninstall "Microsoft Dynamics CRM 2015 Email Router"

   

8. Download CRM 2016 Email Router and install

   

   

   

You're now ready to roll with Microsoft Dynamics CRM 2016. If you had any trouble with this guide, please let us know with a rating of this rule.