Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Upgrade CRM 2011 to 20...
Customer experience | Sales, Customer Insights,...
Answered

Upgrade CRM 2011 to 2016 Failed halfway

(0) ShareShare
ReportReport
Posted on by Yiren95 15

Hi,

We are trying to upgrade our CRM 2011 to CRM 2016.

I knew that we have to do this incrementally (use backup DB file of currently running CRM 2011, restore that DB file on SQL Server machine for CRM 2013, and same for 2015 and finally 2016)

Problem is:

I already successfully restore the CRM 2011 DB (Organization DB Version : 5.0.9690.4376) into SQL Server for CRM 2013,
then perform "Import Organization" using CRM 2013 deployment manager, and then after the import completed successfully (Organization DB Version : 6.0.0.809), i backup the Organization DB again from CRM 2013 DB,
then go to SQL Server set for running CRM 2015, restore the database there, and again i perform "Import Organization" using CRM 2015 deployment manager, but this time i encountered error as below.

the log file have something like this:

19:00:56|Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=CRM-2016;Integrated Security=True;Initial Catalog=OURCOMPANYNAME_MSCRM;Connect Timeout=60 ...
19:00:56| Info| Database version: 6.0.0.809.
19:00:56| Info| Database OURCOMPANYNAME_MSCRM version is 6.0.0.809
19:00:56|Warning| Database OURCOMPANYNAME_MSCRM version is not supported.
19:00:56| Error| Check OrganizationDatabaseVersionValidator : Failure: This organization cannot be upgraded. You can only upgrade organizations that have a version of CRM that is no earlier than Microsoft Dynamics CRM 2013 Service Pack 1.

I don't know why the Version is not supported, it supposed to be CRM 2013 Version, so i think i'm using the right version.

Can anyone please help ?

Thanks Much,
Yiren

  • BB-07082110-0 Profile Picture
    BB-07082110-0 on at
    RE: Upgrade CRM 2011 to 2016 Failed halfway

    YAY!! Congratulations.. Now the fun part:)

  • Yiren95 Profile Picture
    Yiren95 15 on at
    RE: Upgrade CRM 2011 to 2016 Failed halfway

    Successfully migrated to 2016 and i can see the tables and data are still there.

    But some of the forms in CRM web page are customized from the previous developer, and those custom pages are still pointing into CRM-2011 IIS site.

    I think now that we successfully imported from CRM 2011 to CRM 2016 (still in testing environment though), next i will need to change some codes. (and i think will need SDK from CRM 2016, maybe different from CRM 2011)

    Really thank you Bethb26 for helping me :)

  • BB-07082110-0 Profile Picture
    BB-07082110-0 on at
    RE: Upgrade CRM 2011 to 2016 Failed halfway

    Nothing Custom within the CRM / Dynamics 365 should go away.  

  • Yiren95 Profile Picture
    Yiren95 15 on at
    RE: Upgrade CRM 2011 to 2016 Failed halfway

    Thanks Bethb26

    Yes, we do have some indexes and manually created procedures and tables.

    I can just hope those objects won't be gone, because the customized tables are used for some proccesses

  • Suggested answer
    BB-07082110-0 Profile Picture
    BB-07082110-0 on at
    RE: Upgrade CRM 2011 to 2016 Failed halfway

    The upgrade will get rid of whatever it doesn't "like" on indexes and procedures.   Did anyone put in manual indexes on SQL ?  It could be old outdated stuff but not a show stopper.  Just a warning as they won't be there usually after the upgrade.  

  • Yiren95 Profile Picture
    Yiren95 15 on at
    RE: Upgrade CRM 2011 to 2016 Failed halfway

    Thanks Much  Bethb26 ,

    Now i can go through 'System Checks' without error.
    Though i do got some warning, 

    Wish i can insert a screenshot in this reply, the warning is like  :
    1. The indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM indexes
    2. The stored procedures in the database are not consistent with Microsoft Dynamics CRM stored procedures.
    3. Fragmented indexes were detected in the Microsoft Dynamics CRM database
    4. Checking for customizations and extensions that use outdated features. This operation may take a few minutes.
    5. Data encryption will be active after the install or upgrade. We strongly recommend that you copy the organization encryption key and store it in a safe place. For more information, see http://go.microsoft.com/fwlink/?LinkId=316366.

    I think the warning is expectable since we have DB upgraded from another version of MSCRM.
    But im not sure what we should do to the "Index"  and "Procedures part. Or maybe it the CRM upgrade will do it automatically for us ?
    I'm glad if you have any feedback 

    Thankyou

  • Suggested answer
    BB-07082110-0 Profile Picture
    BB-07082110-0 on at
    RE: Upgrade CRM 2011 to 2016 Failed halfway

    If you read that last line of the error you need to ass SP1 to your 2013 before you can upgrade .  

    Microsoft Dynamics CRM 2013 Service Pack 1   is version # 6.1.0.0581

    The version numbers are here support.microsoft.com/.../microsoft-dynamics-crm-2013-updates-and-hotfixes-dd421ae8-c25e-b2dc-766b-cac45b3599fd

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans