SSW Foursquare

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

  1. Do you apply CRM 2015 update rollup 1 before upgrading to 2016?

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

    updaterollup1
    Figure: version after applying CRM 2015 update rollup 1

    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

  2. Do you know how to upgrade CRM 2015 to 2016

    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 disable org Figure: Disable organization ** **
    3. Back up CRM organization database and configuration database
    4. Go to CRM server | Control Panel | Uninstall "Microsoft Dynamics CRM Reporting Extensions" uninstall reportingextensions Figure: Uninstall CRM Reporting Extensions
    5. Download CRM 2016 Server installation file and start the upgrade upgrade demoorg Figure: Select the demo organization to be upgraded 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. upgrade successfully Figure: Successfully upgraded CRM server test demo org Figure: Quick test on the demo organization ** upgrade_businessOrg.png Figure: Upgrade business organization
      upgrade_org_successfully.png Figure: Successfully upgrade organization
      **
    6. Go to CRM setup directory | SrsDataConnector | Install 'Microsoft Dynamics CRM Reporting Extensions" install reporting extensions Figure: Install CRM Reporting Extensions upgrade_to_crm2016.png Figure: Successfully upgraded to CRM2016

    If using Email Router, do the following 2 steps to upgrade Email Router to 2016

    7. Go to CRM server | Uninstall "Microsoft Dynamics CRM 2015 Email Router" ![](uninstall_emailRouter.png)**Figure: Uninstall Email Router 2015** ** ** 8. Download [CRM 2016 Email Router](https://www.microsoft.com/en-us/download/details.aspx?id=50373) and install ![](install_emailRouter.png) **Figure: Install required components for Email Router 2016** ![](emailRouter_installtionFinish.png) **Figure: Successfully installed Email Router 2016** ** configurate_emailrouter_2.png Figure: Configure Email Router ** 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.
We open source. Powered by GitHub